View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aussie Bob C Aussie Bob C is offline
external usenet poster
 
Posts: 24
Default Find first value in column with formulas

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.