Find Minimum value in column and return with L1,L2,L3 …..

**ExcelUser2707** · 06-29-2016, 03:53 AM

HI Experts,

Please help me, as I am stuck to format equation. In column A I have amount range. I want result in column B i.e. identify lowest 10 amount from column A and return with L1, L2, L3 and so on in front of that particular row. I know Minimum and maximum formula. Still I can’t structure desire result.

In this scenario some time one amount will repeat twice or more.

Please have a look attached file with desire result.

Thanks in advance

ExcelUser2707

**cbatrody** · 06-29-2016, 04:42 AM

Hi,

See the attached file. I have added a helper table to identify the bottom 10 amounts and used the following formula in column B.

Try the following in B1:

{=IFERROR(INDEX($G$1:$G$10,MATCH(A2&COUNTIF(A$1:A2,A2),$F$1:$F$10&$E$1:$E$10,0)),"")}

Please note that this is an array formula and should be confirmed by pressing SHIFT+CTRL+ENTER (only ENTER will not work).

**vlady** · 06-29-2016, 05:31 AM

in your sample out put this one maybe

Formula:

Please Login or Register  to view this content.

if listed accordingly this one (array entered )

Formula:

Please Login or Register  to view this content.

**ExcelUser2707** · 06-29-2016, 07:11 AM

Hi cbatrody & vlady

Thanks you for attending my thread... both suggestions are worked in great manner....

Your suggestion works very well. It is great logic. making new table to call output its great logic. BTW, thanks a lot for sharing knowledge and guidelines.

thanks a lot , god bless you.

Find Minimum value in column and return with L1,L2,L3 …..

LinkBack

Thread Tools

Rate This Thread

Display

Find Minimum value in column and return with L1,L2,L3 …..

Re: Find Minimum value in column and return with L1,L2,L3 …..

Re: Find Minimum value in column and return with L1,L2,L3 …..

Re: Find Minimum value in column and return with L1,L2,L3 …..

Thread Information

Users Browsing this Thread

Similar Threads

Find minimum value(s) in column and gather corresponding name from another column

Return the minimum value of the cells within another column fall between two values

Return Minimum value of rows with blank value in another column

[SOLVED] return of row and column header for a minimum value af an array

return of row and column header for a minimum value af an array

Find most frequent minimum value and return the name

[SOLVED] Minimum qualifiers to Find (VBA) the actual last used Row, Column

Bookmarks

Bookmarks

Posting Permissions