I need help solving the problem. I need to put on SharePoint an excel file that would be populated with data, but if some data is repeated in three cells within in single row in two sheets conditional formatting will change color of cell. But I dont know how in sheet2 column C to return value from row that is duplicated (I color cell in sheet2 in excel file in attachment).Is it possible solve this only with formulas?
Thanks in advanced
|