Search results
-
D
Condition based on color
have one column that consists of many rows. Some rows are highlighted in Yellow and some are not. I want to add another column to this spread sheet. If the cell is highlighted in yellow it should auto populate with "X" else with "y" in the new column. Ex: INput LCD366 LCD378 (this cell is... -
D
problem with sumproduct
Following is the table I have with me. I need to know how many "Y"s are there for each job. For ex, the job ABC2DX has 2 "Y"s and so on.. Job-----Value ABC2DX-- Y ABC2DX-- Y ABC2DX-- N LKNJ12X- Y LKNJ12X- Y ABX1234- N ABX1234- N ABX1234- Y ABX125X- N To achieve the objective, I have...