P Pasadu Member Sep 17, 2022 #1 Sir, I want to find the minimum value where the range of cells is greater than zero, and also where the cell is not a percentage. I dont use 365 version please, I use Professional plus 2016. Thank You. Attachments Book1.xlsx 17.7 KB · Views: 5
Sir, I want to find the minimum value where the range of cells is greater than zero, and also where the cell is not a percentage. I dont use 365 version please, I use Professional plus 2016. Thank You.
pecoflyer Well-Known Member Sep 17, 2022 #2 Try =AGGREGATE(15,6,(1/(($D$2:$H$2>0)*(D1:H1<>"difference")))*$D$2:$H$2,1)
P Pasadu Member Sep 17, 2022 #3 pecoflyer said: Try =AGGREGATE(15,6,(1/(($D$2:$H$2>0)*(D1:H1<>"difference")))*$D$2:$H$2,1) Click to expand... Thank you so much sir, it worked perfectly. I appreciate it please, thank you.
pecoflyer said: Try =AGGREGATE(15,6,(1/(($D$2:$H$2>0)*(D1:H1<>"difference")))*$D$2:$H$2,1) Click to expand... Thank you so much sir, it worked perfectly. I appreciate it please, thank you.