Excel formula to calculate MIN in table filtered

0 votes

I have a Table that can be filtered by 1 column values, and want to create a cell that calculates the MIN when filter is applied.

Nº cell A B
2 car 2
3 Moto 30
4 Moto 20
5 car 30
6 Moto 4
7 car 10

So I can calculate min with =MIN(B2:B7) , but I want to create a cell to calculate the min in both cases:

Filtering "car": B will show cells 2,5 and 7 so MIN= 2

Filtering "moto": B will show cells 3,4,6 so MIN=4

Jan 30, 2023 in Others by Kithuzzz
• 38,000 points
508 views

1 answer to this question.

0 votes

Try this:

=SUBTOTAL(105;B2:B7)
answered Jan 30, 2023 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
1,091 views
0 votes
1 answer

Moving Average formula in Excel not autofilling in table

You could use AVERAGEIFS to make the ...READ MORE

answered Oct 2, 2022 in Others by narikkadan
• 63,600 points
1,337 views
0 votes
1 answer

Convert table in a jpg image to excel using python

I believe you must execute OCR (optical ...READ MORE

answered Oct 16, 2022 in Others by narikkadan
• 63,600 points
2,300 views
0 votes
1 answer

Excel formula to calculate contribution

For several component numbers, you may obtain ...READ MORE

answered Oct 17, 2022 in Others by narikkadan
• 63,600 points
1,171 views
0 votes
0 answers

Excel: How to Sort or filter text by specific word or words?

Even if the term is used in ...READ MORE

Nov 27, 2022 in Others by Kithuzzz
• 38,000 points
606 views
0 votes
1 answer

Excel Function to Exclude rows based on certain values

One method is to combine the FILTER() ...READ MORE

answered Jan 23, 2023 in Others by narikkadan
• 63,600 points
7,692 views
0 votes
1 answer

Filter outlook sent items in vba failing for emails with multiple recipients

The PR DISPLAY TO parameter provides a ...READ MORE

answered Feb 21, 2023 in Others by narikkadan
• 63,600 points
802 views
0 votes
1 answer

Copy data with filter applied using Excel VBA

Try this: Private Sub CommandButton1_Click() Dim ...READ MORE

answered Mar 19, 2023 in Others by Kithuzzz
• 38,000 points
541 views
0 votes
1 answer

Pivot Chart Table in Excel To Calculate the Count and Display the Chart

It should look something like this: READ MORE

answered Nov 6, 2022 in Others by narikkadan
• 63,600 points
866 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP