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
Taded = 4 times
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
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
Taded = 4 times
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