SEARCH

The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Microsoft Office

(Solved) - Excel Conditional Formatting Question

(4 posts)
  • Started 1 year ago by CB88
  • Latest reply from Enthusiast
  • Topic Viewed 766 times

CB88
Posts: 2

I need to set up conditional formation which will count how many times a name is entered into a table. Names will be limited to about 6 and entered from drop down menues to prevent spelling difference.

So if "Tom" is in the table 5 times I would like a cell to show "5".

Posted 1 year ago
Top
 
Enthusiast
Posts: 566

In the cell you want the number of occurences to display, place the function =COUNTIF(A1:A15,"Tom"). Replace "A1:A15" with your range.

This is not conditional formatting. Conditional formatting changes the way cell(s) "look" based on information contained in those or other cells.

Accepted Answer · Posted 1 year ago
Top
 
CB88
Posts: 2

Thanks, exactly what I needed. I had my mind set to do it one way - which was wrong.

Posted 1 year ago
Top
 
Enthusiast
Posts: 566

Glad to help.

Posted 1 year ago
Top
 



Topic Closed

This topic has been closed to new replies.