| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit occurrences using VBA
Hi,
I have a list of numbers in column A that are grouped together. What I need to do is count the number of each numeric occurrence and alert the user if the number is greater than 2. So if I have the number 5 show up 3 times. The user will be notified that there is a problem. I believe the code would be similar to: If Application.Countif(ColumnA:A, rowname) 2 then MsgBox "Problem on line" & rowname & "." End if Thanks, James |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting occurrences | Excel Discussion (Misc queries) | |||
| Unique occurrences of a value Q | Excel Worksheet Functions | |||
| sort 2 or more occurrences | Excel Worksheet Functions | |||
| # of occurrences | Excel Worksheet Functions | |||
| Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) | |||
Threaded Mode
