Return all values less than or equal to another number, but in order

**LittleFry** · 10-02-2014, 08:47 PM

I have a set of numbers in column A with a ranking in column B. C3 contains a number which will be used to gather all numbers from column A less than or equal to C3.

This formula works, but how can instead the results be in numerical order?

CSE
=IFERROR(INDEX($A$1:$A$10,SMALL(IF($B$1:$B$10<=$C$1,ROW($A$1:$A$10)-ROW($A$1)+1),ROWS(D$1:D1))),"")

On the attach sheet is it possible to return the results in column G versus column D?

**Richard Buttrey** · 10-02-2014, 09:18 PM

Hi

Non array, i.e. regular formula in G1 copied down.

Formula:

Please Login or Register  to view this content.

**boopathiraja** · 10-02-2014, 11:57 PM

Try

Formula:

Please Login or Register  to view this content.

**boopathiraja** · 10-02-2014, 11:58 PM

Refer the atatchment

**LittleFry** · 10-03-2014, 07:26 AM

Thank you very much. Both of these solutions work very nicely.

**Richard Buttrey** · 10-03-2014, 07:58 AM

Glad to have helped and thanks for the rep.

Return all values less than or equal to another number, but in order

LinkBack

Thread Tools

Rate This Thread

Display

Return all values less than or equal to another number, but in order

Re: Return all values less than or equal to another number, but in order

Re: Return all values less than or equal to another number, but in order

Re: Return all values less than or equal to another number, but in order

Re: Return all values less than or equal to another number, but in order

Re: Return all values less than or equal to another number, but in order

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] cell not equal to two values, return a third value

Need to return a value from a column when two values from are equal

Making a number of boxes, equal to a value, show fractions of one value in < order

Return all values that equal 0

[SOLVED] string values do not equal cells, then return msg

Bookmarks

Bookmarks

Posting Permissions