In the attached, in columns AG:AJ are formulae. They can all be copied from cell AE5.


The results are in the same pattern as your manual entries but either I've made a mistake about what you want or your counting is awry (or your translation of counts to letters is).
So for information only I've added the count part of the formula to columns AL:AQ (grey highlight) so you can check it's doing things right. After that you can delete columns AL:AQ.


For this to work well, you need to have proper Excel dates in row 1: cells C1:V1 and cells AE1:AJ1. I have done this in the attached. The values you had in there were just strings. Excel might have interpreted them properly but you could never be certain of that. The values in your cells Y1:AD1 would not be recognised as dates at all.

Attached Files

msofficeforums47759Sample Excel1.xlsx (17.3 KB, 10 views)

hi, p45cal

appreciate your help.
I have just tested the sample that u attached.
I found out the result dint really match what I want because the result only G & Y.
those R also turned to Y.
do you mind to take a look again?

G = there is totally NO negative value on Row Name "Proj OH" in between date
Y = if 1 or 2 negative value on Row Name "Proj OH" between Col C - Col P
R = if 3 or more negative value on Row Name "Proj OH" between Col C - Col P and negative value on Col Q - Col S.