Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

pivot tables

ResolvedVersion 2007

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

Excel tip:

Editing a formula quickly

If you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.