If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can't rework the formula
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 |
#2
|
|||
|
|||
Can't rework the formula
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 |
#3
|
|||
|
|||
Can't rework the formula
=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" wrote in message ... 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 |
#4
|
|||
|
|||
Can't rework the formula
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" wrote in message ... 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 . |
#5
|
|||
|
|||
Can't rework the formula
Ok, if I understand what you want then try:
=IF('Hskp Assign'!C10="s","s","") -- Biff Microsoft Excel MVP "Malcolm" wrote in message ... 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" wrote in message ... 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 . |
#6
|
|||
|
|||
Can't rework the formula
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 |
#7
|
|||
|
|||
Can't rework the formula
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" wrote in message ... 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" wrote in message ... 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 . . |
#8
|
|||
|
|||
Can't rework the formula
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Malcolm" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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 . . |
Thread Tools | |
Display Modes | |
|
|