LinkBack URL
About LinkBacks
I have a list of values in column A: for example:
a1-hi
a2-bye
a3-whatever
a4-dude!
and i have a list on column B:
b1- whatever
b2 - dude!
If a value in A matches with B, replace value from column A it a character |
Thanks,
I have a list of values in column A: for example:
a1-hi
a2-bye
a3-whatever
a4-dude!
and i have a list on column B:
b1- whatever
b2 - dude!
If a value in A matches with B, replace value from column A it a character |
Thanks,
Do what now??replace value from column A it a character |
~~LaffyAffy13~~
If I have helped you solve your problem, please be sure to clickat the bottom left of my post.
Thanks.
Are you comparing the values in column A to any value in column B? Or are you only comparing the values in column A to their adjacent cell in column B?
replace cell a3 with "|" and cell a4 with "|" because those are on the list to be replace. The list to be replace is on column B. Note, i'm only giving an example of two items, the list of items to be replace will grow over time.
Alright.
Please Login or Register to view this content.
Very nice, repped and thank you. Loved the 'yay for screenupdating. I stumble around and found a solution myself as well.
Please Login or Register to view this content.
Last edited by igoodable; 08-08-2013 at 05:27 PM.
Thanks! I try to make life more enjoyable sometimes
Hey make sure to put code tags around your code. Next time you post some code somewhere, just highlight all of it and click the "#" in the text editor right above the text box. That way you don't get yelled at by moderators
noted, thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks