#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Sort anomaly

Hello, all!!

We are in desperate need of some help.

In sorting two different workbooks with similar data, we are
experiencing an unusual headache. Following the sort there are pieces
of data (within the sort criteria) that are seemingly random in their
repetition. In essence, there are four lines that have identical data
after the sort where previously they appeared only once.

There are a couple of kickers. The phenomenon is not the same user to
user and the data that is being repeated and placed against the
incorrect rows was used for a different categorization at one time.

Basically, we are the village idiots trying to use a sophisticated
application.

Can anyone help us before we lose our minds, make hats out of
pantyhose, and head to the roof forcing the folks across the street to
dance to the tune of a high-powered rifle?

Thanks much...!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Validation Rule anomaly Bob Excel Worksheet Functions 6 March 8th 07 08:36 PM
Sort anomaly in Excel 2003 SP2 on Windows XP SP2 Andyb Excel Discussion (Misc queries) 1 February 2nd 07 03:50 PM
Anomaly with Chart Labels D. Bishop Charts and Charting in Excel 1 September 20th 05 01:36 PM
Another SUMPRODUCT array anomaly Jerry W. Lewis Excel Worksheet Functions 6 May 13th 05 06:42 PM
VLOOKUP Anomaly Tosca Excel Worksheet Functions 6 May 8th 05 09:08 AM


All times are GMT +1. The time now is 06:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"