Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
So, who knows about Array formulas in Excel?
- Thread starter oli2140
- Start date
- Sort by reaction score
This may not be what you want to hear, but have you tried creating a list?
Just right-click in the data and select "Create List" and then you will be able to filter by your headers by just clicking on them and selecting the criteria you want.
On another note, make yourself a database with Access and save a lot of time.
Trust me, I used to work exclusively in spreadsheet for years until I realized how much more efficient databases can be with their queries and macros.
Hope this helps a little.
Wes
Just right-click in the data and select "Create List" and then you will be able to filter by your headers by just clicking on them and selecting the criteria you want.
On another note, make yourself a database with Access and save a lot of time.
Trust me, I used to work exclusively in spreadsheet for years until I realized how much more efficient databases can be with their queries and macros.
Hope this helps a little.
Wes
