Challanging Code: Search, No coding, dublicate

[elba7312]

Hi all:
Please give a help in this code
http://www.flickr.com/photos/63642645@N07/5810971006/in/photostream

I would like please to search for duplicated numbers in column B:
1- if it is only one unique number in column B, so write down in column D "11"

http://www.flickr.com/photos/63642645@N07/5810407335/in/photostream/

2- if they are two duplicated numbers in column B, and column C has any of the following words " Alcohol or Fatigued or speeding ", so write down besides these words but in column D "21"
and the other cell with nothing in column C, write in column D "22"

http://www.flickr.com/photos/63642645@N07/5810407335/in/photostream/

3- If there are three similar numbers in column B, and column C has any of the following words " Alcohol or Fatigued or speeding ", so write down besides these words but in column D "31", the other two cells in column D write down "32" and "33"

I posted a previous question similar to this and it helped a lot ( Thanks for all who helped), and now I am just adding 3 other search words to it " Alcohol or Fatigued or speeding " .

Old question is in the following link
http://www.mrexcel.com/forum/showthread.php?t=554630&highlight=duplicate+coding

Thanks in advance

 

[azexcel]

Hi elba7312,
This problem will be solved very easy if you use a sub column. I solved it successfully.

If you like to solve by this way, please see the detail at: How to search duplicate content and fill value to other column in excel 2007?

Hope useful to you!

 

[elba7312]

Thanks a lot for this. The formula works fine for small numbers, but it kills the machine for huge number of calculations. If there is a VBA Code for this, this should be much faster than regular formulas.
Thanks a lot

 

[elba7312]

Also in the last formula, column E would not work fine if column B has different numbers other than 1 2 3, like attached pictures in my main question.
Thanks for help

 

[p45cal]

1. Sort primarily by column B, secondarily by column C

2. then either:
apply the formula given here at you last question and copy paste-values in situ,
or:
run the macro given there,

3. then sort on column A to restore the original order.