Hi all,
I'm trying to put together a formula that looks for the first blank cell in a range, then returns the Header Title from that row (this second part will come later). The problem I'm coming across is getting Excel to return the position this is. I'm using the MATCH function to return where this cell is. I've been trying:
But this always returns an N/A error. Does anyone know another means of returning the blank cell's position with MATCH or some other function?Please Login or Register to view this content.
TIA,
SamuelT
Bookmarks