Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Blacnk Cells in Excel
I have a document that looks like this?
Table of students who have chosen physics as a primary choice 1. ID Primary Choice Secondary Choice Programs 515 1 2 math 3 english 6 spanish I am trying to create a pivot table that breaks out the primary choice (first column), them the primary choice(second column) and then progrm name - the count will be on student ID. As it is, I first have to fill down the records so that I end up with this: ID Primary Choice Secondary Choice Programs 515 1 2 math 515 1 3 english 515 1 6 spanish Then create the pivot table. The file has about 10000 student IDs and this is very time consuming, is there a better way to do this? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Blacnk Cells in Excel
Hi KW -
Here is a "gap-filling" procedure that has been posted in this Discussion Group before. Copy it to a standard module, select your Primary Choice column, and run the procedure. Sub fill_in_the_blanks() Dim r As Range For Each r In Selection If IsEmpty(r.Value) Then r.Value = r.Offset(-1, 0).Value End If Next End Sub -- Jay "KW" wrote: I have a document that looks like this? Table of students who have chosen physics as a primary choice 1. ID Primary Choice Secondary Choice Programs 515 1 2 math 3 english 6 spanish I am trying to create a pivot table that breaks out the primary choice (first column), them the primary choice(second column) and then progrm name - the count will be on student ID. As it is, I first have to fill down the records so that I end up with this: ID Primary Choice Secondary Choice Programs 515 1 2 math 515 1 3 english 515 1 6 spanish Then create the pivot table. The file has about 10000 student IDs and this is very time consuming, is there a better way to do this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
Can I connect Excel cells to cells in an embedded Word table? | Excel Discussion (Misc queries) | |||
How can I have formatting options like merge cells ,Bold,active for the unlocked cells of the protected worksheet.Is it possible in excel? | Excel Programming | |||
conditional formating cells i Excel based on other cells values | Excel Worksheet Functions | |||
Pasting single cells from Word to multiple cells in Excel | Excel Worksheet Functions |