Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Edward
 
Posts: n/a
Default sorting data different ways quickly

I am trying to sort project financial data exported from Oracle a different
way to look at in-house labor costs in two categories, Design and Inspection.
The exported data is currently in 9 project phases, each phase having 5
categories, Design, Contingency, Construction, Inspection, and Advertising,.
There are individual task codes within each category that carry a numerical
code within a text string that identify each category, 01, 02, 03, 04, and 05
respectively. The first part of the text string identifies the phase of the
project, the last part of the text string identifies the
vendor/consultant/contractor. The project is too complex to sort the data
using the sort command and I am looking for a more efficient way.
  #2   Report Post  
CLR
 
Posts: n/a
Default

Hi Edward............

You might take a look at Data Filter AutoFilter, or Data Filter
Advanced Filter...........or you might just do Tools Macro Record new
macro and record a macro to do the sorting for you........

Vaya con Dios,
Chuck, CABGx3


"Edward" wrote in message
...
I am trying to sort project financial data exported from Oracle a

different
way to look at in-house labor costs in two categories, Design and

Inspection.
The exported data is currently in 9 project phases, each phase having 5
categories, Design, Contingency, Construction, Inspection, and

Advertising,.
There are individual task codes within each category that carry a

numerical
code within a text string that identify each category, 01, 02, 03, 04, and

05
respectively. The first part of the text string identifies the phase of

the
project, the last part of the text string identifies the
vendor/consultant/contractor. The project is too complex to sort the data
using the sort command and I am looking for a more efficient way.



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
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 05:17 AM
Colors of columns after sorting data in the supporting table Booger_Boy Charts and Charting in Excel 6 January 24th 05 02:41 PM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 05:15 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
use data on master worksheet for sorting Ken New Users to Excel 1 December 7th 04 03:30 AM


All times are GMT +1. The time now is 08:17 AM.

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"