Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have three columns of data in a worksheet (Name, Report, Usage). In a
separate worksheet, I'd like to construct a matrix with Names in Column A and Reports in Row 1. I need a function (?) to compare the Report and Name in the second worksheet to the first and return the Usage. Example: Worksheet 1: Joe Tax Report 5 Joe Income Report 8 Jim Income Report 6 Worksheet 2: (This is what I am trying to do.) Joe Jim Tax Report 5 Income Report 8 6 Any help is appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
amount of working days per month | Excel Discussion (Misc queries) | |||
Calculation with Working day of the year | Excel Discussion (Misc queries) | |||
vba adding arrays | Excel Discussion (Misc queries) | |||
Working days left in the month compared to previous months | Excel Worksheet Functions | |||
Working time and days | Excel Worksheet Functions |