Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic data formatting
I need to show the raw data in different formats.
In the first sheet, a web application will fill the raw data based on the filtering criteria. The second sheet will show the raw data in different format with rich formatting applied. There will be some formuae applied to show summation, percentage etc. I found that pivot table does not give the look and feel which I require. Can some provide the solution for this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic data formatting
I suggest you construct a sumproduct table on sheet 2. This can "analyse" a varying number of rows of data in sheet 1, providing you can ensure the columns are in the same order every time. If column A contains names, and cell A1 = names, likewise if column B contains ages, the formula will be something like: =sumproduct(($a$2:$a$1000="fred")*($b$2:$b$100039 )) this finds all the freds that are 40 or older. -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=557804 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loss of formatting in chart data tables | Charts and Charting in Excel | |||
How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the formatting & URLs!) | Excel Discussion (Misc queries) | |||
my formatting changes do nothing to the data | Excel Worksheet Functions | |||
Retain PivotTable formatting after "Refresh Data" | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |