| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
count number of repeats in a column highlight result
I am have a very large sheet (1000s) with customer orders and am trying to find the number of orders by each customer and then highlight when customer has made 5+ orders is this possible?
I think I have formula for adding number of repeat instances in customer ref# column therefore solving first part but is their a way to then make that then highlight if result is 5 or more |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highlight exact match in column and count | Excel Discussion (Misc queries) | |||
| frequency a number repeats in a column | Excel Worksheet Functions | |||
| How can I count the number of times a letter repeats in a string? | Excel Worksheet Functions | |||
| How can I count the number of repeats in a list of data? | Excel Discussion (Misc queries) | |||
| Count repeats | Excel Worksheet Functions | |||
Threaded Mode
