# Getting the data from some cells (the slightest data)

#### the87boy

##### New Member
I have some cells, who look like this:

Code:
``````| Version | Price |
-------------------
| a | 200\$ |
------------
| b | 300\$ |
------------
| c | 100\$ |
------------``````

I will like to get the slightest data in the version cells, which in this example is c
I hope some of you understand, because my english is not so good, as it could be

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Hi,

If I understand you correctly, you want the lowest value in a column.
A formula like =MIN(B2:B10), where B2 to B10 held the data, will do it for you.

Also, if your English is not always good enough for you to get the answer you want, we do have a forum where you can post questions in other languages.

Denis

Hi the87boy

What I understood:

- You want the value in column A in same row as the minimum value of column B.

Assuming you data in A2:B4 as in the example:

Code:
``=index(a2:a4,match(true,b2:b4=min(b2:b4),0))``
This is an array formula and MUST be confirmed with CTRL+SHIFT+ENTER and not just ENTER.

Hope this is what you want
PGC

pgc01 -> Yes, that is what I want, but I can't find a way to translate it to the danish verison

SydneyGeek -> It wasn't that, I was searching for, but I know, if I asked in the other languages room, it is taking too long time, before I get an answer

Or simply...

=INDEX(A2:A4,MATCH(MIN(B2:B4),B2:B4,0))

...confirmed with just ENTER.

Hope this helps!

Domenic -> Yes, that helped me :P

Book6
ABCDE
1VersionPriceMin100
2a2002
3b300Cheapest Version(s)
4c100c
5d100d
6
Sheet1

I guess Swedish would be ok too...

E1:

=MIN(B2:B5)

E2:

=COUNTIF(B2:B5,E1)

=ANTAL.OM(B2:B5;E1)

E4:

=IF(ROWS(\$E\$4:E4)<=\$E\$2,INDEX(\$A\$2:\$A\$5,SMALL(IF(\$B\$2:\$B\$5=\$E\$1,ROW(\$B\$2:\$B\$5)-ROW(\$B\$2)+1),ROWS(\$E\$4:E4))),"")

The last formula must be confirmed with control+shift+enter (not just with enter) then copied down.

You can obtain the same results with a pivot table.

Aladin Akyurek -> It just gave it a design, who looks better :P

Aladin Akyurek -> It just gave it a design, who looks better :P

Actually, Aladin's solution takes ties into consideration. In his example, you'll notice that there are two versions with the cheapest price, Version C and Version D. His solution lists them both. If there were more than two tied for the cheapest price, then they would all be listed.

Replies
9
Views
227
Replies
1
Views
194
Replies
17
Views
336
Replies
3
Views
289
Replies
2
Views
295

1,207,110
Messages
6,076,604
Members
446,216
Latest member
BEEALTAIR

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back