Search results

I have a set of data like below. Now I want to set conditional formatting like, If A1=AA then C,E,F column will return N/A filled with red color otherwise blank. I want to avoid formula in cell. A...B……….C……..…D……..…E………....F 1 AA…………….N/A……………....…N/A……..N/A 2 3

How to add a prefix in particular cell. Suppose if I put 11022103 it will automatically return 2211022103. Here I add 22 with my putting value. 22 will be same for entire column.

I have two separate tables like below where unique ID may be duplicate. Now I want to set a formula in return Value column of Table 1 where the value will be Time A of Table 2 and the same should be the closest lesser value of Time A of Table 1 Table...