Which function to choose?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J-EL - 09 Nov 2006 17:37 GMT

Hello - I would appreciate some help choosing the best function for matching
columns of data. I have my data set up like this in 4 columns:
5.05    AAAAAAAA    5.00 ZZZZZZZZZ
5.00    ZZZZZZZZZ    4.95 XXXXXXXX
4.95    XXXXXXXX    5.05    AAAAAAAA
Where I'd like to have a column on the side which returned a YES or NO if,
for example, "AAAAAA" on each side both had the 5.05 next to it. If not, like
if AAAA on one said 5.2 and the other said 5.05, then to return a NO.

You guys have been so helpful in the past, and I'd really appreciate
anything someone can offer. Cheers!

Reply to this Message

Dave F - 09 Nov 2006 17:40 GMT

One possibility: =IF(CONCATENATE(A1,B1,C1)="5.05AAAAAA5.05","Yes","No")

This assumes the number of As in that text string remains constant.

Dave

Signature

Brevity is the soul of wit.

> Hello - I would appreciate some help choosing the best function for matching
> columns of data. I have my data set up like this in 4 columns:
[quoted text clipped - 7 lines]
> You guys have been so helpful in the past, and I'd really appreciate
> anything someone can offer. Cheers!

Reply to this Message

J-EL - 09 Nov 2006 18:46 GMT

HI Dave - For some reason, that isn't returning a good value (it says No even
when it should say yes). I apologize for being too vague - the AAA's were
just a place holder for a 9 digit code of letters and numbers (for example:
01245AP91).

Also, the codes could be anywhere in the column, not necessarily B1 and C1
would be the same code. B1 and C5 might be the same, and i'm looking if the
number next to B1 and C5 are the same.
I hope you're still able figure out something for me :)
Thanks,

> One possibility: =IF(CONCATENATE(A1,B1,C1)="5.05AAAAAA5.05","Yes","No")
>
[quoted text clipped - 13 lines]
> > You guys have been so helpful in the past, and I'd really appreciate
> > anything someone can offer. Cheers!

Reply to this Message

J-EL - 09 Nov 2006 19:54 GMT

For some reason, that isn't returning a good value (it says No even
when it should say yes). I apologize for being too vague - the AAA's were
just a place holder for a 9 digit code of letters and numbers (for example:
01245AP91).

Also, the codes could be anywhere in the column, not necessarily B1 and C1
would be the same code. B1 and C5 might be the same, and i'm looking if the
number next to B1 and C5 are the same.
I hope you're still able figure out something for me :)
Thanks,

Reply to this Message