More MIN() results..?
Having several columns of values and under each its MIN cell, if there are
more (like the minimum value for a column is 12 and it appears in 10 rows out of 200), how do I go about showing each of them with its respective row number in the MIN() result? |
More MIN() results..?
You could maybe use
=ADDRESS(MATCH(MIN(A1:A200),A1:A200,0),COLUMN()) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mac" wrote in message ... Having several columns of values and under each its MIN cell, if there are more (like the minimum value for a column is 12 and it appears in 10 rows out of 200), how do I go about showing each of them with its respective row number in the MIN() result? |
All times are GMT +1. The time now is 04:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com