Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to pick every third cell?
Hi, I have a spreadsheet with a column in which I keep dates. The date appers in every third cell of this column and the other two cells are blank. I have the another sheet in this workbook in which I want those dates to appear in the column in consecutive order. I'm using cell reference comand right now but have to do it manually every time I have a new entries. So in the other sheet there is a column with cells having references to every third cell in the first sheet. I trided to high-lite the multiple bunches of cells and drag-copy it down - but it's not working. Any ideas??? Thanks, jakar -- jakar ------------------------------------------------------------------------ jakar's Profile: http://www.excelforum.com/member.php...o&userid=28844 View this thread: http://www.excelforum.com/showthread...hreadid=485957 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Copy the value of a cell to any given cell | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) | |||
Create a pick list to use to go to a text cell in Excel | Excel Worksheet Functions | |||
How do I make a drop down list to pick from for a cell in Excel | Excel Discussion (Misc queries) | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |