Need excel formula

[common-man]

Dear all,

I have attached a sample sheet, where i need your help.

Basically in column A, is date, column B is number, column c is company column d is rate.
What i need in column e corresponding to the rate cell is the company name where the least number of column b has occurred in relation to particular date for that particular company. For eg, ILFCM in column E which is least number in column b in relation to particular date for that particular company. The same for API as well ( which i have mentioned in attached sheet). I want to have formula, which will automatically find my desire result for large data base.

Hope i made my problem clear to you all.

 

[Nebu]

Hi:

Is this what you are looking for?

Thanks

 

[common-man]

Thanks, nebuji. Extremely sorry it wouldn't, if you see Barun in your result it is 270 while my desired result corresponding to column b is 271. Hope that you got it.

 

[Nebu]

Hi:

I have change the pivot and highlighted the transactions I am getting in the pivot.

Thanks

 

[puneeth2303gowda]

Hello Common Man,

Hope this works for you.


Puneeth

 

[common-man]

Puneeth ji,

It worked. Thanks a lot.

 

[bosco_yip]

Or try this, similar to Puneeth's but without helper and non-CSE formula.

In E2, copy down :

=IF(COUNTIFS($A$2:A2,A2,$C$2:C2,C2)=1,C2,"")

Regards

 

[common-man]

Bosco yip ji,

Thanks a lot, it's working and easy too.