ExcelBanter - View Single Post - getting the number of the row with the maximum value

Thread: getting the number of the row with the maximum value

View Single Post

#3

Report Post

P Sitaram

Posts: n/a

Default

=ROW(INDEX(A1:A100,MATCH(MAX(A1:A100),A1:A100,0)))

Reply With Quote

Reply With Quote