View Single Post
  #1   Report Post  
Tetsuya Oguma
 
Posts: n/a
Default Look for the first non-blank cell above!

Hi all,

What would be the formula to locate the cell of the first non-blank cell
above?

I was playing with MATCH function but the first parameter doesn't take
zero-length string ("")!

Cheers,
---
Tetsuya Oguma, Singapore