ChristianDK
New Member
- Joined
- Jul 17, 2018
- Messages
- 4
Hi
I am new here in this forum, so if I'm not doing it right please do tell.
The best solution to my problem is if Microsoft adds/have a subtotal-if function to excel.
What I am trying to do it combine the two as I only want to look at specific rows, and at the same time return the minimum value of all the specific rows.
I have made a simple example of my problem:
<tbody>
</tbody>
The formula I am looking for is for row "Best price" where I need excel to look at all the rows with the same car# and return the lowest price, so the subtotal formula then returns the minimum value, but only take into account rows if the car# is a match.
I have filled out "Best price" manually to show want I am trying to do.
In my real data, I got more than 24.000 rows that I need to sort out and my boss is on my back big time, so I really hope a kind soul will help me out.
Thank you in advance.
Br. Christian
I am new here in this forum, so if I'm not doing it right please do tell.
The best solution to my problem is if Microsoft adds/have a subtotal-if function to excel.
What I am trying to do it combine the two as I only want to look at specific rows, and at the same time return the minimum value of all the specific rows.
I have made a simple example of my problem:
Car# | Price | Best price |
1 | 100 | 100 |
2 | 150 | 125 |
3 | 200 | 150 |
3 | 150 | 150 |
2 | 125 | 125 |
1 | 125 | 100 |
<tbody>
</tbody>
The formula I am looking for is for row "Best price" where I need excel to look at all the rows with the same car# and return the lowest price, so the subtotal formula then returns the minimum value, but only take into account rows if the car# is a match.
I have filled out "Best price" manually to show want I am trying to do.
In my real data, I got more than 24.000 rows that I need to sort out and my boss is on my back big time, so I really hope a kind soul will help me out.
Thank you in advance.
Br. Christian