Thread
:
Querying a list with Excel
View Single Post
#
2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
JE McGimpsey
external usenet poster
Posts: 4,624
Querying a list with Excel
I'd recommend a Pivot Table...
See Debra Dalgleish's beginner's tutorial at
http://peltiertech.com/Excel/Pivots/pivotstart.htm
She's also got a lot more good stuff on PTs at her site:
http://contextures.com/tiptech.html
In article ,
(Martin) wrote:
I am starting out with a list like
Tech Date Code Actual Billed
DON 11/15/2004 E 5.40 6.00
DON 11/15/2004 W 3.00 4.00
DON 11/15/2004 E 4.00 4.00
DON 11/15/2004 DO 0.30 4.00
DON 11/15/2004 HD 8.00 0.00
Paul 11/15/2004 E 3.00 4.00
Paul 11/15/2004 E 2.30 2.00
Paul 11/15/2004 E 0.40 0.50
Paul 11/15/2004 E 0.60 0.50
Paul 11/15/2004 E 3.00 3.00
Paul 11/16/2004 W 3.00 0.90
Paul 11/16/2004 CV 2.00 2.30
Paul 11/16/2004 CV 2.40 2.00
Fred 11/15/2004 PDI 3.50 4.50
Fred 11/15/2004 W 0.30 0.20
Fred 11/15/2004 W 0.10 0.20
Fred 11/15/2004 W 2.30 3.00
Fred 11/16/2004 LD 2.00 1.50
Paul 11/16/2004 LD 3.00 3.00
Paul 11/16/2004 ST 0.40 0.00
Paul 11/16/2004 E 4.00 3.00
Paul 11/16/2004 E 3.00 4.50
and I want to create a report that looks like this
Beginning date/Ending date Don/Paul/Fred/Paul/etc.
(this has to be dynamic when we add or delete
Tech's)
CV SUM OF TOTAL ACTUAL HOURS BY CODE
E SUM OF TOTAL ACTUAL HOURS BY CODE
PDI ETC.
ST
LD
W
HD
DO
BIGGEST PROBLEMS I HAVE IS GETTING THE TECH NAMES IN THE LIST IN A
COLUMN HEADING AND THEN CALCULATING THE SUM OF EACH CODE BY TECH IN
THE TABLES CELLS.
APPRECIATE ANY HELP I CAN GET
Reply With Quote
JE McGimpsey
View Public Profile
Find all posts by JE McGimpsey