Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Data Consolidation
Consolidate Column Data From Multiple Worksheets into on 1 sheet
Comparing the values or showing percentage analysis of numeric data Pls help me on this Eg Sheet 1 A - values 44 22 33 Sheet 2 A - Values 56 78 66 Consolidates data into 1 sheet 44 + 56/100 the value in percent Using cell reference & dragging makes it difficult Suggest me a easy way ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Data Consolidation
Hazarding a thought here
Assuming sample data as posted in Sheet1 and Sheet2, running in A1 down In Sheet1, Put in B1: =A1+(Sheet2!A1/100) Copy down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Amit Madke" wrote: Consolidate Column Data From Multiple Worksheets into on 1 sheet Comparing the values or showing percentage analysis of numeric data Pls help me on this Eg Sheet 1 A - values 44 22 33 Sheet 2 A - Values 56 78 66 Consolidates data into 1 sheet 44 + 56/100 the value in percent Using cell reference & dragging makes it difficult Suggest me a easy way |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Consolidation | Excel Discussion (Misc queries) | |||
data consolidation | Excel Discussion (Misc queries) | |||
Need how-to or example for data consolidation | Excel Worksheet Functions | |||
Problem with Data Consolidation | Excel Discussion (Misc queries) | |||
data consolidation | Excel Discussion (Misc queries) |