| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTING THE SAME VALUES IN A SHEET
Hi,
Am Fri, 23 Nov 2012 08:32:16 -0800 (PST) schrieb naga rajan: A1=6 B1=5 C1=6 D1=4 E1=6. In F1 I should print "3" since 6 is repeated 3 times. try in F1: =COUNTIF(A1:E1,MODE(A1:E1)) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
| counting rows with same values for multiple values | New Users to Excel | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
| Counting Rows Then Counting Values in Columns | Excel Programming | |||
Threaded Mode
