Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Gary''s wrote on Thu, 14 Jun 2007 18:49:00 -0700:
Gs In B1 thru B10: Gs In A1 put a 1 Gs In A2 put: Gs =IF(COUNTIF($B$1:B2,B2)1,"",ROW()) and copy down to see: Another quick and dirty approach is to put sequential integers in col A and =rand() in column B, sort B (extended) and then have C1= A1 + some date etc. Format the resulting column as date. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.verizon.not |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Charting count of unique dates in a list | Charts and Charting in Excel | |||
create a filled in calendar from list of dates and notes | Excel Discussion (Misc queries) | |||
Count unique values and create list based on these values | Excel Worksheet Functions | |||
create list of unique values from a column with repeated values? | Excel Worksheet Functions |