How do I sort data that contains to zeros to make the zeros appear at the end of the sort.

**Sharonits** · 02-06-2013, 05:43 PM

I am trying to sort data that ranges from 1-100. some of the imnported data has a value of 0 and that puts it at the top of the sort. How do I make the zero data appear at the end of the sort?

**oeldere** · 02-06-2013, 05:48 PM

maybe hide the 0 values with an filter.

**Sharonits** · 02-06-2013, 05:50 PM

I tried that and it gives me an error in the totals field.

**Moo the Dog** · 02-06-2013, 05:54 PM

You could try a helper column to the right of all of your data. If your values start in A2, type this in a cell in row 2 beyond your data: =IF(A2=0,"z",A2) and fill down.

Then select all data cells AND the helper cells, and sort by the helper column in ascending order.

- Moo

**Sharonits** · 02-06-2013, 05:57 PM

I will try that but I was hoping there would be an easier fix? Is there any way to yuse a filter or a sort function?

**Moo the Dog** · 02-06-2013, 06:04 PM

An easier fix? Not that I know of, but that doesn't mean there isn't one...

- Moo

How do I sort data that contains to zeros to make the zeros appear at the end of the sort.

LinkBack

Thread Tools

Rate This Thread

Display

How do I sort data that contains to zeros to make the zeros appear at the end of the sort.

Re: How do I sort data that contains to zeros to make the zeros appear at the end of the s

Re: How do I sort data that contains to zeros to make the zeros appear at the end of the s

Re: How do I sort data that contains to zeros to make the zeros appear at the end of the s

Re: How do I sort data that contains to zeros to make the zeros appear at the end of the s

Re: How do I sort data that contains to zeros to make the zeros appear at the end of the s

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions