| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Number of Different Cells
B6:b45 includes a list of ID numbers. Some of the ID numbers will be repeats. I need a formula that will count the number of different IDs. Thanks. -- ForSale ------------------------------------------------------------------------ ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896 View this thread: http://www.excelforum.com/showthread...hreadid=550077 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Number of Different Cells
Make sure there is no empy cells in that range. =SUM(1/COUNTIF(B6:B35,B6:B35)) after you put that in the formula box, press control, shift and enter Hope that helps -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=550077 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Number of Different Cells
Try...
=SUMPRODUCT((B6:B45<"")/COUNTIF(B6:B45,B6:B45&"")) Hope this helps! In article , ForSale wrote: B6:b45 includes a list of ID numbers. Some of the ID numbers will be repeats. I need a formula that will count the number of different IDs. Thanks. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Number of Different Cells
Thanks to both. -- ForSale ------------------------------------------------------------------------ ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896 View this thread: http://www.excelforum.com/showthread...hreadid=550077 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of uniques starting with a given letter? | Excel Discussion (Misc queries) | |||
| count the number of cells with a date <= today's date | New Users to Excel | |||
| Count number of cells that contain a certain letter - Case Sensitive | Excel Discussion (Misc queries) | |||
| How do I count number of cells with info?? | Excel Discussion (Misc queries) | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
Linear Mode
