Can't rework the formula
in [Functions]
|
From: Malcolm on 31 May 2010 21:10 FSt1, Hi, Your solution did not directly address my problem, but that was my fault because I was not clear. However, your formula helped me address several other issues, that I had on another worksheet so your reply helped me a load. Thanks again for all your invaluable help. Best Regards, Malcolm "FSt1" wrote: > hi > =IF(OR('Hskp Assign'!C10={"","BLOCK","S"}),"",'Hskp Assign'!C10) > > that should cover BLOCK or S. > > regards > FSt1 > > "Malcolm" wrote: > > > Yesterday I was given a solution to a problem I had when copying text from > > cells in the source sheet to the destination sheet. The formula: > > =IF(OR('Hskp Assign'!C10={"","BLOCK"}),"",'Hskp Assign'!C10) > > was to prevent text from copying to the destination sheet if the word > > “BLOCK” appeared in the source sheet. I have been trying to rework the > > formula to only copy the text if the letter “S” appears in the source sheet. > > I have not had any success. Please help! > > Thanks, > > Malcolm > >
From: Malcolm on 31 May 2010 21:12 Biff, Hi, This one did it big guy. Thank you for saving my bacon on more than one occasion. You are the best. Thanks again. Best Regards, Malcolm "T. Valko" wrote: > Ok, if I understand what you want then try: > > =IF('Hskp Assign'!C10="s","s","") > > > -- > Biff > Microsoft Excel MVP > > > "Malcolm" <Malcolm(a)discussions.microsoft.com> wrote in message > news:45AD1D9F-0D57-481E-9F0B-4F91DF1DE252(a)microsoft.com... > > Biff, Hi, > > Since you gave me the original formula, let me apologize for not being > > more > > precise. It is a new (the only) condition. > > > > Best regards, > > Malcolm > > > > "T. Valko" wrote: > > > >> >=IF(OR('Hskp Assign'!C10={"","BLOCK"}),"",'Hskp Assign'!C10) > >> >I have been trying to rework the formula to only > >> >copy the text if the letter "S" appears in the source sheet. > >> > >> Is that an additional condition or is it a new (the only) condition? > >> > >> > >> -- > >> Biff > >> Microsoft Excel MVP > >> > >> > >> "Malcolm" <Malcolm(a)discussions.microsoft.com> wrote in message > >> news:58E492CC-B225-4B12-8569-6723D48DEE6A(a)microsoft.com... > >> > Yesterday I was given a solution to a problem I had when copying text > >> > from > >> > cells in the source sheet to the destination sheet. The formula: > >> > =IF(OR('Hskp Assign'!C10={"","BLOCK"}),"",'Hskp Assign'!C10) > >> > was to prevent text from copying to the destination sheet if the word > >> > "BLOCK" appeared in the source sheet. I have been trying to rework the > >> > formula to only copy the text if the letter "S" appears in the source > >> > sheet. > >> > I have not had any success. Please help! > >> > Thanks, > >> > Malcolm > >> > > >> > >> > >> . > >> > > > . >
From: T. Valko on 31 May 2010 21:53
You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP "Malcolm" <Malcolm(a)discussions.microsoft.com> wrote in message news:10F868EC-3F88-4473-9755-55858D72D540(a)microsoft.com... > Biff, Hi, > This one did it big guy. Thank you for saving my bacon on more than one > occasion. You are the best. Thanks again. > > Best Regards, > Malcolm > > "T. Valko" wrote: > >> Ok, if I understand what you want then try: >> >> =IF('Hskp Assign'!C10="s","s","") >> >> >> -- >> Biff >> Microsoft Excel MVP >> >> >> "Malcolm" <Malcolm(a)discussions.microsoft.com> wrote in message >> news:45AD1D9F-0D57-481E-9F0B-4F91DF1DE252(a)microsoft.com... >> > Biff, Hi, >> > Since you gave me the original formula, let me apologize for not being >> > more >> > precise. It is a new (the only) condition. >> > >> > Best regards, >> > Malcolm >> > >> > "T. Valko" wrote: >> > >> >> >=IF(OR('Hskp Assign'!C10={"","BLOCK"}),"",'Hskp Assign'!C10) >> >> >I have been trying to rework the formula to only >> >> >copy the text if the letter "S" appears in the source sheet. >> >> >> >> Is that an additional condition or is it a new (the only) condition? >> >> >> >> >> >> -- >> >> Biff >> >> Microsoft Excel MVP >> >> >> >> >> >> "Malcolm" <Malcolm(a)discussions.microsoft.com> wrote in message >> >> news:58E492CC-B225-4B12-8569-6723D48DEE6A(a)microsoft.com... >> >> > Yesterday I was given a solution to a problem I had when copying >> >> > text >> >> > from >> >> > cells in the source sheet to the destination sheet. The formula: >> >> > =IF(OR('Hskp Assign'!C10={"","BLOCK"}),"",'Hskp Assign'!C10) >> >> > was to prevent text from copying to the destination sheet if the >> >> > word >> >> > "BLOCK" appeared in the source sheet. I have been trying to rework >> >> > the >> >> > formula to only copy the text if the letter "S" appears in the >> >> > source >> >> > sheet. >> >> > I have not had any success. Please help! >> >> > Thanks, >> >> > Malcolm >> >> > >> >> >> >> >> >> . >> >> >> >> >> . >> |