Looking for formula to look into "Table A2:C30 and return values in E2:G30 If condition is satisfied. Formula will look across column (for example, A1:C1, if all values are the same (meaning duplicate), it should return only one (1) into E1. For this example,For Row 9,HTML Code:If all values are unique across column, formula should return each unique value in E, F and G table. For example,HTML Code:See attached file.HTML Code:
Thanks
Bookmarks