I am having troubles getting this post to load. Every time I select it to view it I get a server error. Basically I have a spreadsheet that lists a student's name three times in three separate rows in Column A. Column B lists a unique class that the student is takings. I need one row per student with a separate column for each course. Attached is an example of what I am talking about. Thanks.
Copy the list of names in A3:A7 and paste to A11. Then click Data > remove duplicates and follow the prompts. Then in B11 array-enter this formula and fill across and down.If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.Formula:
Please Login or Register to view this content.
Dave
A friend sent me the attached and it worked, too. Thanks!
Last edited by GMKoehler; 11-11-2015 at 10:59 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks