Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!

Subscribe for Free Excel tips & more!

Free Excel Forum

Sorting Data Within Cell Low To High?

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Not even sure if this can be done using Excel because it would change the value of the cell. I have a column of 10 numbers that contain up to three digits such as 6,42,74,98,105,184,382,583,634,796. I have used the data sort key to put them lowest to high in the column, but here is the catch.
I would like the program to sort these numbers in the next column over or in same column if easier to read lowest to high with 0 being the lowest so that the above numbers would be 6,24,47,89,15,148,238,358,346,679. Hope you follow what I am after... Any help with this would be greatly appreciated.

View Answers     

Similar Excel Tutorials

Sorting Data by Date, Text, or Number in Excel
Sorting Data can be done with a few quick clicks of the mouse. I have used the same data as the previous 2 tutorial ...
Sort Data Alphabetically or Numerically in Excel 2007 and Later
This Excel tip shows you how to Sort Data Alphabetically and Numerically in Excel 2007. This is a great feature to ...
Ignore Blanks in a Data Validation List in Excel
I will show you 3 ways to remove the blanks from a Data Validation dropdown menu in Excel. All 3 methods are multi ...
OFFSET Function in Excel
The OFFSET function in Excel returns a cell or range reference that is a specified number of rows and columns away ...

Helpful Excel Macros

Sort Data that Doesn't Have Headers in Descending Order in Excel
- Sort data in Excel that doesn't have headers using a macro. This Excel macro assumes that your data set does not have a
Sort Data that Doesn't Have Headers in Ascending Order in Excel
- Sort data that doesn't have headers in ascending order in Excel with this macro. This is a simple sort macro that assum
Sort Data With Headers in Ascending Order in Excel
- Macro that sorts data that has headers in ascending order in Excel. This macro assumes that you data has headers on it.
Sort Data With Headers in Descending Order in Excel
- This Excel macro sorts data that has headers in descending order. This means that data is sorted Z to A and 10 to 1 - o
Reverse Row or Column Order in a Worksheet
- This macro reverses the order of a selected row or column in excel. It will completely reverse the data.

Similar Topics


let's say i have these numbers in COL A

3 ---- new high
12 --- new high
6 >>> min in valley 6 less than last peak
22 --- new high
8 >>> min in valley 14 less than last peak
23 --- new high


thus as each new high is reached, the numbers might back off. in the above example the greatest difference between peak (new high) and valley (lowest low between new highs) is 14

is there a formula i can place in a cell that says:

"take a look at all the numbers on col A, and show me the greatest difference from any new high made to the lowest low until the next new high is made"



Let's say I have 4 rows of numbers...I want to rank them high to low,without having to do a data sort..I would like to assign a number in each of these rows ( with a new column,next to the #),the highest # being assigned a 1 and the lowest # being assigned a there some kind of sum if /max/min formula that would allow me to do this ?


I'm creating a spreadsheet to use for a high school golf tournament.
I need a formula that will take the lowest 4, and only 4, numbers from a column of 4-6 numbers. All numbers must be greater than 0 (in case one team has fewer than 6 players.) In the extreme, the numbers could range from 65-130, though almost all will actually be between 70-100.
Has my meager skills stumped, as it does the computer literacy teacher in our school.
I would really appreciate any advice, or knowledge if anyone has done one of these before.


How i do, i'm trying to apply some lottery filters on a Tickets that i'm producing on daily basis,
(i know many on them)

this filter i Called "Low/High"

For example :

1-.the Lottery have number is 36 (lowest 1, Highest 36)

2-.the 36 Numbers are Identified as two section (Low= 1~18), and (High=19~36)

3-.In order to Filter out "bad combination", the Array Formula (if any) should
a-.identify / count how many numbers are from LOW and many numbers are HIGH

Note :
Combination are in a single CELL,
Combination are with "-" e.i ( 01-02-03-04-05 )
Combination are with 2 digits e.i ( 01-02-03-04-05 )

Example :

Please Login or Register  to view this content.

