Hello,
I am trying to write a formula to give me the column number of the furthest non-blank field in each row. My cells have dates as data and some of them are the same date.
I want to get the column number so I can write a formula to tell me the column title on column to the right of the furthest non-blank column. For example in my attachment for row 2 it would display "SENT PO TO ROY", which I need help with as well. Any help would be greatly appreciated!
I have tried
=MAX((3:3<>"")*COLUMN(3:3))
and
LOOKUP(9.99999999999999E+307,B1:E1)
which works but I need the actual column number, not the cell data
Does anyone know how to do this?
File I am trying to do this with is attached.
Bookmarks