Recent content by Dhruva

Thank you shades for this piece of educational information.

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...

Thank you so Much and sorry for not looking into these basic things...

Hi Shades, That was a typo from my side. Please see the attached spread sheet. Could you let me know what could be wrong here ?

Hi Shady, I tried this with a little change to the formula. Following is the result I have got which deviates from my expectation. Job-----Value--Occ ABC2DX-- Y---0 ABC2DX-- Y---#N/A ABC2DX-- N---#N/A LKNJ12X- Y---#N/A LKNJ12X- Y---#N/A ABX1234- N---#N/A ABX1234- N---#N/A ABX1234- Y---#N/A...

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...