Eliminating duplicates rows in table 09-19-2024 10:02 AM My table has the folowwing data. I only want the row where Col2 has the max value. Is there a method to do this at the Table view level? If not what would be an alternative mehtod? Col1 Col2 1 1 1 2 ...
Excel 365 formula in cell D3: =FILTER(B3:B13,B3:B13<>"")Copy to Clipboard The FILTER function spills values automatically to cells below, the #NUM error shown in the image above is not returned if you use the FILTER function. The following array formula in cell D3 is for versions bef...
Eliminating duplicates rows in table 09-19-2024 10:02 AM My table has the folowwing data. I only want the row where Col2 has the max value. Is there a method to do this at the Table view level? If not what would be an alternative mehtod? Col1 Col2 1 1 1 2 ...