I have a word document that contains several hundred WWII army serial numbers in the text and I have an XL document with about 35,000 Army Serial Numbers. I want to find what serial numbers in XL are also in the word document or vice versa. Can this be automated?
I have a list of unique values I need to find in a column 90k rows in length. I have used the Conditional firmatting but it's so slow. Is there any way I can quickly find the values and delete the entire rows with those values?
Hi. I a number that I need to find in a column. which is clubbed amount of 2 numbers or more in another table. How I can find that numbers? Like I want to find what numbers are adding up to make $3000. is there any way?
This is very helpful. Thanks for sharing!
Glad it was helpful!
I tried to do this however it doesn't seem to work, however my column B is not as long as column A.
Thanks, just what i was looking for!
Glad I could help!
thank you so much, this was sooo helpful.
Happy I could help
I have a word document that contains several hundred WWII army serial numbers in the text and I have an XL document with about 35,000 Army Serial Numbers. I want to find what serial numbers in XL are also in the word document or vice versa. Can this be automated?
I am not sure that would involve VBA with Word which is not my I do not know much about
What if any of the value is there for multiple times in any of the column
it will find the first
Wow I'm impressed!!!!!!super!!!!!!
Thank you! Cheers!
OMG it worked. Thanks!!!
I have a list of unique values I need to find in a column 90k rows in length. I have used the Conditional firmatting but it's so slow. Is there any way I can quickly find the values and delete the entire rows with those values?
Have you seen this video, th-cam.com/video/Kv0r7eFLyEo/w-d-xo.html It might be what you need
Good 👍.
I need to match invoice with amounts at the same time.
I do not know how you would look for two things
I have 300 fax numbers in one column. Is there a way to see if any of them match?
I have a video on finding duplicates th-cam.com/video/xdRX-oprKRE/w-d-xo.html
Thank Q, Its work and easy way of formula function.
Glad to hear that
What if you have multiple columns or rows
You would have to create if for each column
@@BarbHendersonconsulting how do I do that
@@BarbHendersonconsulting what if I do it from different tables
Thank you 😊
You're welcome 😊
super helpful
Glad to hear!
Thank you, Thank you .... Thank you
You are very welcome
Really appreciate
Your welcome
How about if there is a multiple number in a cell? Example (563, 253), 253 is in the list. How to show, Yes?
the match function would not be suitable for that
Impressive !
thank you
Cntrl+f?
short cut to find
Thankyou mam v helpful
Most welcome 😊
How can we use this but instead of yes/no, I want it to highlight the original match
I don't think you are able to do that with the match function
Super I got the answer
Need to freeze selected columns.. else it will just go down as you copy forumals..
no, double click the fill handle and it should work.
I found out that if you put $A$2:$A$650 it doesn't shift the data that you are search. I hope this helps someone.
Lovely, tho u do sound fed up with life, hope all is well
why not $?
I think you could have $ as long as you have them on both lists
Hi. I a number that I need to find in a column. which is clubbed amount of 2 numbers or more in another table. How I can find that numbers? Like I want to find what numbers are adding up to make $3000. is there any way?
I would not know where to start on that one!