Adrian has attended:
Excel Advanced course
Pivot tables
How to create pivot tables of airline schedule info. (using multiple consolidation ranges and text to columns), where arrival/departure time reflects original data (whereas it now formats as a decimal point eg. 0.000123)
RE: Pivot tables
Hi Adrian
Thank you for your question
It is difficult to advise you without seeing the spreadsheet in question. Could you email a copy of the workbook to me at stephen@stl-training.co.uk and I will investigate and reply
Regards
Stephen
RE: Pivot tables
Hi Adrian,
Did you manage to get a copy of your workbook to Stephen?
This question has now been left unattended for a while.
We like to keep down the large number of active forum posts we receive.
As we are waiting for your response for further information to help resolve your issue, we will be automatically marking this question as resolved in the next 5 days (unless you post a follow-up within that time).
We look forward to hearing from you.
Thank you.
Regards, Rich
RE: Pivot tables
Hi Rich,
Sorry - meant to send it earlier. Which file do you want to have a look at - the Mr. Excel one or my own? Please advise.
Adrian.
RE: Pivot tables
Hi Adrian
If you could send me a copy of both files, I will endevour to solve the issue for you
Regards
Stephen