Hi,
I would like to find a way to write a formula that will return the value of the last non-empty cell in the column. I have three header rows that are criteria.
MATCH(Display!$I$3&Summary!$M$8&Summary!$M$6,INDEX(JCB!$C$1:$CB$1&JCB!$C$2:$CB$2&JCB!$C$3:$CB$3,0),0)
This formula gives the position of the desire column. however ,need to be retrieve the value of the last non-empty cell in this column.
Thanks in advance for any/all advise.