LinkBack URL
About LinkBacks
Hi
I have been using the "MATCH" formula to determine the last time a number appeared in the lottery draws, but i have to do the for each column separately.
Is there a way to do this with 1 function.
Please see attached workbook.
Thanks in advance
Hi
I have been using the "MATCH" formula to determine the last time a number appeared in the lottery draws, but i have to do the for each column separately.
Is there a way to do this with 1 function.
Please see attached workbook.
Thanks in advance
May be in J3:
=IF(ISNA(MATCH($I3,A$3:A$9,0)),"----",MATCH($I3,A$3:A$9,0))
Copy down and across.
Quang PT
J3:
=IFERROR(MATCH($I3,A$3:A$9,0),"----")
Copy across and down.
I usually play lotteries, especially Australian lotteries, because sometimes I win. I recommend you to read this site australian-lotto-results.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks