Column A has 50 random values (from A1 to A50). I'm trying to make formula for each cell of column B. The formula is: if the value of left cell is one of top 3 values of column A, then write "Yes", else write "No". I tried to use this in cell B1:
But it doesn't work perfectly because it only works on the largest value, not the second and third values. Any suggestions? Thanks in advance.