Unique Value of filtered rows in another cell(s)

Deepakchoudhary

New Member
Joined
Dec 20, 2010
Messages
31
Hi,
Applying FILTER in a table which included name of retail outlets and their town names. At bottom of table somewhere in a cell for a purpose I want to show "filtered" town name while apply filter on a town ... and my purpose is... I will put a "vlookup" with this to pull data from another table of town name list with population ( I have population data table but it is town wise).

Any suggestion please...
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Deepakchoudhary

New Member
Joined
Dec 20, 2010
Messages
31
I have googled and my friend also suggested for below formula... it is working well for my purpose... (Array formula with {...})

=INDEX(C:C,MIN(IF(SUBTOTAL(3,OFFSET(C3,ROW(C3:C478)-ROW(C3),0)),ROW(C3:C478))))
 

Watch MrExcel Video

Forum statistics

Threads
1,099,795
Messages
5,470,830
Members
406,727
Latest member
Kimze

This Week's Hot Topics

Top