Forum Discussion
Kunal_Mehta
Apr 12, 2023Copper Contributor
EXCEL FORMULA
Hi All, I have attached a sample data where i have two sheets in Excel. The data which i want from sheet 2 in sheet 1 is cloud classification column in sheet 1 cloud classification column but based...
Lorenzo
Apr 12, 2023Silver Contributor
Hi Kunal_Mehta
Could you revise the title of this thread so it better reflects the challenge please (this will help people who Search this site) - Thanks
in A2
=SORT(UNIQUE(D2:D9))in B2
=XLOOKUP(MAXIFS(E2:E9,D2:D9,A2#),E2:E9,F2:F9)