LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Looking up values with multiple criteria

I have 3 columns(department, date and wage hours) the department and the
dates repeat so that it states:

Maintenance 7/5/08 41
Warehousing 7/5/08 37
Maintenance 7/10/08 48
Warehousing 7/10/08 28

At the beginning of each new date it starts the departments over again. I
need to organize the info so that there the dates and departments are not
repeating. The end product needs the dates across the top row and the four
different departments on the left column with the wages fulling the data
area.

Please help.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting Unique Values with Multiple Criteria Amber Excel Worksheet Functions 3 September 25th 07 02:52 PM
How to retrieve multiple values in multiple rows with one criteria bac Excel Discussion (Misc queries) 2 June 15th 07 08:57 PM
Calculating values from multiplesheets with multiple criteria I have no idea Excel Worksheet Functions 19 September 19th 06 05:38 PM
Count Unique Values with Multiple Criteria JohnV Excel Worksheet Functions 3 April 17th 06 06:00 PM
how do i count values based on multiple criteria sean Excel Worksheet Functions 2 January 7th 05 01:00 AM


All times are GMT +1. The time now is 06:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"