Find first value in column with formulas

[Aussie Bob C]

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.

 

[Aussie Bob C]

Bob

Your formula appears to count the "empty" Cells down too, but not including
the first dollar value.

I'm after the first dollar value in the column.
It should of returned a $169 value but showed the number 11 which is the
same number of "empty" rows before the $169 value.
--
Thank you

Aussie Bob C
Little cost to carry knowledge with you.
Win XP P3 Office 2007 on Mini Mac using VMware.

 

[Rick Rothstein]

Try this array-entered** formula then...

=INDEX(D120,MATCH(1,--(LEN(D120)>0),0))

**Commit formula using Ctrl+Shift+Enter, not just Enter by itself

 

[Aussie Bob C]

That did the trick.
--
Thank you

Aussie Bob C
Little cost to carry knowledge with you.
Win XP P3 Office 2007 on Mini Mac using VMware.