Home > categories > Security & Protection > Fire Hydrant > Excel VBA Search and Highlight Help; Difference from Majority?
Question:

Excel VBA Search and Highlight Help; Difference from Majority?

I have a large 3 column list that I need to normalize. Column A contains a ship's hull, B contains a hose number and C contains the hose name.For each group of hose numbers (B), I need to highlight any that are named differently from the majority. i.e.: Hose number 123 is on 15 ships. On all but 2, the name of the hose is Fire Hose. On the other 2, they are named Fire/Washdown Hose. I have about 25000 lines to go through, so I need something that can find the start of a hose number, search through all of the hose names and highlight the ones that don't match the majority, and then move onto the next hose number.Help! :) Steve

Answer:

Not sure about California state laws, but in NY you can stop in a fire lane, or even next to a fire hydrant. The trick is that a licensed driver must remain in the driver's seat, awake and ready to move the car, if necessary. So, if that's also the case in California your friends get part credit. Now leaving an unattended vehicle next to a hydrant or in a fire lane is not legal, no slipping out of the ticket at all. Pay the fine and don't do it again!
The fire extinguisher most certainty caused your co-workers to have nausea. The reason for this is simply because fire extiguishers are made with Digoxin, Hydrogen peroxide, Ethylene glycol, and Sodium cyanide. These chemicals can be life threatening, if exposed to large amounts. However, in the case of a fire extinguisher, there is only enough to cause a mild reaction, such as nausea.
Well, maybe you should ask these several people to pay your ticket, because these several people are severely idiotic, just like you. You can park in front of a fire hydrant, provided you remain in your car and are able to move the vehicle immediately when necessary. But this does not apply to a marked fire lane. Nor does it apply anywhere marked with a red curb. Nor does it apply anywhere marked No Parking. Pay your ticket. Why in the world would you believe that you could park in a zone that is clearly marked no parking - fire lane. And, why would the fact that you live in California make a difference? No parking generally means the same thing in all 50 states, plus the District of Columbia. Seriously, you should actually pay your fine, plus an extra 50% for stupidity.

Share to: