excel question: can this be done?

[Lorax]

so i'm using excel and was wondering if there is an easy way to do the following:

i have a column of data, and the rows (each representing a day) will either be blank or have the number 1 in them.

is there a function that will find the last day in which there was a 1 entered, then display that day?

thanks

 

[KK]

probably, but I don't know.

:beer:

KK

 

[conjur]

Originally posted by: KK
probably, but I don't know either.

:beer:

KK

Try the Software forum.

 

[minendo]

Write a macro.