View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cmartin2459 cmartin2459 is offline
external usenet poster
 
Posts: 1
Default Automatically insert a date value based on the value from another cell


I have a spread sheet that has the following info:
Column A = Date, Columns B:D = times associated with shifts, i.e. B4 =
11 p.m. - 7 a.m.; C4 = 7 a.m. - 3 p.m.; D4 = 3 p.m. - 11 a.m. So
A5:A237 is a date, B5:D237 is a number based on the amount of water
used for each shift for that day.

For each day of the month and for each shift our operators input the
water demand during their shift.

In my spreadsheet cell C1 looks for the highest number in the range
B5:D462. That number becomes the value in C1. In cell C3 I want the
value to be the corresponding date from Column A. In other words, if
the highest number is 5 and it's in cell C6, then cell C1 = 5. A6 is
the corresponding date. I want C3 to equal A6.

I hope someone can understand my question and help me.

Thanks,
cj


--
cmartin2459
------------------------------------------------------------------------
cmartin2459's Profile: http://www.excelforum.com/member.php...o&userid=36530
View this thread: http://www.excelforum.com/showthread...hreadid=562866