98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - Advance Filter
Excel - Advance Filter
Resolved · Medium Priority · Version 2003
Nathan has attended:
Excel Advanced course
Excel - Advance Filter
Hi,
I'm trying to use the advance filter to arrange data using a number of variables. I won't use the actual sata that I'm trying to sort but the info below basically explains what I'm trying to do. From the info below I want to filter the data to show the following:
- All sales made by Richard, Fatima and Ravi
- Made only in the UK and America
- Made only during the month of January
This is how I've set the advance filter up. However it doesn't work as it just ends up showing the sales for Ravi and nothing else. Any help would be appreciated. Thanks
Month Agent Product Value
January Richard UK
Fatima America
Ravi
Month Agent Product Value
January April America £2,356
January Andy America £3,584
January Callum Western Europe £1,124
January Kelly Eastern Europe £1,025
January Richard Pacific £4,788
January Carly Eastern Europe £2,369
January Felicity Pacific £5,987
January Fatima Eastern Europe £2,485
January Ina Pacific £6,241
January Yvonne America £2,356
January Mary America £5,698
January Louise Pacific £6,325
January Harry Western Europe £4,469
January Keith America £3,584
January Bryan UK £2,247
January Ravi America £1,025
January Wendy Pacific £4,788
January Natalie America £2,369
January June UK £1,547
January Tyrone Scandinavia £2,257
January Jacob UK £1,025
January Nathan Africa £1,585
January Cassie Pacific £6,241
January Uma America £2,356
January Richard UK £1,245
January Louise UK £998
January Bryan Western Europe £1,155
January Bryan Eastern Europe £1,878
January Syrah UK £996
January Syrah Eastern Europe £1,547
February Bevan Western Europe £3,325
February Kathie America £5,536
February Paul Eastern Europe £2,369
February Bevan America £2,356
February Marina Eastern Europe £1,025
February Marianne UK £1,025
February Sian Western Europe £1,124
February Sian Eastern Europe £4,469
February Sian America £3,584
February Trevor Eastern Europe £1,547
February James Pacific £6,241
February Greg UK £998
February Ben Eastern Europe £1,255
February April Western Europe £1,299
February Andy Western Europe £1,545
February Callum Africa £1,167
February Kelly Western Europe £1,099
February Callum Western Europe £1,124
February Kelly Eastern Europe £4,469
February Bryan Pacific £4,788
February Ravi Eastern Europe £1,547
February Wendy UK £1,025
February Richard Western Europe £1,585
February Carly Pacific £6,241
February Felicity Western Europe £1,155
February Fatima Eastern Europe £1,025
February Ina UK £1,025
February Yvonne Western Europe £1,124
RE: Excel - Advance Filter
Hi Nathan,
Looking at your data your advanced filter should have also returned Jan Richard UK as there is a record for that. Ravi will have returned everything for Ravi and nothing for Fatima as she does not have any sales in america.
Send me the file, ill fix this for you and send it back so you can see how I would set it up.
send the file to paul@microsoftexcel.net
Cheers
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Creating custom listsIn Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc. |