instr function if loop to find data

I have cells with a string which looks like

11.25X2.5X11 abcd efgh hot (1000B)
11 X2 X10 hot qwerty poiuy (2000B)
10X2,5X11,25 ghjk hot lkjh (2000B)

The above strings are in column f2, f3 and f4 and so on

I want to have an if loop which can look for within f2:f25000
for string which have three "X" in the cell and the word/string HOT, because that seems like the only filtering criteria that would work (because of inconsistent spaces before and after X imo).

I am trying to use :

Please Login or Register  to view this content.

How can I modify this for it to do what I want, or some other better way of doing it?
Any suggestions.

Are you sure you want to filter for 3 "X"?
None of your sample has 3 "X"... it it's 2 "X" replace 3 with 2 in code posted below.

At any rate, you can do something like below...

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

All the Methods I have seen above will be Slow.

Try something along these lines. [ I will work on the code after I post this pseudo code. ]

Use a formula in a n Empty Column to flag your column with "#N/A"

Select all errors in column F using Select Special.

Loop through the Selected Cells and use

Please Login or Register  to view this content.

1) yes always, but I would also want to have something which can take lower case.
2) Yes WAX
3) Yes
4) can be upper or lower case.
5) yes hotline (but I dont want that).

This is a really good question
I found something :
15X 15 PRT WAX PAPER HOTLINE (2000B)
This has X in WAX which would mess the logic since I don't want it considered, I want X only when it is between spaces and numbers not followed by an alphabet.


6) usually surrounded by spaces but can also be followed by characters ex- hotline, usually always starts with space.

Assuming the two X's always appear before the work "hot", give this macro a try...

Please Login or Register  to view this content.

Note: The word "hot" appears to sometimes have non-breaking spaces (ASCII 160) around it... my code accounts for that.

EDIT NOTE: I made a minor but significant change to my code 19 minutes after I posted it, so if you copy/pasted my code earlier than that, you should redo the copy/paste.

2nd one from your initial post.
11 X2 X10 hot qwerty poiuy (2000B)

Does this count as meeting your criteria? If it does... here's another approach.

Please Login or Register  to view this content.

Edited after Post# 8

Please Login or Register  to view this content.

Reg your message.
See if this is how you wanted, otherwise I need to see your workbook with the result that you want.

Please Login or Register  to view this content.

It works my dataset has only uppercase HOT.