cell location inside array

Copper Contributor

hi, everybody i am working on a table array which contain many value
i used the max formula to determinate the maximum value
now i need to know the location of this value (the row and the column) and if i have two or three same values also I need the location
is it possible to do that?

2 Replies
yes, sorry for that duplication