Hi all,

Please help me on the following:

I have about 1328 row of records with mixture of different products, those
products delivered with different turn around time.

For example

Product tour aorund time column C
A 1 0-90 Days
B Not delivered yet Not delivered yet
C 282 181-365 Days
D 86 0-90 Days
E 109 91-180 Days
A 304 181-365 Days
B 209 181-365 Days
C 144 91-180 Days
D 67 0-90 Days
E 352 181-365 Days
F 35 0-90 Days
G 180 91-180 Days
H Not delivered yet Not delivered yet


Please help me on how to set a formula in column C for 4 categories stated
above, as it is very time consuming to manual put in the category for 1328
rows.

Thanks