Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find first value in column with formulas
Try this array formula
=MATCH(1,--(LEN(D2:D20)0),0) -- __________________________________ HTH Bob "Aussie Bob C" wrote in message ... Columns D & H contain an IF formula. Column D Formula =IF(C2="Diners",B2,"") Column H Formula =IF(C2="Westpac",B2,"") The first row containing a dollar value in either of columns D & H could be two or ten rows down. How do I program to locate the first cell that contains a dollar value skipping over "empty" cells containing the formula only. -- Thank you Aussie Bob C Little cost to carry knowledge with you. Win XP SP3 Office 2007 on Mini Mac using VMware. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
find last row value in column when using MATCH to find column | Excel Worksheet Functions | |||
Find something in column a then find if column B matches criteria | Excel Discussion (Misc queries) | |||
Find last column, move formulas over, copy/paste data | Excel Worksheet Functions | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions |