Sorry, the formula is what is posted. Yes, I tried the code and it worked, but is calling C1 instead of B3 and working it's way down. In otherwords the formula needs to be applied to C3 but the Match needs to reference B3, then C4 and B4, etc... I tried changing the R1C to R3B but it apparently doesn't work that way, what is R1C exactly?
Bookmarks