Formula:
=HYPERLINK("#"&ADDRESS(SUMPRODUCT(ROW(A5:AO300)*(A5:AO300=A1)),SUMPRODUCT(COLUMN(A5:AO300)*(A5:AO300=A1))),"Link")
Formula:
=HYPERLINK("#"&ADDRESS(SUMPRODUCT(ROW(A5:AO300)*(A5:AO300=A1)),SUMPRODUCT(COLUMN(A5:AO300)*(A5:AO300=A1))),"Link")
If your questions has been answered to your satisfaction please don't forget to do the following:
Add Reputation ... and ... Mark Thread as Solved
Thanks,
Ma 10:8b Freely you have received; freely give.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks