Question

Locked

Excel,=LOOKUP,HELP

By DrJ_the_knife ·
I need a formula to display the last data in a column if that particular cell is blank, between set ranges of 48 in a column. THEN SEARCH BETWEEN A48 DOWN TO A1 AND DISPLAY THE LAST DATA IF NO DATA THEN DISPLAY NOTHING.

I can't find the answer to this, can someone help?

Just found a solution without the if not data display nothing

=LOOKUP(48,1/(A1:A48<>""),A1:A4

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums