If, for say, I use a basic formula to identify the MAX between A1 to A300 and I got the result.. Is there any function which shows me the MAX location?
If, for say, I use a basic formula to identify the MAX between A1 to A300 and I got the result.. Is there any function which shows me the MAX location?
=match(max(a1:a300), a1:a300, 0)
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks