Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with sumproduct or similar type of function
I am interested in finding a function that will count the number of
unique combinations a in two columns (columns A& B). For example: Column A Column B Column C Column D ABC 03/2007 =A1&B1 =SUMPRODUCT((1/ COUNTIF(C1:C5,C1:C5&""))) BCA 03/2007 =A2&B2 CAB 07/2007 =A3&B3 ACB 07/2007 =A4&B4 ABC 03/2007 =A5&B5 In the case above, there are 4 unique combinations in columns A and B (ABC 03/2007, BCA 03/2007, CAB 07/2007, ACB 07/2007). I don't count the second instance of ABC 03/2007 becuase it is already in the first row. Is there a cleaner way of doing this? I've tried using sumproduct, but I can't seem to get it to work the way I want it to. Does anyone know how this can be done? There are only four possible strings in column A (ABC, BCA, CAB, ACB) Thanks! Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT is OK for a while and later a similar formula returns 0 | Excel Worksheet Functions | |||
SUMPRODUCT, two criteria (date and product type) | Excel Worksheet Functions | |||
similar function for SUBSTITUTE in excel? | Excel Discussion (Misc queries) | |||
Function similar to SHIFT+CTRL+DOWN KEY | Excel Worksheet Functions | |||
A similar =proper function | Excel Discussion (Misc queries) |