Formula to look for a value (in text format) depending on condit

Resolved · Urgent Priority · Version 2010

Thu 1 Feb 2018, 11:36 Delegate Silvia said...

Silvia has attended:
No courses

Formula to look for a value (in text format) depending on condit

Hello,

I constantly come across this issue when building a dashboard, and spend hours trying to figure it out to then abandon it altogether.

Basically, I would like a formula that lists the most popular brands based on the number of times it appears in the database, based on the two factors - the company group, which you can select on the drop down menu of the dashboard.

I am not sure, if i am making much sense. But, i have tried to use the INDEX MATCH formula, but it only works on the first row and after that it just gives me the same value, or in this case, brand.

PLEASE HELP!!

thanks

S

Thu 1 Feb 2018, 15:24 Trainer Richard said...

RE: Formula to look for a value (in text format) depending on co

Hi Silva

That does make sense.
Trying to use a formula to display multiple lines is rather difficult.

Have you considered using a small pivot table filtered to the top items? That might be easier and more adaptive than a formula.

That would be one technique recommend on our Dashboard course.
https://www.stl-training.co.uk/syl/160/excel-dashboards-business-intelligence.html

Kind regards

Richard Bailey
Microsoft Certified Trainer

Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Creating custom lists

In Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc.

This list has come from Tools- options and Custom lists.

Therefore to save time and create your own list you can click on New (in Tools and custom list tab) and type out the lsit that you want copied quickly.

All you have to do is then type in the 1st word and you will be able to copy the rest of the list quickly.

View all Excel hints and tips