| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I've 5 columns, of assorted items.how do I tally them up?
I have 3 columns of data in a spreadsheet, and I need to create a report
Example- Airline DelayCode Time ABC - DEL - 2.00 DEF - DEL - 1.33 ABC - REJ - 3.44 GHI - DEL - 3.50 ABC - XYZ - 1.05 What I need is a report of the number showing the number of time that airline ABC was delayed. how many times DEL, or REJ (or whatever) appears, and what the total time was, per code , and as a grand total. (Here, ABC was delayed 3 times in total. Twice for 'DEL' (time: 5:50), and once for XYZ (time: 1:05); Grand TOTAL of delays = 6:55 (5:50 + 1:05) I will then make charts from the data, I'd really appreciate some help with this as I don;t even know the terminology of the thing I'm trying to do !! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make excel hide columns when it says cannot move objects | Excel Discussion (Misc queries) | |||
| How do I sort the data in 8 columns by two of the columns? | Excel Worksheet Functions | |||
| How to swap rows and columns? | Excel Discussion (Misc queries) | |||
| Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
