| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count Uniques in Column G Until Change in Column C, then Resta
On Nov 6, 6:54 pm, ryguy7272
wrote: Thanks for the effort dbKemp!! Unfortunately, the code didn't do anything. All I did was add a reference to MS Scripting Runtime, and I modified these lines of code: 'These will be different for you Set rNames = Sheets(1).Range("C2:C4500") Set rIDs = Sheets(1).Range("G2:G4500") What was supposed to happen? Thanks, Ryan--- -- RyGuy If your data is on 'Sheets(1)'....it will put up a message box for each unique name with the count of ID's. If you data is not on 'Sheets(1)' then it will do nothing. Make sure the sheet reference is correct and then step through the code line by line checking the values of the variables to see that it is reading the correct values from the worksheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Restart row count each time the value in a specific column changes | Excel Worksheet Functions | |||
| count uniques in same column, post in blank cell, repeat until end ofspreadsheet | Excel Programming | |||
| Count Uniques in Column, put result in next blank cell andcontinue until last row | Excel Programming | |||
| Count Uniques in Column, put result in next blank cell and continu | Excel Programming | |||
| Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
Threaded Mode
