westend9876
Member
Here is my table. I want to return the minimum value from column A in column C only if the values in Column B are equal. Also, I want to highlight the value in column A after it is returned in column C.
Compare column A with column B and return minimum value in column A in Column C
- Thread starter westend9876
- Start date
Here is my table. I want to return the minimum value from column A in column C only if the values in Column B are equal. Also, I want to highlight the value in column A after it is returned in column C.
Smallman
Excel Ninja
Interesting that this question has been sitting on the forum so long. The formula challenge guys would absolutely smash this problem in no time and Mmmm here they come.... I am just saying Peeps… Here is an interim solution, if I could find a way to just avoid the If statement it would be a neat little package.
=IF(MIN(IF(B2=B:B,A:A))=A2,MIN(IF(B2=B:B,A:A)),"")
confirmed with Ctrl Shift Enter
Anyways I have attached a workbook which achieves a result with conditional formatting.
Here we go....
Smallman
=IF(MIN(IF(B2=B:B,A:A))=A2,MIN(IF(B2=B:B,A:A)),"")
confirmed with Ctrl Shift Enter
Anyways I have attached a workbook which achieves a result with conditional formatting.
Here we go....
Smallman
NARAYANK991
Excel Ninja
Hi Marcus ,
I was thinking the same !
I used the formula : =IF(A2=MIN(IF($B$2:$B$10=B2,$A$2:$A$10)),A2,"") entered as an array formula , using CTRL SHIFT ENTER.
Narayan
I was thinking the same !
I used the formula : =IF(A2=MIN(IF($B$2:$B$10=B2,$A$2:$A$10)),A2,"") entered as an array formula , using CTRL SHIFT ENTER.
Narayan
. But they are coming my friend. They are on their way. Actually you are part of that crew 
NARAYANK991
Excel Ninja
Hi Marcus ,
No , I am not in the big league ! And I think the experts are not going to visit this part of the forum for some time ; not until they have a solution to Lori's latest challenge !
Narayan
No , I am not in the big league ! And I think the experts are not going to visit this part of the forum for some time ; not until they have a solution to Lori's latest challenge !
Narayan
Smallman
Excel Ninja
You are big enough mate. Still the forum is very quiet today. I thought maybe a few were sitting on something and would have waded in by now. Speaking of wading in, it would be nice if Westend moseyed in but international time lines may be an issue here.
Take it easy
Marcus
(the Smallman)
Take it easy
Marcus
(the Smallman)
NARAYANK991
Excel Ninja
Hi Marcus ,
Time zones are the reason , I think ; here in India , it's just 8 in the morning ; it's been drizzling all night , and schools have declared a holiday. Looks like it will rain the whole of today.
Narayan
Time zones are the reason , I think ; here in India , it's just 8 in the morning ; it's been drizzling all night , and schools have declared a holiday. Looks like it will rain the whole of today.
Narayan
westend9876
Member
Hi Narayan. It worked perfectly. You rock. Thank you kindly!
Smallman
Excel Ninja
SirJB7
The following is the methodology I used so lets show a like for like comparison, when we do your formula is 17 characters less than mine.
=IF(A2=MIN(IF(B:B=B2,A:A)),A2,"")
Westend
I went to the effort of providing you with a file, with conditional formatting and a formula which does the job. Shakes head....
Smallman
The following is the methodology I used so lets show a like for like comparison, when we do your formula is 17 characters less than mine.
=IF(A2=MIN(IF(B:B=B2,A:A)),A2,"")
Westend
I went to the effort of providing you with a file, with conditional formatting and a formula which does the job. Shakes head....
Smallman