Find exact match of numbers from X colums in other X colums in the same order and same row
Hello !
I have big data of numbers in colums A - E... numbers are between 0 to 9
In cells G1 ; H1 ; I1 ; J1 ; K1 i have numbers from 0 to 9
example :
G1 H1 I1 J1 K1
2 1 4 6 8
I want a formula that i can find these numbers in the same order and in the same row... if the result is true... i need the numbers 2 1 4 6 8 to be found in one row from A to E, hope you guys understand what i mean....
thank you!
Last edited by Spikyd; 10-02-2020 at 06:11 PM.
Assuming you want each line tested. Formula for G1 and fill down =TEXTJOIN(",",TRUE,A1:E1)=TEXTJOIN(",",TRUE,$H$1:$L$1)
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
The formula is good but for a bigger range at A - E ? for Example A1:E5
Are you sure you can execute TEXTJOIN function in OFFICE2016?
Give it a try, conditional formatting can help you, please see Conditional formatting contains formulas
When the pairing is successful, it will automatically display in red color
Pls try to change G1 H1 I1 J1 K1 figure and see what happen ?
Last edited by wk9128; 10-02-2020 at 07:42 PM.
Try this:
=COUNTIFS(A:A,H1,B:B,I1,C:C,J1,D:D,K1,E:E,L1)>0
@Phuocam
Thank you, is working!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks