ST Alpha - "Excel point me in the right direction question." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 154

Excel point me in the right direction question.

Posted by Dano (aka dano) Oct 7 '21, 13:33

I can research and experiment, but looking for what direction I should be looking.

Say I have a spreadsheet with columns...
First-Middle-Last-Age-Height-Hair-Gender-Weight

I want to be able enter Hair = Blonde and be able to get the First-Middle-Last of everyone who matches that.

Once I have that I want to be able to get First-Middle-Last of everyone whose Weight is 150.

I have a lot more columns than that and my attempts using LOOKUPs have gotten complicated very quickly. Any ideas of what functions I should be looking at? Maybe a Pivot Table?

This is really better suited for a database, but Excel is what I have to work with.

Responses:

QUERY. Here's an example -- (link) - Max Oct 7, 13:39 [youtube] 2
- Here's another example of using Query to build a dashboard. -- (link) - Max Oct 7, 14:16 [youtube]
- I will look at that. I have a Pivot Table kind of working, but it has a lot of filter options. -- nm - Dano Oct 7, 13:45
Couldn't you just use the in place Filter feature? It's on the Data tab in the Ribbon. You just then get drop downs on each column header - oblique Oct 7, 13:37 1
- It's a bit brute force but depending on how many scenarios you need and what you're going to do with the results ... this is what I'd do too -- nm - rollo Oct 7, 14:29

Post a message top

Excel point me in the right direction question.

Replies are disabled on threads older than 7 days.