#1
|
|||
|
|||
Analysis of Amount based on following criterion.
Dear All,
i want to analyse me data as per requirment. The Attached file is a sample. As per our client requirement the data analysis is as follows. Based on Plant say LAO Remove Cladding total Amount Remove Insulation Total Amount New Cladding Total Amount New Insulation Total Amount Reinstall Cladding Total Amount Reinstall Insulation Total Amount Then total ( All above six job ) for Plant Lao. The same for all rest of the Plant i.e Col B. Note:- I have applied sort techniques for each plant but it is tedious and time taken job. So Im looking best way to achieve this task. Any help. Rgds, Aligahk06 |
#2
|
||||
|
||||
Hi,
Simplest solution is to build a Pivot Table (just use the wizard for this). Cheers, |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Force Kiosk published PPT to return to a specific slide after x amount of minutes | jasoomian | PowerPoint | 1 | 07-31-2010 03:09 AM |
Convert Dollar amount to text | GeorgeLawshe | Word | 0 | 03-07-2010 10:17 PM |
Is there a way to change the header in a large amount of documents at one time? | ntsstaffing | Word | 1 | 07-11-2009 12:12 PM |
Setting up Analysis Sheet when data does not exist, yet. | burnoutdetective | Excel | 0 | 10-13-2008 05:57 AM |
Microsoft Access - Form For Sales Analysis | kennyharrill | Office | 0 | 09-15-2005 08:49 AM |