Forum Discussion
Transfer date to a table
So at work we keep a long spreadsheet of all the enquiries we get, when we get them, if we win them so on and so forth. At the minute it’s just one long spreadsheet with one enquiry after the next. Wh...
Hi Cubbles
I'd suggest turning your long list into a Table and then creating a Pivot Table from it like in the attached example.
Have you used Tables or Pivot Tables before? What version of Excel are you using?
Thanks
Wyn