ExcelZone Compendium: Sorting and filtering tips. By Simon Hurst

Share this content

Judging by the number of questions, comments and articles on AccountingWEB, a lot of the issues surrounding sorting and filtering actually relate more to difficulties in getting the original data into a suitable state than to the, usually fairly straightforward, process of actually carrying out the sorting or filtering process.

Some techniques that may prove useful in organising the data are covered in the Advanced Data Entry digest and in the items in the Importing and exporting section of the main ExcelZone Compendium.

If you are not already familiar with pivot tables in Excel then it would certainly be worth having a look at the Pivot table compendium. Pivot tables are often an excellent method of sorting, filtering and particularly summa...

Please Login or Register to read the full article

The full article is available to registered AccountingWEB.co.uk members only. To read the rest of this article you’ll need to login or register. Registration is FREE and allows you to view all content, ask questions, comment and much more.


Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.