Hi,
I have one column containing a list of "Yes" and "No". There is no significance to this, just a means of filtering the list. I have in another column a list of numbers. I would like to rank the numbers in the second column, but only if they are next to a "Yes" cell. ie. can I rank cells based on criteria contained in another column?
I have one column containing a list of "Yes" and "No". There is no significance to this, just a means of filtering the list. I have in another column a list of numbers. I would like to rank the numbers in the second column, but only if they are next to a "Yes" cell. ie. can I rank cells based on criteria contained in another column?