How to organize cells based on numeric value?

Discuss the spreadsheet application

How to organize cells based on numeric value?

Postby NewOldUser » Thu Dec 06, 2018 4:44 pm

I'd like to start off by saying I don't have much experience when it comes to using spreadsheets. This is all still kind of new to me. That may explain why I'm unable to exactly state what I'm trying to do.

I have a spreadsheet with three columns. A column has URLs. B and C columns have numbers. I would like to organize all of the URLs based on the number data in column B. I highlight column B and go to data. I then choose sort. This will organize all of the numbers based on the first starting number. For example, 2,000,000 200,000 and so forth. I don't want this. I want the numbers to go in order from largest to smallest. For example, I want 2,000,000 and then 1,999,999 and so on. How can I do this?
Open Office 4.1.6
NewOldUser
 
Posts: 3
Joined: Thu Dec 06, 2018 3:14 pm

Re: How to organize cells based on numeric value?

Postby RoryOF » Thu Dec 06, 2018 4:53 pm

Change the selection button to Descending from Ascending in /Data /Sort : Sort tab.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 28427
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: How to organize cells based on numeric value?

Postby NewOldUser » Thu Dec 06, 2018 5:00 pm

The results are still the same. They are grouped based upon the first number. The only difference is they go up or down. I want them to be listed in exact ascending or descending, not grouped according to their first number. I'm not sure if I can convey properly what my problem is.
Open Office 4.1.6
NewOldUser
 
Posts: 3
Joined: Thu Dec 06, 2018 3:14 pm

Re: How to organize cells based on numeric value?

Postby RoryOF » Thu Dec 06, 2018 5:10 pm

You should check if your data is text or numbers. Use /View /Value highlighting to determine this - text will be black, numbers blue and results of a formula green. That same command switches off the display.

 Edit: Entering the , (thousands separator) may define the entry as text. 
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 28427
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: How to organize cells based on numeric value?

Postby NewOldUser » Thu Dec 06, 2018 5:18 pm

The color of the numbers is black when I do this. How do I enter a comma separator? The spreadsheet is already made for me. I'm just trying to organize it.
Open Office 4.1.6
NewOldUser
 
Posts: 3
Joined: Thu Dec 06, 2018 3:14 pm

Re: How to organize cells based on numeric value?

Postby RoryOF » Thu Dec 06, 2018 5:24 pm

One can enter a thousand separator when entering the number by pressing the comma key. However, you ought not wish to do this. I'm not a great Calc user so cannot tell you how to change your text strings to numbers - you'll have to wait for other advice.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 28427
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: How to organize cells based on numeric value?

Postby MrProgrammer » Thu Dec 06, 2018 6:12 pm

NewOldUser wrote:I'd like to start off by saying I don't have much experience when it comes to using spreadsheets.
You need to read [Tutorial] Ten concepts that every Calc user should know. Until you understand some of the fundamentals you will struggle with spreadsheets.

NewOldUser wrote:I want the numbers to go in order from largest to smallest.
The tutorial explains how to convert text strings to numbers so you can sort them in descending order.

NewOldUser wrote:That may explain why I'm unable to exactly state what I'm trying to do.
Most people find they get an answer more quickly if they attach a document demonstrating the difficulty (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself).

 Edit: 
NewOldUser wrote:I highlight column B and go to data. I then choose sort.
No. Select one cell in column B then use Data → Sort to sort A, B, and C together with B as the key. 

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Last edited by MrProgrammer on Fri Dec 07, 2018 1:49 am, edited 1 time in total.
Mr. Programmer
AOO 4.1.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Volunteer
 
Posts: 3618
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: How to organize cells based on numeric value?

Postby Lupp » Thu Dec 06, 2018 10:15 pm

NewOldUser wrote:I highlight column B and go to data. I then choose sort.

If you want the contents of columnns A and C to go with the contents of B when sorting, you need to select all three columns and then in the Sort... dialogue only column B as key.
On Windows 10: LibreOffice 6.2 and older versions, PortableOpenOffice 4.1.5 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 2344
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 43 guests