please I need to get L/H on Column J

Is there a way to do this with function formula?

Thanks YOU ALL.


I have a column comprised of numbers from 000-999. I also have one number in three separate columns as well for your convenience. What I want to accomplish is: sorting these numbers from low to high or high to low.

The numbers look like this...


The result I'm looking for:

(low to high)


OR (high to low)


Appreciate your help.

Dear Friends,

I have a set of some prices. Columns Headers are OPEN, HIGH, LOW & CLOSE.

The set has a 10 days of data. Now at the end of the last record one cell is having a price of Last 5 day's Highest High Value and another is having a cell value which is the Lowest Low of last 5 days.

If the last record is Lower than previous 5 day's Lowest Low than Cell Value will be Highest High of previous 5 days.


If the last record is Higher than previous 5 day's Highest High than Cell Value will be Lowest Low of previous 5 days.

I do not know whether it is possible to do it in a single cell. I tried but failed. Please guide & help.

Thanks & Regards

Avinash Raste

I need to sort rows by column O, lowest to highest (greater than 0), then by column A (date). Let's say the the lowest number after sorting is 5. I would like the 5 to change to 1, then take the next lowest number..hypothetically 13, and change it to 2, the next lowest..24 and change it to 3, and so on until the sort is complete and anything with a zero is under the newly sorted rows. Hope this makes sense. This is WAY above my comprehension but one of you gurus who continue to amaze us novice users can help? Thanks in ladies and gentlemen are amazing!

I hope this one will be an easy one to solve!

I have 2 cells with a range of numbers - lets say A1 = 5, B1 = 8 (A1 is my lowest range, and B1 is my highest number in the range).

When I enter a number in say, cell A3 I want cell B3 to contain a formula that will give a variety of responses depending on the number inputted to A3. For example, if the number 4 is entered into A3 then B3 will say "too low" (ie: its lower than A1). If the number in A3 is 10 then B3 should say "too high". If the number in A3 is 6 then B3 should state "within range".

The idea is that i can easily change the lowest & highest numbers in my range by changing the numbers in A1 & B1 rather than changing all the formulas everytime.

Hope that makes sense.

Can anyone help please as i have been searching for hours to do the following:.........

I have column M on a worksheet listing 9.25,8.66,8.63,8.73 and 9.63 on rows 10-14 ... in column S i have to sort the numbers from highest to lowest but number them 1-5 (1 being lowest and 5 being highest)

So column M will have the list as above but column S will have the numbers 4,2,1,3,5

Can this be done, any advise gratefully received.

Many thanks


My setup:

OS = Win7
Excel = 2007

I am trying to sort 1611 rows of data, which is under 5 column headings, the data looks like this:

The sort needs to sort through the data and arrange them by LCHKIN from lowest date to highest, then from TOT CHCKOUT from lowest to highest, and finally the CALL NO from lowest to highest. In order for you to see which books were used the least, and when last they were checked in, and by sorting the call no. makes it easier for you to find the book on the shelves.

These are the steps I used:

1. CTRL + A
2. Select the Data tab
3. Click Sort
4. Add the following sort functions seen below:

However, these are the results I get, which is incorrect to what I wanted.

Hi there.

I am using the following formula in a cell to get the High Price of EUR/USD for that day (forex, quotes from MT4) :


Now - on my spreadsheet. Users are required to enter the Highest price met for the duration of their trade AND the lowest Price met for the duration of their trade.

I have 2 problems:

The HIGH price quoted (using the formula above) is not necessarily going to be the Highest Price during (users) trade. Example, that high price might have been hit well before user even enters into a trade.

So - i have figured a workaround (i think) but just need a bit of help to implement this.

I need to write this in VB code.


Once a user enters into a Trade - i will need the following formula pasted
into column active Cell row + column BP. However - this formula needs to change depending on what the user selected in Active Cell row + Column C.
Example, JPY/USD or EUR/GBP or EUR/USD, etc, etc.


