Wednesday, October 10, 2012

Google spreadsheet how to return the column header which has lowest value


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?


Screenshot of the Spreadsheet:

In the above spreadsheet you can see the products are listed along with there prices row-wise, so we are having Column A with product name and then Column B to Column F are having prices from various brands.

So now to get the minimum price we can use function =MIN(B2:F2), which will give us the minimum price from range B2:F2.

So now to get the Brand name from the column header that has the lowest price listed, you can have the following formula:

Use the following formula in Cell G2:

and to avoid the blank columns or any error use the following formula:

and then drag it down as far as needed.

I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.

I also take up private or confidential projects:

If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here: 


No comments:

Post a Comment