View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HERNAN HERNAN is offline
external usenet poster
 
Posts: 103
Default IS THERE ANY FORMULA IN EXCEL THAT CAN DO THIS? HLOOKUP MAYBE?

A formula that:
Finds the first number in the row bigger that "10", and when it finds it
return the value on the same column but on row 1 (for the next row also
always row 1)

Ie: Column A has already the results I want.

Result B C
1 1/1/2009 2/1/2009

3 2/1/2009 2 12
4 1/1/2009 11 15
5 2/1/2009 -2 25