| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Num of unique items in col? by 3 criteria
Ok. Thanks. Now, how do I count the number of unique items by 3 other
criteria ie number of cats by location (column e) by salesperson (column k) by date (column c) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Num of unique items in col? by 3 criteria
Dear Dave
Assuming you have your data in Col A, B, C please try the below formula.. =SUMPRODUCT((A1:A100&B1:B100&C1:C100<"")/COUNTIF(A1:C100,A1:C100&"")) If this post helps click Yes --------------- Jacob Skaria "CindyC" wrote: Ok. Thanks. Now, how do I count the number of unique items by 3 other criteria ie number of cats by location (column e) by salesperson (column k) by date (column c) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Num of unique items in col? by 3 criteria
Can you post a small example and let us know what result you expect?
-- Biff Microsoft Excel MVP "CindyC" wrote in message ... Ok. Thanks. Now, how do I count the number of unique items by 3 other criteria ie number of cats by location (column e) by salesperson (column k) by date (column c) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Num of unique items in col? by 3 criteria
Can you pl. explain how this works?
(I have also asked Gary's Student the same question in the previous post) "Jacob Skaria" wrote: Dear Dave Assuming you have your data in Col A, B, C please try the below formula.. =SUMPRODUCT((A1:A100&B1:B100&C1:C100<"")/COUNTIF(A1:C100,A1:C100&"")) If this post helps click Yes --------------- Jacob Skaria "CindyC" wrote: Ok. Thanks. Now, how do I count the number of unique items by 3 other criteria ie number of cats by location (column e) by salesperson (column k) by date (column c) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Num of unique items in col? by 3 criteria
Sheeloo
In the previous post Biff has explained in detail how it works with one column. Please check and post back for any queries... Thanks Biff.. If this post helps click Yes --------------- Jacob Skaria "Sheeloo" wrote: Can you pl. explain how this works? (I have also asked Gary's Student the same question in the previous post) "Jacob Skaria" wrote: Dear Dave Assuming you have your data in Col A, B, C please try the below formula.. =SUMPRODUCT((A1:A100&B1:B100&C1:C100<"")/COUNTIF(A1:C100,A1:C100&"")) If this post helps click Yes --------------- Jacob Skaria "CindyC" wrote: Ok. Thanks. Now, how do I count the number of unique items by 3 other criteria ie number of cats by location (column e) by salesperson (column k) by date (column c) |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Num of unique items in col? by 3 criteria
Thanks... I saw the explanation and amazed at its similpicity.
"Jacob Skaria" wrote: Sheeloo In the previous post Biff has explained in detail how it works with one column. Please check and post back for any queries... Thanks Biff.. If this post helps click Yes --------------- Jacob Skaria "Sheeloo" wrote: Can you pl. explain how this works? (I have also asked Gary's Student the same question in the previous post) "Jacob Skaria" wrote: Dear Dave Assuming you have your data in Col A, B, C please try the below formula.. =SUMPRODUCT((A1:A100&B1:B100&C1:C100<"")/COUNTIF(A1:C100,A1:C100&"")) If this post helps click Yes --------------- Jacob Skaria "CindyC" wrote: Ok. Thanks. Now, how do I count the number of unique items by 3 other criteria ie number of cats by location (column e) by salesperson (column k) by date (column c) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Num of Unique items in col ? | Excel Worksheet Functions | |||
| Count Unique Items | Excel Discussion (Misc queries) | |||
| Counting Unique Items with Multiple Criteria | Excel Worksheet Functions | |||
| Counting Unique Items with Multiple Criteria | Excel Worksheet Functions | |||
| retrieve unique items with 2 criteria | Excel Worksheet Functions | |||
Linear Mode
