Tuesday, October 9, 2012

yogi_From A Table Of Stores Prices And Transactions Find The Lowest Price Store And Lowest Extended Price

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #801  Oct 09, 2012    www.energyefficientbuild.com.

user Adam Reed said: (http://productforums.google.com/forum/?zx=j1qokp4rhrrx#!category-topic/docs/spreadsheets/QA0TTfcnunc
Lowest Value in Row with Return
I have a row listing prices of items from various stores, using the MIN function I am able to find the lowest value, however, how can I tell what Column that came from so that I may return which store returned the lowest value? 

There you are, thank you for your help!

following is a single array formula solution to the problem