no need to write macro
sort any one column
and use lookup to other column
that will work fine
On Sat, Mar 12, 2011 at 6:06 AM, bpascal123 bpascal...@googlemail.comwrote:
Hi cyberspace,
I have spent quite some time trying to make this work but at this
point from adding many msgbox checks,
use this in Column C:C
=IFERROR(VLOOKUP(A1,B:B,1,0),)
Rajan.
On Sat, Mar 12, 2011 at 3:42 PM, Sanjoy Nath sanjoy.nath...@gmail.comwrote:
no need to write macro
sort any one column
and use lookup to other column
that will work fine
On Sat, Mar 12, 2011 at 6:06 AM, bpascal123
Hi Ayush,
I have been working on MS Office since last 4 Years(Maximum on
Excel,Access,PPT)
I plan to take up the Microsoft Certification Examination.
Please guide me with the below questions, also suggest if I have missed any
thing
1. What certification exam I should appear for ?
2.
Hi Bharat,
Please see the answers below :
1. Microsoft Office
Specialisthttp://www.microsoft.com/learning/en/us/Exam.aspx?ID=77-888Locale=en-us#tab2
2. On Microsoft
websitehttp://www.microsoft.com/learning/en/us/Exam.aspx?ID=77-888Locale=en-us#tab3
3. They are practical exams, you should
Hey folks,
I am new to Excel programming and using oorexx to read a column of
cells in a worksheet checking for certain values and setting the
background color when the value matches. The code I have written works
fine, but being that it calls from rexx to an xlobj for each cell it
is not perhaps
Tell me please how can an excel formula add rows ?
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
This is excellent idea! Thanks J
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ayush
Sent: Tuesday, March 01, 2011 8:10 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel Interview Q A
Hello Members,
Since Excel skill is tested
Have any of you seen the new Powerpivot function in Excel 2010? I took the
tutorial here http://technet.microsoft.com/en-us/library/ff452206.aspx
this is such a valuable tool for combining various excel spreadsheets from
various databases into one Pivot Table/Chart.
Hope this info finds interest
Thanks for the reminders! J,,, I know I like it when the Subject box
includes the title of the problem/issue. Very helpful!
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ayush
Sent: Tuesday, March 01, 2011 8:49 AM
To: excel-macros@googlegroups.com
Thank you STDEV(i)!. $B$3:B3 is what was needed to lock it. Formula works
in column C as well. Double fixed!! J
~Susan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of STDEV(i)
Sent: Friday, March 11, 2011 11:17 PM
To:
Dear All,
I want today's date in next column (column B) on the day when first column
( column A) was updated.
for Ex. if A3 was updated on 14th Mar'11 then B3 should display that date.
If i open this file on 16th Mar'11 then also B3 should display 14th Mar'11
and not 16th Mar'11.
Appreciate i
Dear All,
I want to update the status in master file from various users. The user
files are located in particular folder but the count and name of these user
is not define. Hence all records in master file should search all the user
file (in same folder and in same format) and update the status
Help!
I'm getting this error in my spreadsheet. In my workbook. In all my
workbooks. And I don't know why! I think my kids were playing around
on my computer and touched something.
I have not built any macros or code at all. How do I get rid of
this?
Every time I hit enter in a new
Hi,
Can anyone send me some good study material to learn Advance Arrays in
VBA..??
Thanks
Deepak
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
14 matches
Mail list logo