Another Minor Excel Query! (VoG? Whisperer?)

  Ben Avery 09:11 03 Sep 03
Locked

G'day

I have a flight plan spreadsheet with filters on it but I need to run a filter which takes 2 criteria from 2 different columns (hence the auto filter is no help).

In column "C" I have "Work Location" and in column "K" I have # signs to denote those who travel Business Class and * signs for something else.

I need to filter the sheet to show the following:

1) All personnel working in the Training Department section in column "C"

AND

2) All personnel who currently travel Business class (those who have a # sign in column "K")

The trouble I have, only being used to the auto filter, is that I can set the filter to select one or the other criteria but not both together as when the auto filter selects the "Training Department" personnel, those with # signs in column "K" get hidden as they are not part of this department.

How do you do this?

;o)

BA

  Ben Avery 11:36 03 Sep 03

^bump^

Come on guys, you normally love getting ya heads round these sort of things!

:o)

BA

  VoG II 12:57 03 Sep 03

You need to use Data/Filter/Advanced filter to do this.

It would take far too long to explain how to do this. Have a look in Help for Advanced Filter - there are instructions and examples.

Good luck!

  Ben Avery 13:01 03 Sep 03

Is it seriously that complicated?!

You'd think it'd be obvious that people would want to do this and that it'd be a relatively easy thing to accomplish!

I did have a look at the help section but ended up chasing my tail - I'll have another browse through and try to get my head round it!

Thanks chap.

BA

  Ben Avery 09:03 04 Sep 03

I've sorted it by re-reading and re-reading the help section until it clicked what it was trying to say!

All done now so thanks VoG for getting me to re-read it and understanding how it works.

BA

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Here's what should be coming to Adobe Project Felix in 2017

Apple AirPods review: Apple's beautiful new Bluetooth headphones bring true intelligence to…