Search results for query: *

Skip, Thanks very much for your help. I see what you are trying to do.

skip, So is it a typo that you say $A2 but B$1 ? Also, Using that formula from the = in all the target cells should help huh? What about ranges? Which cells and what range names?

Excel 2007

i GUESS THE BIG PROBLEM IS THAT i DONT SEE THE FORMULA YOU ARE REFERRING TO. Yes, The results look perfect!

Skip, I consider myself pretty swift but I am lost. Yes, it seems that you solved my problem but I have no idea what you did to get there. I can find no "Insert, Name" option I understand if at this point you give up on me. The other option is to take a moment and tell me step by step what...

This is the data I get from my daily report: 001150 Cheryl 001150 Louis 001150 Mary 001200 Cheryl 001200 Fred 001300 Cheryl 001300 Mary 001300 Wanda 001350 Cheryl 001350 Loius 001350 Mary This is what Id like the progress sheet to look like: Cheryl Fred Louis Mary Wanda...

Skip, You are a saint. Please see my mediafire page and look at the excel file called "what I am trying to do". That may make more sense. Thanks a milhttp://www.mediafire.com/?fafcd4mgbgaavhu

Hmmm. OK, I'm not 100% sure I understand. I Will make the 2 named ranges as you suggest. Could you possibly check the cell content as I think you had a typo. Is it possible you could answer in a bit more detail since I would love this to work and I'm not very good with excel. What should the...

I have a report which I run every morning. It shows what students completed what classes. The columns are: class id (a 6 digit #), then the students name. My challenge is this, the Class number has NOTHING to do with the order the classes are taken. Therefore on a second spreadsheet (My...