Re: macro extracting text
From: Tomek (tomolder28Usunnnnto_at_gazeta.pl)
Date: 02/03/05
- Next message: teresa: "Re: Simple Checkbox Question"
- Previous message: Jason Morin: "Re: how can I return the active row and active column?"
- In reply to: Tom Ogilvy: "Re: macro extracting text"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 3 Feb 2005 18:37:45 +0100
Dnia Wed, 2 Feb 2005 14:26:41 -0500, Tom Ogilvy napisał(a):
> =if(B2="","",if(countif(A2,"*"&B2&"*")>0,B2,""))
ALMOST , ALMOST but it shows correct result only when columns A and B
have the same string in the same row.
But the main idea is that the formula should search whole column B whether
one of the string is the same as in A column. If it is , it should be
copied to C column.
EXAMPLE:
A B C(RESULT)
ZZ AA ZZ(because ZZ is in column B
DD BB DD(because DD is in column B
GG CC GG(because GG is in column B
FF DD FF(because FF is in column B
FF EE FF(because FF is in column B
GG FF GG(because GG is in column B
ZZ GG ZZ(because ZZ is in column B
AA ZZ AA(because AA is in column B
HH NOTHING (because there isn't HH in column B
ZT NOTHING(because there isn't ZT in column B
MH NOTHING (because there isn't MH in column B
AA AA(because AA is in column B
ZM NOTHING(because there isn't ZM in column B
DD DD (because there is DD in column B
I hope it is clearer now.
Thank you very much for your patience.
Tomek
- Next message: teresa: "Re: Simple Checkbox Question"
- Previous message: Jason Morin: "Re: how can I return the active row and active column?"
- In reply to: Tom Ogilvy: "Re: macro extracting text"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
