Need help

[ANKUSHRS1]

I need help for an excel formula...

refer below screen shot...All I want the lower price of all product.

for example
for product A1 the ans will be 22.00.....

 

[AlanSidman]

Pictures are of little value in attempting to help. Attach a file with a before and after scenario. Mock up the after scenario so that we understand exactly what you are needing. Pictures are small and hard to read. Everyone here is a volunteer with limited time and no one really wants to guess at your formats in your spreadsheet and try to re-create them.

 

[NARAYANK991]

Hi ,

If you want all entries to have the minimum price against them , then in D2 , enter the following array formula , to be entered using CTRL SHIFT ENTER :

=MIN(IF($B$2:$B$39 = $B2, $C$2:$C$39))

Copy down.

Narayan

 

[rahulshewale1]

Hii,
Another option,

If you have excel 2O16 ..you can use non array formula .

=MINIFS($B$2:$B$20,$A$2:$A$20,D3)

Or use pivot table ..

Regard
Rahul Shewale