Forum Discussion
gautamga
Oct 26, 2021Copper Contributor
minimum value of column a based on unique values in column b
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 ...
Riny_van_Eekelen
Oct 26, 2021Platinum Contributor
gautamga I would use a pivot table. See screenshot below (taken on a Mac but similar on PC).