Hi I'm trying to find min value for each ID with formula:
but it return for me the last value for last ID , I need sth like this ex:Please Login or Register to view this content.
Please Login or Register to view this content.
Hi I'm trying to find min value for each ID with formula:
but it return for me the last value for last ID , I need sth like this ex:Please Login or Register to view this content.
Please Login or Register to view this content.
this would be one way if you have the minifs function available to you... =IF(COUNTIF($A$2:A2,A2)=1,MINIFS($B$2:$B$7,$A$2:$A$7,A2),"")
otherwise you'll need an array formula.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Try
=MINIFS(B:B,A:A,A2)
Life's a spreadsheet, Excel!
Say thanks, Click *
this would be the array formula... =IF(COUNTIF($A$2:A2,A2)=1,MIN(IF(($A$2:$A$7=A2),$B$2:$B$7)),"")
activated by pressing ctrl+shift+enter at the same time so {} appear on both ends of the formula, you cannot add them as it will not work.
it doesn't for me, you sure you activated it correctly with ctrl+shift+enter while still in the formula bar then autopopulate down after activating it?
Ace, it appears that minifs isn't available for 2016
https://support.office.com/en-us/art...c-72eef32e6599
as I recommended it too
Good, glad you got it working AND thank you for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks