Hi,
im not that great at excel and I need to figure out how to find two identical numbers about 11 digits long and match them up side by side. What is the best way of going about this?
Ray
Hi,
im not that great at excel and I need to figure out how to find two identical numbers about 11 digits long and match them up side by side. What is the best way of going about this?
Ray
assuming your data is in A1 then in b1 try below
=IF(ISNUMBER(MATCH(A1,sheet2!$A$1:$A$600,0)),"YES","NO)
Drag down
in case there is a match it will show yes else no
Red coloured part is the range where you want to match number from A1
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks