Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Count names in column once
Want to count the names in a column only once. The name may be repeated
several times such as Tom Tom Tom but I want to count it only once at the bottom of the row. Is this possible in Excel? |
#2
|
|||
|
|||
Change the range to reflect your names. It is an array formula, so commit it
with Shift-Ctrl-Enter =SUM(1/COUNTIF(A1:A10,A1:A10)) "Lorraine" wrote: Want to count the names in a column only once. The name may be repeated several times such as Tom Tom Tom but I want to count it only once at the bottom of the row. Is this possible in Excel? |
#3
|
|||
|
|||
Yes,
Try something like =IF(COUNTIF(A1:A1000, "Tom")0, "The name 'Tom' exists in the list","") Of course change the meesage displayed whether true or false to what you want displayed, Regards, Alan. "Lorraine" wrote in message ... Want to count the names in a column only once. The name may be repeated several times such as Tom Tom Tom but I want to count it only once at the bottom of the row. Is this possible in Excel? |
#4
|
|||
|
|||
Or if you dont want a meesage, have a message! lol (:
"Alan" wrote in message ... Yes, Try something like =IF(COUNTIF(A1:A1000, "Tom")0, "The name 'Tom' exists in the list","") Of course change the meesage displayed whether true or false to what you want displayed, Regards, Alan. "Lorraine" wrote in message ... Want to count the names in a column only once. The name may be repeated several times such as Tom Tom Tom but I want to count it only once at the bottom of the row. Is this possible in Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count number of unique items in a column that contains duplicates | Excel Worksheet Functions |