Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default Need help sorting data

I have a list of 16,0000 recipients each of them has products from 1-41
unfortunately the data provided doesnt put the products in each column
properly. Although I have columns 1 to 41, recipients who dont have certain
products screw it up, one may have products 1,3,7,9,16,22,23,24,41, another
may have all of them or just one or two, I need to find a way to get the data
to sort under the proper column, so that product 3 is under column 3 and so
on. right now the products have no names just 1 to 41, is this possible?


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
Sorting Data MicMicHK Excel Worksheet Functions 15 March 1st 09 06:46 PM
Sorting Data Penrhos Excel Discussion (Misc queries) 0 January 29th 09 12:55 AM
Sorting of data ub Excel Worksheet Functions 2 April 1st 08 03:34 PM
Sorting data to match existing data Jack C Excel Discussion (Misc queries) 4 May 24th 06 09:48 AM
colors of bar charted data don't follow data after sorting Frankgjr Charts and Charting in Excel 2 January 17th 06 12:33 PM


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

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

About Us

"It's about Microsoft Excel"