Katherine has attended:
Excel Intermediate course
Data
How would i retrieve data thats arranged in columns
RE: retrieving data
Hi Katherine,
Thank you for your question.
There are a few ways you can use to retrieve data from data arranged in columns.
1. Tools - Autofilter and then use Custom
2. Vlookup formula
3. Tools - Autofilter - Advanced Filter
4. Use a Pivot table - Data - Pivot table and PivotChart report
I hope this answers your question.
Regards
Simon