Hello,
I have a table of information. I am trying to write a formula that compares the values in the columns of the table, and it need to place an 'x' if it meets the below condition. Attached an excel file with this information.
Any ideas on how I make this work? Appreciate your help!
Condition: if project id, production column cell values are same, keep 'x' in one cell corresponding to the highest 'HP' value in summary column, If 'HP' value is same in more than one cell, keep 'x' in any one cell. If project id and production column cell values are different, keep 'x' in summary column for each different row.
Thanks,
pm.
Bookmarks