B
BillyRogers
I'm trying to find the cell address of the first non-empty cell in a row.
This formula gives me the the position within the range of the first non
empty cell but not the cell address
=MATCH(TRUE,H16:AB16<>"",0)
it simply returns and interger such as 4 when the fourth cell in the range
is the first non empty cell.
somehow I need to take that and convert it into a cell address
Thanks,
--
Billy Rogers
Dallas,TX
Currently Using SQL Server 2000, Office 2000 and Office 2003
This formula gives me the the position within the range of the first non
empty cell but not the cell address
=MATCH(TRUE,H16:AB16<>"",0)
it simply returns and interger such as 4 when the fourth cell in the range
is the first non empty cell.
somehow I need to take that and convert it into a cell address
Thanks,
--
Billy Rogers
Dallas,TX
Currently Using SQL Server 2000, Office 2000 and Office 2003