Sorting A Table

M

Mike Dalton

I have a table that contains numbers in one column. Yet not every row
has an entry. I am sorting the table on this column specifying that
the data has a format of number. Everything is working fine except
that the rows that have no entry wind up sorting first. I would like
to have these sort last. Is there an easy method to accomplish this. I
am even willing to put some king of character into these cells that
will force them to sort last.
Thank you for any and all help.
 
S

Suzanne S. Barnhill

I haven't been able to identify any character that will cause these rows to
sort last except a number higher than the rest. Can you temporarily enter a
string of 9s longer than the highest figure, then delete these after
sorting?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot sort a table containing text 5
Insert Index into a Table 1
Format column widths from one table to a separate table on same page 1
Space at end of multi page list to accommodate new entries 1
Enhanced paragraph sort - is it possible? 0
Sorting by number 6
Sort Left to Right 1
Dealing with a Pivot Table (when I don't want to) 0

Top