Hello,
I have a report that is next to useless when opened in Excel as I'm unable to quickly work out a daily/weekly value £.
I've tried saving the document as a CSV file which does work a bit better but I'm still left with each cell containing three bits of data two of which I DONT need.
The cells have an internal reference number a rate reference and then the value e.g. BK007000 NEG_7_28 70 The 70 refers to the value of the sale which is the only data I want to extract and be able to sum up per day.
I thought using a pivot table would be the solution but I can't get that to work.
Any suggestions. example attached.
Bookmarks