Re: Match Each Digit in Columns, Return True or False if All Match
I've changed the formula. Everything is OK, even better : ) Thank you very much, PCI.
Re: Match Each Digit in Columns, Return True or False if All Match
I've changed the formula. Everything is OK, even better : ) Thank you very much, PCI.
Re: Match Each Digit in Columns, Return True or False if All Match
Possible values are from 000-999. Thank you.
Re: Match Each Digit in Columns, Return True or False if All Match
Thank you, PCI. Everything is working well. Thank you once again for your time and help!
Re: Match Each Digit in Columns, Return True or False if All Match
Updated file attached as requested. Thank you.
forum.ozgrid.com/index.php?attachment/37407/
Re: Match Each Digit in Columns, Return True or False if All Match
Hi PCI,
In further testing the formula:
I have found that if there is a number that begins with zero in Column A, it will return a TRUE statement which is incorrect.
The zero also is made invisible by XL. Could you please show me how to fix this? Thank you.
A-----B---------C
0111 615243 TRUE <----Should Be FALSE
0888 615243 FALSE
Re: Match Each Digit in Columns, Return True or False if All Match
PCI, Thank you very very much for your speedy assistance.
You did in minutes what I've been trying to do for weeks.
I appreciate your expertise. Thank you!
Quote from PCI;549416Perhaps
or better
I need to check Col A (four numbers) against Col B (six numbers) and return TRUE or FALSE if ALL value(s) in Col A match those in Col B. I greatly appreciate your help. Thank you in advance.
A------B------C
1234 615243 TRUE
4132 264315 TRUE
1238 351462 FALSE
1244 413652 TRUE
1222 341526 TRUE
8888 562143 FALSE
5555 165234 TRUE