Since i need to grab the Highest & Lowest point reached during that particular trade. What VB code can i use to look at the cell's Highest Value reached (since this will always be changing) and then store that data and (also) for the cell's lowest value reached and then store that?

So now we have the entry point fixed because the formula for getting the live quotes ONLY gets entered into the cell once user enters into a trade.

However, once user ends this trade (which will be on Active Cell Row + column BO) i would then like the formula in Active Cell Row + Column BP to get overwritten with the stored data.

I hope all this is possible.
Hope someone can help.

Thanks in advance.

Hi, if I have 3 fields filled in with numbers (A1 to A3), I want to find a formula in column B that indicates between B1 and B3 LOWEST, MIDDLE and HIGHEST.
Is there any formula that can compare A1 to A3 and give the above output in the B column next to the numbers?

This ones a little complex ( I think anyway )

What I need to do is have a column scoped for say the #2..

lets say column H has mins pop up every minute.. but not shown until that min has arrived.. like it will show intevals down to 0 mins left.. on each webquery refresh.. 20 then 20 and 19 then 20,19,18 then 20,19,18,17 etc etc

like so..


now on each minutes rows are numbers from say column J to P

what I need to do is find say minute 2 ( 2 in the column H if there is one up yet) then select J:P for #2's (the min) row.. and highlight the Ranking of the lowest number, the second lowest number, the third lowest number and the fourth. All in green.

Sometimes there may be 2 3rd lowest numbers or more.. or 4th lowest..

any ideas? I have it in my mind but cant/dont know where to start lol.

Id probably make some super long macro that is time consuming and not effecient.. I read somewhere on the net that I am classified as a "Spaghetti Programmer" or something lol.

Any help would be awsome!

I'm trying to set up my own Golf Handicapper (yes I understand that I can download one or use a free version online, but I like to tinker in Excel)

I have a list of Handicap Differentials I want to take an average of but, certain conditions apply:

If I have a X differentials I want to take the average of Y of them.

5-6.......................1 Lowest
7-8.......................2 Lowest
9-10.....................3 Lowest
11-12...................4 Lowest
13-14...................5 Lowest
15-16...................6 Lowest
17........................7 Lowest
18........................8 Lowest
19........................9 Lowest
20......................10 Lowest

I've set up a named range on a different sheet with these figures. And have used VLookup and Count to get the number of differentials I need to take.

Where do I go from here.

I have a long list of temperature difference data. In the list is sets of 24 numbers, that correspond to an hour every day. So pretty much I have 24 values (1 for each hour of the day) and then a blank row, then 24 more numbers, then a blank row, 24 more numbers, and then a blank row... etc etc... and this goes on for approximatly 7 months.

I want to pick out the high value and the low value out of each of the 24 values (ie. the highest and lowest number each day). Is there any way to do this? I don't wanna have to go to each day, look at the 24 values and see which is the highest and the lowest because over a 7 month period, this would take a long time, and I have to do it multiple times in different worksheets

Thanks for the help

Anyone know how to easily calculate the average of the lowest say 5 numbers in a series of numbers? - I can't simply sort the data since their are hundreds of lines of data that change each monthly update. Just want a formula that will look at the series in columns a to m and tell me the average of the lowest 5 numbers

Hi all...

I have a sheet with random numbers from -100 to 100 in a1:a50, in b1:b50 are names.

In c1:c4 I would like to return the 4 highest numbers in A in decending order.

in C5:c8 I would like to return the 4 lowest numers in A in ascending order.

in D1:D8 I would like to return the names from B that correspond to those high and low numbers in C, the numbers in column A are not unique.

I know how to pull the 4 highest an lowest useing large and small but I cant figure out how to pull over the name from B?


Hi! I have a long list with names of banks. I also have three different numbers (between 1 and 10) for every bank. Eg Bank A 5 7 4, Bank B 5 9 3. Sometimes there are not three numbers for a bank but only one or two. There are never more than three numbers though. I want to have a forth column. This column shall give me a new number based on the other numbers. The sorting shall work like this. If a bank only has one number then that number shall be presented in the forth coulmn. If there are two numbers then the lowest one shall be used. If there are three numbers then the two highest numbers shall be chosen and if they are different the lowest one of the two highest shall be presented in the forth coumn. I do not know if you can do this using normal worksheet function of if a user defined function is necessary. PLease any help very much appreciated! Thanks alot!

