Hi all -
Am looking for help on formula -
I want excel to look at cell C2, then if it has anything (text or numbers), then to look at cell b2. If B2 does not = the letter "C" (b2 will only have one letter or will be blank), or it is "blank", then to copy the contents of c2 to c47. Of course, if C2 is blank, then do nothing.
I'm doing something wrong, obviously - I've tried If/than & isblank formulas but can't seem to structure it correctly.