Hi
I have seen several examples where OFFSET or COUNTA are used to find last cell containing either a text OR a numeric value
I want it to find ANY value. As the users may cut my sheet up in all sorts of ways.
Most use MATCH("*" for text or MATCH(1E+306 for numeric
I can't use COUNTA as the user may leave gaps.
Would like a dyanmic INDEX or method to find the last cell that is not blank ? (and using "<>""" only works for text, wont detect numbers!)
Help appreciated
ALSO...what are the codes to represent a very large number in excel 9E+ or something? Seen people using them in MAX and MIN functions to find largest and smallest items? Also use 255 and Z code mixes for matching
Thanks
I have seen several examples where OFFSET or COUNTA are used to find last cell containing either a text OR a numeric value
I want it to find ANY value. As the users may cut my sheet up in all sorts of ways.
Most use MATCH("*" for text or MATCH(1E+306 for numeric
I can't use COUNTA as the user may leave gaps.
Would like a dyanmic INDEX or method to find the last cell that is not blank ? (and using "<>""" only works for text, wont detect numbers!)
Help appreciated
ALSO...what are the codes to represent a very large number in excel 9E+ or something? Seen people using them in MAX and MIN functions to find largest and smallest items? Also use 255 and Z code mixes for matching
Thanks