Nov 16 2018 04:02 PM - edited Nov 16 2018 04:45 PM
Hi there, having a hard time find formulas for my issue.
I need a formula that will search the entire "Stock Codes" column, and replace new information in the "Available" column...Tasks include:
1. Any row in the "Stock Codes" column that has the letter R in it will be replaced with RF in the "Available" column...
2. Any row in the "Stock Codes" column that DOESN'T have the letter R in it will be replaced with RM in the "Available" column...
Is there one formula that can do both items listed?
This girl can't figure it out, any help would be appreciated. xo!
Val
Nov 16 2018 04:42 PM - edited Nov 16 2018 04:43 PM
TRY:
place below formula adjacent to the column of data (column B) and copy down..
=IF(IF(ISERROR(SEARCH("R",A2)),0,1),SUBSTITUTE(A2,"R","RF"),A2&"RM")
Nov 16 2018 04:46 PM
Thank you much for responding, I made some edits to my question right after you responded...I forgot one item...
Nov 16 2018 04:50 PM
Nov 16 2018 04:52 PM
Just tried it, its really close, the only issue is that the number is displayed in the column B, the letters are correct though.
Nov 16 2018 04:53 PM
pls see attached sample..
Nov 16 2018 04:58 PM - edited Nov 16 2018 04:59 PM
pls see attached.
hope this is what you needed.
thanks..
Nov 16 2018 05:00 PM
I see the same on my end, I just need the RF and RM in column B, I dont need to keep the numbers in column B....you are so close my friend
Thank you so much for helping me
Nov 16 2018 05:01 PM
Nov 16 2018 05:07 PM
attached is the revised file..
Nov 16 2018 05:11 PM
I see it!!! thats it, you're amazing! Spent hours trying to figure it out....ughh
Thanks so much!
xoxo
Val
Nov 16 2018 05:32 PM
Nov 16 2018 05:42 PM