Hi,
I'm a relative novice when it comes to Excel.
I have uploaded a basic spreadsheet with a list of items.
What I need to do is sort/group & summarise on the 'Client Reference(s)'.
Other than filtering, a tedious and manual exercise, is there another way wherein I can simply enter a formula or function which will then sub-total on the references shown perhaps in another sheet?
Thanks.
Bookmarks