Hi,
I currently have formula
=INDIRECT("'data 24'!A"&(COUNTA('DATA 24'!$A:$A)-(ROW($A$14)-ROW($A4)))+2)
this looks at sheet 'data 24' and picks up data from column A the 12th from last entry.
However I have a number of entries that are '0' I would like to ignore these and pick up the 12th last 'text' entry,
how can I amend the formula to look only for text, rather than numbers??
Any help greatly appreciated
Many thanks
Bookmarks