| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count data or list
I am trying to count a data group and return the quanity of unique entries: It might look like this: The data would be in cols & rows 2 green widgets 25.5 inches long 3 green widgets 28.3 inches long 1 brown widgets 52.1 inches long 2 green widgets 25.5 inches long 1 brown widgets 52.1 inches long the result would be: 4 green widgets 25.5 inches long 3 green widgets 28.3 inches long 2 brown widgets 52.1 inches long Any simple straight forward way to do this??? Thanks, Spydor -- spydor ------------------------------------------------------------------------ spydor's Profile: http://www.excelforum.com/member.php...o&userid=28438 View this thread: http://www.excelforum.com/showthread...hreadid=482482 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation and Blanks in List | Excel Worksheet Functions | |||
| Data Val list Excel 97 fire macro | Excel Discussion (Misc queries) | |||
| HOW DO I MAKE VALIDATION LIST CONTAING DATA FROM A DIFFERENT BO | Excel Discussion (Misc queries) | |||
| How do I get LIST on the DATA menu bar-I need Create List | New Users to Excel | |||
| Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions | |||
Threaded Mode
