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
547 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,187 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,426 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,364 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,270 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
641 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,938 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
876 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
585 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
919 views
0 votes
1 answer

In MS Excel what formula can be used to calculate growth when CAGR for the period is already given?

If those are true CAGR's, then just ...READ MORE

answered Nov 20, 2022 in Others by narikkadan
• 63,600 points
1,014 views
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