Oct 25 2021 11:32 PM
I want to get minimum value of column A , for every unique value in column B . My Column B has multiple duplicate enteries and there are diifferent values in column A for those duplicate enteries of columnB . I want to save minimum value of column A and corresponding value of Coumn B in one file for all unique values of column B
I want to save highlighted values in a file
Oct 26 2021 01:09 AM
@gautamga I would use a pivot table. See screenshot below (taken on a Mac but similar on PC).