| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Consolidate of data using formula in Excel
Dear all,
I have a worksheet A B C Days Name Type 5 Kent Computer 0.5 Kent Safety 3 Susan Computer 2 Peter Management 1 Peter Safety I want to consolidate the data above into the following table A B C D Name Computer Safety Management Kent 5 0.5 0 Susan 3 0 0 Peter 0 1 2 What should the formula use in the table? Thanks Turk |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Problem organizing text data into new excel page | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
Threaded Mode
