Pivot Table Help - Counting multiple items in a cell individually
Hello, I need some pivot table help. I’m using Excel 2010 and have scoured google for an answer without success. I currently have a table that looks like this (sample): Office Client ID Requested Funds Central X8345987 Mileage Parking Northern X435786 Parking Western U92345987 Mileage Car Insurance Central G3405695 Parking Mileage Car Insurance I have the office, client ID, and funds requested. In the funds requested column I used ALT + Enter to list multiple items in the one cell. The problem is, when I create a pivot table, this is what I get: Count of Requested Funds Column Labels Row Labels Mileage Parking Parking Mileage Car Insurance Parking Mileage Car Insurance Grand Total Central 1 1 2 Northern 1 1 Western 1 1 Grand Total 1 1 1 1 4 What I want is excel to separate the list items, and count them individually. For example, instead of providing a count of 1 for mileage and car insurance together, I want a count for mileage AND a separate count for car insurance. I want my pivot table to look like this: Office Mileage Parking Car Insurance Central 2 2 1 Northern 0 1 0 Western 1 0 1 Can anyone help me do this? Or is it even possible with a pivot table? Thanks!
Summing a row of drop down lists VALUE error
Hello all, I am trying to sum a row of cells where each cell has a drop down list created through Data Validation using Excel 2010. Each list has 2 options, a blank cell or a time that is formatted in the custom format h" hrs "m" mins". For some reason when another user chooses the options from the drop down list, the formula that sums the cells presents a #VALUE error. The summing formula is =TEXT(L14+M14+N14+O14+P14,"hh:mm") and I have attached the sheet to this message. I'm thoroughly stumped as to why when others view and select from the drop down lists, the answer that is given is no longer recognised by the formula. The perfect solution would be that the formula gives out a time in either hh:mm or the above custom format, but any advice is much appreciated!Format Date in header
Dear Ladies and Gentlemen, could you please help me with the header position? I want to use a picture (company's brand name) on each sheet for printing the document from Excel. Is it possible to allocate it (Graphic image) for the whole width of the page instead of left side/middle/right side? I would be very glad for your help!