Why have I got some repeating rows after a Excel 2003 sort

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I copied and sorted an existing worksheet which had been obtained from an
unknown source. I found some of the rows were duplicated after the sort, but
with the number column showing different results from the original row and
not formatted.

The original worksheet had no duplicates.

Why would this happen? I have used older versions of Excel for years and
this has never happened before.
 
Hi jayne

are you sure there were no hidden rows in the original data?

Cheers
JulieD
 
You must log in or register to reply here.

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

Cell reference value to remain constant in a sort using Paste Link 2
sorting grouped rows 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Maintaining Row Height When Sorting 3
Sorting changes validation 2
Value used in a Paste Link to remain constant during a sort 1
Sort confusion 2
Sorting non-linked cells in a linked worksheet 1

Back
Top