I would like a formula method along with a short macro to do it as well.
I know there's some sort of search/then Right formula thing going same within the macro but i still dont know how to keep the "^" out. see the attached excel file for an example. This main issue needs to be corrected for Column C cells. I also need a macro for Column D's formula. or a macro that would complete column C and D with the criteria listed within the Cells/Formulas
Two logics within Column C: (if value(A2) is located within B2, C2= next number in list( if 1, then C2= SPAY in its place)
SPAY - (if value(A3) is Not located within B3, then C3 = SPAY)
Formula within Column D is it a N or Y?
=IF(OR(C2="SPAY",C2=7),"N","Y")
Thanks for the assistance
Bookmarks