Mar 26 2023 12:01 PM
I had a hard copy of the excel sheets containing big data of numbers. I want a function that allows me to find multiple numbers at the same time.
example :
in my papers, I have numbers ( 23422,2334,5665,676776,78887,778787.....etc), on my computer, I have the same papers in excel, how do I match the between them to give me the unmatched numbers?
the function (find) is not useful because it gives me only one number to search even functions (look up, Vlook,...)
Mar 26 2023 10:28 PM
You can use Excel’s Find and Replace tool to get multiple values in Excel. You can also use Excel’s Filter option to find multiple values. Another option is to apply Advanced Filter option to return multiple values. You can also insert FILTER Function to find multiple values.
If you have installed Kutools for Excel, you can use its Select Specific Cells feature to quickly find multiple values at once.
I hope this helps!
Mar 26 2023 11:08 PM
Mar 26 2023 11:58 PM
Mar 27 2023 12:06 AM