ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   finding index (https://www.excelbanter.com/excel-worksheet-functions/179338-finding-index.html)

mickimick11mick

finding index
 
i need to find out the index of the maximum value in a specific column, how
do i manage that?

thanks


Gary''s Student

finding index
 
=MATCH(MAX(A:A),A:A,0)
--
Gary''s Student - gsnu200772


All times are GMT +1. The time now is 08:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com