Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Which function to choose?

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!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,574
Default Which function to choose?

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
--
Brevity is the soul of wit.


"J-EL" wrote:

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!

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Which function to choose?

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,

"Dave F" wrote:

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
--
Brevity is the soul of wit.


"J-EL" wrote:

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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CHOOSE function - Possible with 100 values??? Fecozisk Excel Discussion (Misc queries) 1 July 12th 06 09:22 AM
VBA Monty Excel Worksheet Functions 2 January 30th 06 02:37 PM
Choose Function UD 9 Excel Discussion (Misc queries) 1 November 25th 05 10:22 PM
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM
CHOOSE Function Paul Excel Worksheet Functions 4 November 2nd 04 07:16 PM


All times are GMT +1. The time now is 11:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"