Index & Counta formula problem
Bob
Try
=IF(ISERROR(MATCH(,B35:B39,-1)),"No Sources",INDEX(B35:B39, MATCH(0,
B35:B39, -1), 1))
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"rleonard" wrote in message
...
Rob,
If all entries are blank, how can I change formula so it does not return
#N/A
Formula worked once I began entering entries in cells.
Instead of returing #N/A could it return "No Scores"
Thanks
Bob Leonard
|