| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unique entries based on condition - count distinct
Hi,
I'm really struggling with what I thought should be easy. A B C D branch salesperson transaction num Item code I'm trying to the number of unique saples people in each branch, the number of unique tranactions by each sales person, and the number of unique items in each transaction. In another program I use "Count Distinct" but am struggling to acheieve the same in excel. Any ideas? -- Rich http://www.rhodes-lindos.co.uk http://www.rhodes-pefkos.co.uk |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count distinct based on criteria | Excel Worksheet Functions | |||
| Counting unique entries based on given condition | Excel Discussion (Misc queries) | |||
| Counting distinct entries based on meeting month & year criteria | Excel Worksheet Functions | |||
| how to count unique entries with multiple condition | Excel Worksheet Functions | |||
| count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
![Rich[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
