something Wrong with my formula...Help

**Raf0006** · 08-13-2007, 07:51 AM

Hi

Wonder if anyone can help

Trying to populate same cell info from two matching or not matching columns in different part of the sheet?

Ex:-

Column A Column B Column C

OTE BT BT (smaller in both column should appear in this cell)
BT ADSL
VSLN TTW
NTT NCT

Hope this would explain?

Does it make any different if column A word populated by Formula?

Thanks

**NBVC** · 08-13-2007, 07:56 AM

So you want column C to be populated with the string (from Col A or Col B) with least amount of characters?

**Raf0006** · 08-13-2007, 08:01 AM

yes

i'm trying to get column C to pick up the smaller between A and B columns even if not same row.......

Thanks

**NBVC** · 08-13-2007, 08:03 AM

not sure what you mean by this part:

even if not same row.......

Are you only needing 1 formula in 1 cell , say C2, that extracts the string with the least amount of chars from the entire columns A and B?

**Raf0006** · 08-13-2007, 08:10 AM

is like you have list of name in column A1 to A10 and different List in column B1 to B10. i want now column C1 to pick up the same Names in both A and B columns even those names not located in same row from A and B ........

**NBVC** · 08-13-2007, 08:55 AM

Looks like you want items common to both lists,

in C1, try:

=IF(ISNUMBER(MATCH($A1,$B$1:$B$100,0)),$A1,"") copied down

adjust ranges to suit.

Note: This post has been edited. Previous formula was incorrect.

**Raf0006** · 08-13-2007, 09:15 AM

great work

thanks

something Wrong with my formula...Help

LinkBack

Thread Tools

Rate This Thread

Display

something Wrong with my formula...Help

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions