find min value depending on range

richardlit

New Member
Joined
Dec 31, 2009
Messages
6
Hi

I need to find the minimum value in row 2 for each account in row 1, for example

row 1 row 2
111 50
222 20
333 80
444 40
111 40
222 50

Results would show 111 with a minimum value of 40, 222 with a minimum value of 20 etc etc

I would prefer a formula that does not use an array or VBA.

your help is greatly appreciated!

Thanks
Richard
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

richardlit

New Member
Joined
Dec 31, 2009
Messages
6
Thanks for the quick response!

I need the results to show in row 3 for each number. For example

row 1, row 2, row 3 (row 3 is the minimum value in row 2 where value in row 1 is the same)
111, 50, 40
222, 20, 20
333, 80, 80
444, 40, 40
111, 40, 40
222, 50, 20

Hope this makes sense.

Thanks
Richard
 

richardlit

New Member
Joined
Dec 31, 2009
Messages
6
Hi

This works but slows down my spreadsheet drastically (I'm not sure if this is because it is an array or the number of rows, currently around 80,000).

Is there a different formula e.g. IF statement or INDEX MATCH function?

Thanks
Richard
 

Watch MrExcel Video

Forum statistics

Threads
1,108,842
Messages
5,525,171
Members
409,629
Latest member
McGuilliam

This Week's Hot Topics

Top