Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
max date
i have in column A:A a various list of dates in the following format 12/08/2006 Saturday I want to create a list of the available months in column A:A to use in a drop down menu. This is a general format so ive not been ale to go for the max numeric value although i can do a datevalue function(leftx,5)) to get the value and then find the max date but this causes the workbook to slow as i would have to run this against 9 imported worksheets. Also the rows used vary on different imported time ranges. As the dates are in acending order and the last date is always a given number of rows from the end i wondered if there is a way to find out how many rows had been used. There are also blank rows in between so ive not been able to go down this road. -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=566515 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
max date
unfortunatly i cant do a max(A:A) function because the general format is text not numeric. -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=566515 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
max date
really need some help on this guys/girl -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=566515 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
max date
send me the part of the workbook to my private email below
-- Don Guillett SalesAid Software "ceemo" wrote in message ... really need some help on this guys/girl -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=566515 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
max date
ive manged to get this sorted now but many thanks to all that have assisted -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=566515 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
Calculate 1st of month date from existing date. | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Another Date issue. | Excel Worksheet Functions |