I have a large file.
column a = parent_item column c = child_item
I want to add a column with a formula - if the value in cell for column C exists anywhere in column a - result of formula = 1 if not then 0.
example -
Col A Col B Formula Result
Item A Child A 1
Item A Child B 0
Item A Child C 0
Child A Child D 0
Child A Child B 0
=ISNUMBER(MATCH(B1,A:A,0))*1
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
I think this will work quite nicely. I understand how most of it works, but I was wondering why the *1 at end of formula?
Thank you very much.
ISNUMBER returns either TRUE or FALSE which can be coerced into it's numerical equivalent (0=False, 1=True) by multiplying by 1.
Dom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks