# Counting multiple instances and matching condition

#### timtimba

##### New Member
Hi,

I am in bit of a pickle and would appreciate some help.

Basically I have four columns and I have to test the values and if any of the values is true then I have to count them

I have name of stocks, the person who traded them, the time of trade and finally how many times it was traded.

Lets put it in real formatL
Name of stock = MSN
Person trading = joe blogg, any tom, guy pearce
Time of trade = 11am, 1130am, 1145am, 1130am

So now I want in a column:
Joe blogg and Any Tom traded it same time = Check
joe blog traded it any time = no check
joe blogg and guy pearce traded it diff times = check

Currently I am using this formula but it doesnt work
First I count the number of times the stock was traded = =IF(N9>1,1,0)
Then I count if it is the same stock =IF(COUNTIF(\$R\$9:\$R\$1067, R9)>1, 1,0)
Then I see if its the same person =IF(COUNTIF(\$U\$9:\$U\$1067,U9)>1,1,0)
Finally I see if its the same time =IF(COUNTIF(\$T\$9:\$T\$1067,T9)>1,1,0)

Now I set a coulumn with this =IF(X9=1, IF(S9=1, IF(V9=1, "No Check", IF(W9=1, "No Check", "Check"))))

Any ideas as this is not working ... cause I have found multiple instances whereby the same stock has been traded with diff persons but its not coming as check

### Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Replies
4
Views
235
Replies
0
Views
320
Replies
0
Views
294
Replies
1
Views
730
Replies
14
Views
256

1,196,483
Messages
6,015,460
Members
441,897
Latest member
erma

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back