Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help matching similar data...
Firstly, this is the task I'm faced with...
I've got a worksheet (Maintenance Data) listing 26,000 scheduled jobs to be undertaken in schools around birmingham from 2008 - Then I've got 5 other sheets (PM Orders 08-09, PM Orders 09-10 etc) containing approx 65,000 emergency jobs that have been completed since 2008. What I need is to make sure none of the 65,000 completed are in with the 26,000 needing to be undertaken. Maintenance Data contains the following column headings: A: Site Type - B: School Code - D: Standardised School Name - E: Priority Code - G: Condition Code - I: Location - J: Element - K: Sub Element - L: Defect - M: Remedy - N: Date Entered - P: Repair Estimate Current - Q: Standardised Description - R: Sub Contractor 1 - S: Sub Contractor 2 PM Orders contains the following column headings A: School Name - B: Standardised School Names - C: Site Type - D: School Code - E: Order No. - F: Planner Group - G: Fault Description - H: Order Type - I: Start Date - J: Total Planned Costs - K: Total Actual Costs What I have done is to assign a unique code to each school across all work sheets however other than that there are no similar data fields so I'm at a loose end as to where to start? How would you guys go about doing this? Any help, GREATLY appreciated! |
#2
|
|||
|
|||
Quote:
Are there no other references available on the data? "Job number", "Date raised" etc. ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help matching similar data...
On Wednesday, July 25, 2012 6:28:12 AM UTC-5, Jay07 wrote:
Firstly, this is the task I'm faced with... I've got a worksheet (Maintenance Data) listing 26,000 scheduled jobs to be undertaken in schools around birmingham from 2008 - Then I've got 5 other sheets (PM Orders 08-09, PM Orders 09-10 etc) containing approx 65,000 emergency jobs that have been completed since 2008. What I need is to make sure none of the 65,000 completed are in with the 26,000 needing to be undertaken. MAINTENANCE DATA CONTAINS THE FOLLOWING COLUMN HEADINGS: A: Site Type - B: School Code - D: Standardised School Name - E: Priority Code - G: Condition Code - I: Location - J: Element - K: Sub Element - L: Defect - M: Remedy - N: Date Entered - P: Repair Estimate Current - Q: Standardised Description - R: Sub Contractor 1 - S: Sub Contractor 2 PM ORDERS CONTAINS THE FOLLOWING COLUMN HEADINGS A: School Name - B: Standardised School Names - C: Site Type - D: School Code - E: Order No. - F: Planner Group - G: Fault Description - H: Order Type - I: Start Date - J: Total Planned Costs - K: Total Actual Costs What I have done is to assign a unique code to each school across all work sheets however other than that there are no similar data fields so I'm at a loose end as to where to start? How would you guys go about doing this? Any help, GREATLY appreciated! -- Jay07 I would have to see the file with examples. |
#4
|
|||
|
|||
Quote:
The 'Maintenance Data' sheet is very detailed & accurate with all works broken down into locations/element/sub-element/revised descriptions etc - I know because I compiled it myself from condition surveys carried out in 2008. The 'PM Orders' sheets have just been pulled from reports off a system with very open input methods so not broken down at all and just a mass of info in a cell. |
#5
|
|||
|
|||
Quote:
If you're not happy posting it here you can send me a PM and I'll give you an email address you could send it to... |
#6
|
|||
|
|||
Cheers bud. Just PM'd you.
|
#7
|
|||
|
|||
Excellent. Replied with an email address.
|
#8
|
|||
|
|||
Quote:
hi the data is very common for you but its very new for us , plz attache some of the data to work on it. if don't want to attach it here you can mail it to me @ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need chart of 1 data set plotted against another similar data set | Charts and Charting in Excel | |||
matching similar values | Excel Programming | |||
Matching identical data using data only once in the matching proce | Excel Discussion (Misc queries) | |||
Similar Data | Excel Discussion (Misc queries) | |||
Matching data and linking it to the matching cell | Links and Linking in Excel |