Year to Date

[maxthebear]

Hi All:

I have each date (1/1/2011, 1/2/2011) running down A1, A2, A3 etc. Values are in B1, B2, B3. Trying to come up with a working YTD formula. Any help is appreciated.

Max

[NBVC]

If you are just looking for the last numeric entry in column B (assuming there is a value for each date and that dates are in ascending order), then try:

=Lookup(9.99999e+307,B:B)

[royUK]

Here's some example YTD formulas