Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Hassan Alameh
 
Posts: n/a
Default Multiple minimums for the same column

Hello everybody,

I have a data that is like this:

Date Room Time In
1 1 7:30 am
1 1 10:30 am
1 2 8:30 am
1 2 1:10 pm
2 1 8:30 am
2 1 6:40 am
2 1 9:45 pm
etc

can i have the minimum of every date AND room?, i.e. have a set of
minimums for each room and each room?
I am interested in knowing the starting times throughouth a month for
all rooms.

regards

  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

Try a Pivot Table. Select the range of data and go to (in
XL2003) Data PivotTable and PivotChart Report.
Click "Next" twice and then click the "Layout" button.
From here, drag the date field to the ROW area, the room
field to the COLUMN area, and time in to the DATA area.
Double-click on the time in field and change it to Min.
Click OK and Finish. Note that you'll probably have to re-
format the time values as time, which you can do in the
Pivot Table or afterward. Also, I'm assuming you don't
have more than around 250 rooms. If so, put the room
field in the ROW area under date. To learn more about
Pivot Tables, see:

http://www.cpearson.com/excel/pivots.htm
http://it.fuqua.duke.edu/public/2001...leIntroduction
..pdf
http://edferrero.m6.net/Pivot20031.html

HTH
Jason
Atlanta, GA

-----Original Message-----
Hello everybody,

I have a data that is like this:

Date Room Time In
1 1 7:30 am
1 1 10:30 am
1 2 8:30 am
1 2 1:10 pm
2 1 8:30 am
2 1 6:40 am
2 1 9:45 pm
etc

can i have the minimum of every date AND room?, i.e.

have a set of
minimums for each room and each room?
I am interested in knowing the starting times

throughouth a month for
all rooms.

regards

.

  #3   Report Post  
LanceB
 
Posts: n/a
Default



=MIN(IF(($A$2:$A$8=A2)*($B$2:$B$8=B2)<0,$C$2:$C$8 ))
<ctrl<shift<enter 'array formula

Replace "=a2" and "=b2" with table of unique dates and rooms



"Hassan Alameh" wrote:

Hello everybody,

I have a data that is like this:

Date Room Time In
1 1 7:30 am
1 1 10:30 am
1 2 8:30 am
1 2 1:10 pm
2 1 8:30 am
2 1 6:40 am
2 1 9:45 pm
etc

can i have the minimum of every date AND room?, i.e. have a set of
minimums for each room and each room?
I am interested in knowing the starting times throughouth a month for
all rooms.

regards


  #4   Report Post  
Hassan Alameh
 
Posts: n/a
Default

Thank you alot, it worked,

also i managed to do it using subtotals + min for each subtotal..

regards..

Reply
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
splitting 1 column of data into multiple columns CiceroCF Setting up and Configuration of Excel 1 March 25th 05 02:50 AM
Formula to compare multiple rows values based on another column? Murph Excel Worksheet Functions 4 February 21st 05 03:44 AM
same cell from multiple sheets into one column Kel Excel Discussion (Misc queries) 0 February 18th 05 01:53 AM
merge data from multiple columns to single column triggerthehorse Excel Worksheet Functions 2 January 17th 05 08:19 PM
multiple criteria in one column Barb Excel Worksheet Functions 1 December 3rd 04 08:49 PM


All times are GMT +1. The time now is 01:04 PM.

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

About Us

"It's about Microsoft Excel"