Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert a Column into a Row
I have (in one worksheet) a list of all Majors.
I now want to convert that column into my header row for another worksheet. The final step would be to search through 3 rows in a 3rd worksheet and count each time a specific major occurs (if I could automate this so the formula simply looks at header for it's column and then searches for that It would be perfect). Thank you for any help you can offer me. AlexV |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert a Column into a Row
"Thansal" wrote in message
oups.com... I have (in one worksheet) a list of all Majors. I now want to convert that column into my header row for another worksheet. .... Look at the TRANSPOSE function. -- David Biddulph |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert a Column into a Row
Copy - Paste Special - Transpose
The count if function would work for your second question "Thansal" wrote: I have (in one worksheet) a list of all Majors. I now want to convert that column into my header row for another worksheet. The final step would be to search through 3 rows in a 3rd worksheet and count each time a specific major occurs (if I could automate this so the formula simply looks at header for it's column and then searches for that It would be perfect). Thank you for any help you can offer me. AlexV |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert a Column into a Row
Well, thank you for clueing me in on the Transpose functions.
Unfortunatly, the number of majors is rather larger then the number of columns that Excel will let me work with so I have to work horizontaly. And thank you for reminding me of countif (I feel silly for forgetting that) CW wrote: Copy - Paste Special - Transpose The count if function would work for your second question "Thansal" wrote: I have (in one worksheet) a list of all Majors. I now want to convert that column into my header row for another worksheet. The final step would be to search through 3 rows in a 3rd worksheet and count each time a specific major occurs (if I could automate this so the formula simply looks at header for it's column and then searches for that It would be perfect). Thank you for any help you can offer me. AlexV |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert FIGURES in one column to WORDS in another column? | Excel Discussion (Misc queries) | |||
How to convert FIGURES in one column to WORDS in another column? | Excel Discussion (Misc queries) | |||
match and count words | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
how do I convert a date and time column to a time column | Excel Worksheet Functions |