| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Distinct Value With Countif
Hi, I am looking for help with distinct values using countif. This is what I have so far. Please help. A B C 01/03/05 01/18/04 =Countif(A1:A14,"<="&B2) which equals 13 but I want distinct values, which my value I want is 12 01/04/05 01/04/05 01/05/05 01/06/05 01/07/05 01/10/05 01/11/05 01/12/05 01/13/05 01/14/05 01/17/05 01/18/05 01/19/05 -- spalmarez ------------------------------------------------------------------------ spalmarez's Profile: http://www.excelforum.com/member.php...o&userid=15961 View this thread: http://www.excelforum.com/showthread...hreadid=275769 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotal And Countif | Excel Discussion (Misc queries) | |||
| countif | Excel Worksheet Functions | |||
| Countif, Sumif, If - help! | Excel Worksheet Functions | |||
| countif, again | Excel Worksheet Functions | |||
| combining countif formulas | Excel Worksheet Functions | |||
Threaded Mode
