Getting the data from some cells (the slightest data)

the87boy

New Member
Joined
Aug 26, 2006
Messages
18
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

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
Or simply...

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

...confirmed with just ENTER.

Hope this helps!
 
Upvote 0
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))),"")

=OM(RADER($E$4:E4)<=$E$2;INDEX($A$2:$A$5;MINSTA(OM($B$2:$B$5=$E$1;RAD($B$2:$B$5)-RAD($B$2)+1);RADER($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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,226,498
Messages
6,191,376
Members
453,655
Latest member
lasvegasbuffet

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?

Disable AdBlock

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
Back
Top