# Find MIN Value and Recalculate Costs - VERY LARGE SPREADSHEET with Multiple Customers

#### Maureen5433

##### Board Regular
Hello,

I am a little desperate as I need to have this done by tomorrow noontime. I have a spreadsheet with about 80,000 line items and I need to find some values and recalculate costs. Back story is that it is possible that a vendor increased our pricing without our knowledge. In order to get an estimate of the economic impact this may have had, I need to find the MIN value for each customer for each item. I know this is confusing so I have posted a sample that I hope helps. The issue is that this spreadsheet is quite large so I need to automate this process. In my example, the thick borders separate out my data. For each group, I need to find the minimum value in Col J (billed cost) and then use that minimum value to recalculate what we believe we should have been charged by taking the Ship Qty (Col H) * the lowest cost we were charged for the item for that customer.

I am sorry if I am not explaining correctly. Hoping my example helps.

Thank you so much for reading and for any ideas. Maybe I am overcomplicating this a bit but I am just not coming up with a way that handles all the little issues.

I appreciate any and all help.

Thank you!
M

### Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

#### Maureen5433

##### Board Regular
DISREGARD

I have solved my problem.

I was thinking too hard.

Thank you!

Replies
2
Views
95
Replies
0
Views
123
Replies
11
Views
136
Replies
0
Views
201
Replies
15
Views
284

1,148,237
Messages
5,745,555
Members
423,959
Latest member
Bismarkmensah

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back