(1) A Formula to take the value in Column A and say (if B2>A2, "High","") Then calculate, High-D1, result multliped by E1and indicate this result in COLOUR. Or say EXCEEDS.

(2). Second Formula to to pick up all High and multlipy by G1 and which are not High multlipy by G1 as well. (This is to find out the Heighest and Lowest percentages.)

Hi. I have got Daily High Low and Close data for stock prices for many years.

ie. 8/1/2009 100 90 95
8/2/2009 98 92 96 etc.

I would like to find the Highest High, Lowest Low for each week, as well as month. I would like the Highest High, Lowest Low and ending( last day of week and month) Close for the week and month to be put in separate columns as and when they occur so that I can make use of them in calculations.
I hope I have made my self clear. I hope someone can help. Would be much appreciated. Thanks.

Hi I need help with a spreadsheet!
I have a range of numbers -

I need to be able to input a number eg: 1225 and pick from this list to make up this exact number starting from the highest number to the lowest number..........some of the numbers may appear more than once, as I go down and use the higher numbers I need it to move down to the next lowest number once these high numbers have run out.

Is this possible to do? It is used to work out spaces inbetween blades on a steel slitting machine. So they may be asked to cut 180.00mm out of a 1500mm wide sheet so I need to set up the spaces inbetween two blades to 180.00mm.

Any help would be greatly appreciated.

I have an application that produces a column of 6 numbers, and most of the time these numbers are close in value or even have two or three of the same values. But others will be way off. Here is an example


I am having to find a way of pulling out the three lowest numbers, but the numbers within a few percent of the pattern that the column is establishing. So above, the three lowest would be considered 28.7, 28.7 and 28.5. The actual lowest numbers are considered anomolies. What I would like to do is use something like MODE but have it find numbers with approx 2% of each other so when I get a column with numbers within a tenth of each other, I will still get a MODE return. Thus in these numbers,


28.6 would be the MODE number returned. Any suggestions?


Bill Biggs

Trying to use the High water Mark method in order to establish a draw down, from new high to low.In the sheet attached looking at "Simple Example" Column V gives the Time series. So the highs occur at 36,48,56,61,70 and 75.What I am trying to calculate is the lowest values between 2 highs. For example between 1st High(36) and 2nd High(48) the minimum value was 12.Between the 2nd High (48) and 3rd High(56) the minimum value was 20 and so on. Thus the draw down between 1st and 2nd High was 1st High-Min value(1st high-2ndhigh)=36-12=24.

Thus in a whole time series I need to produce an automated calculation rather than manually looking at the values and by hand selecting the ranges.

I have made an attempt with the complex example side.

Dear All,

I have an excel sheet with 121 rows of stock data ( Open, High, Low & Close. ) and a Candlestick Chart of it.

Now I want to change the scale of " Y " axis according to the prices of the stock. For eg. If a stock is renging between 100 to 300, that means, Lowest Low of the stock of 121 days ( Data in The Sheet ) is 100 & Highest High is 300 then the scal of " Y " Axis -

Minimum = 80 ( 20% less than Low )
Maximum = 360 ( 20% More than High )

So, the scal of " Y " Axis will change automatically according to the price of the stock after calculating Lowest Low & Highest High of the data given in the sheet.

Is this possible by Macro or by coding ? If yes, please help.

Thanks & Regards

Avinash Raste

hi excelers, I will try to make this question clear:

how does one find the lowest or highest numbers from other numbers i.e.

(highest num) "25"
(lowest num) "5"

which number 6 or 20 match closest to the two numbers above!

should result in = "6" as its the closet by digits to lowest num 5.
but 20 is not chosen as its 5 digits away from 25.

hope this is clear