We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Excel table help
keithdc
Posts: 459 Forumite
in Techie Stuff
Hi,
I have a table in Excel 2010.
Rows are names of people; columns are meeting dates.
A "1" is inserted in the table to show when a person attended a meeting.
I want to filter the table to just display people who attended one (or more) of seven key meetings. Is it possible to use some sort of OR command to filter down to just show these people.
Seems like it should be simple, but I may be being a muppet!!
Thanks
I have a table in Excel 2010.
Rows are names of people; columns are meeting dates.
A "1" is inserted in the table to show when a person attended a meeting.
I want to filter the table to just display people who attended one (or more) of seven key meetings. Is it possible to use some sort of OR command to filter down to just show these people.
Seems like it should be simple, but I may be being a muppet!!
Thanks
0
Comments
-
You can use the Advanced Filter, or just sort your table by the required dates.0
-
Just use auto filter as echolocation suggestS0
-
Thank you both for your help!0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.5K Banking & Borrowing
- 254.1K Reduce Debt & Boost Income
- 455K Spending & Discounts
- 246.6K Work, Benefits & Business
- 602.9K Mortgages, Homes & Bills
- 178K Life & Family
- 260.5K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards