Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A list of software in Excel to show as header
I have a spreadsheet look as the following:
Name Title Dept Software Annie Hall Clerk ACCT Adobe 7.0 Office 2003 MS Project 4.5 Tom Joans Analyst IT Adobe 7.0 Office 2000 What I would like to do is to take all the software name and show them as header in a seperate spreadsheet. If a person has a software which already exist in the header then it will not repeat the software name, instead it will show yes under that header for that person. The other spreadsheet I am trying to create will look like this: Name Title Dept Adobe7.0 Office2003 MS Project4.5 Office2000 Annie Hall Clerk ACCT Yes Yes Yes Tom Joans Analyst IT Yes Yes Any new software belongs to a person will show on the header line. I appreciate any help on this. -- thadi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
A list of software in Excel to show as header
I would copy the sheet, then on the copy, select coluimns A:C and do Edit=go
To special and select Blank cells. In your example, then A3 would be the activecell. In the formula bar enter =A2 and hit Ctrl+Enter rather than just enter. This should fill up your white space. Now select A:C again and do Edit=copy, then Edit=Paste Special and select values. Now select the data and create a pivot table. Put Name, Title, Dept in as row fields. Put in Software both as a Column Field and a Data field and in the data field select count of. This will give you the count laid out as you show. YOu can then select the pivot table and do Edit=Copy, Then Edit=Paste special and select values. This will eliminate the pivot table and leave just the data. Select the data and do an Edit=Replace and replace all 1's with Yes. -- regards, Tom Ogilvy "Tasmania" wrote: I have a spreadsheet look as the following: Name Title Dept Software Annie Hall Clerk ACCT Adobe 7.0 Office 2003 MS Project 4.5 Tom Joans Analyst IT Adobe 7.0 Office 2000 What I would like to do is to take all the software name and show them as header in a seperate spreadsheet. If a person has a software which already exist in the header then it will not repeat the software name, instead it will show yes under that header for that person. The other spreadsheet I am trying to create will look like this: Name Title Dept Adobe7.0 Office2003 MS Project4.5 Office2000 Annie Hall Clerk ACCT Yes Yes Yes Tom Joans Analyst IT Yes Yes Any new software belongs to a person will show on the header line. I appreciate any help on this. -- thadi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
in Excel is it possible to have header information show in a cell | Excel Discussion (Misc queries) | |||
My .xla custom menu items doesn't show up when using 3rd party software | Excel Programming | |||
How to show query parameters on an Excel page header or worksheet? | Excel Discussion (Misc queries) | |||
How do I show my header in regular view on excel? | New Users to Excel | |||
how do I permanetly add custom header to excel header list? | Excel Discussion (Misc queries) |