help with extracting data from table

Hello,

Your profile says you use Excel 2003, but you attach a file that has clearly been created in a later version. Please update your profile to reflect your actual Excel version. This information helps us to provide you with a solution that works best for the version you are using, so make sure it is correct.

In the sheet "table" add some text as a header for column A in A4. Then use Data > Filter > Autofilter

Click the drop-down in A4, select "1" and see the data filtered to only the rows that have a "1" in column A.

See attached.

Try this and let me know if this works for you.

Nice approach, Charlie,

The question arises, though, what makes this better than a pivot table.

@gwminkl , is there a specific reason you don't want to use a pivot table? It would provide what you want to achieve with just a few clicks, no formulas involved.

Why do you want to re-invent the wheel that pivot tables already provide????

I love Pivot Tables and use them often, However if someone is a novice unrefreshed pivot tables can end an office career lol just sayin'

Good luck GWMINKL. Have fun and come back soon.