How to find and present the minimum value from a series of data

Hi All

I have a column of descriptions (one in each row) and next to it another column with values through formulas.

Cell A1 to A(n): Name of Providers, Programs
Cell B1 to B(n): Cost of Programs (value in every cell is calculated on the basis of the Program parametres

I can use the "MINA" function to find the minimum value and present it at a certain cell, but:

1. How can I present the description corresponding (Provider, Program) to the min value, before or next to it (the min value) ?
2. What if there are two or more equal ones? (Would be good to present all equals).

Thank you in advance.

Constantine

You can always try this, though if there is more than one with the same minimum value, it will only return the first one:

Please Login or Register  to view this content.

@tarquinious
INDEX() and MATCH() would be preferable to INDIRECT().

So:

=INDEX(A:A,MATCH(MIN(B:B),B:B,0))

@papgas
Are you sure you want MINA() and not MIN()? If so replace the MIN() above.
The above also finds only the first match.
Upload a small sample file so we can advise you on best way to match more than 1.

I don't see any correlation between your "small sample file" and your original request.

Originally Posted by Cutter

I don't see any correlation between your "small sample file" and your original request.

Please, open the file that I uploaded. It is not my "small sample file" but the actual one.
The first two sheets have comments to help you better understand what all is about.

Go to the second sheet "Summary Table" and check the last comment there.
That comment tags some shells where I want to present name of Provider and name of Program that suits best (i.e. is the cheapest) to the consumer's profile as entered at the top of the first sheet "Enter Your data, Here!", and next to Provider's name and Program, the cost for kWhs consumed (kWhs that have been entered).
Names and costs to be presented are picked up from the list above.

So, what I am asking your help for is, to show me how to select the least cost or least equal costs and present it/them, together with the Name/s of the Provider/s and the name of the Provider's program/s that correspond to the least cost or costs (if more than one happen to have the same cost).

I apologise for my poor phrasing and misuse of words that led you not to see any correlation, but English is my fifth tongue (Greek is my mother one).

Thank you again for your time.

Yours,
Constantine

Originally Posted by martindwilson

suggest you actually have a table that can be referenced without any clutter.i take it its the hidden table

OK.
The "Hidden Table" was the initial one for presentation of all programs and relevant costs and the user could come to a result by entering consumptions made both on a 4-month basis and/or, preferably, on a year basis (since the year round consumption covers all seasonal variations).

I would be quite happy if you could come up with a formula for any of the sub-tables together with restrictions on the usage of formula, if any.

Thank you for your time.

Yours,
Constantine