| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function Help
I am trying to count the number of unique suppliers in a column that
exist on a list on Sheet 2 - I can get it to count unique, but when I use the criteria of the other list I get a #DIV/0! Error. [These are both array formulas] This counts unique records: =SUMPRODUCT((T10:T2104<"")/COUNTIF(T10:T2104,T10:T2104&"")) This bombs: =SUMPRODUCT((T10:T2104<"")/COUNTIF(T10:T2104,'Current Supplier'! A2:A2287&"")) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? | Excel Programming | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Adding a custom function to the default excel function list | Excel Programming | |||
Linear Mode
