| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting a Spreadsheet
Hi,
Am Tue, 17 Jun 2014 16:23:40 +0100 schrieb TimR1316: Title Description Blank Line Title Description Blank Line your data in Sheet1. then in Sheet2 A1: =INDEX(Sheet1!$A:$A,(ROWS($1:1)-1)*3+1) and in B1: =INDEX(Sheet1!$A:$A,(ROWS($1:1)-1)*3+2) Copy both formulas down till you get zeros Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formatting a spreadsheet help | Excel Worksheet Functions | |||
| Formatting a spreadsheet | Excel Discussion (Misc queries) | |||
| Formatting a Spreadsheet | Excel Discussion (Misc queries) | |||
| Spreadsheet formatting | Excel Discussion (Misc queries) | |||
| Formatting Spreadsheet | Excel Discussion (Misc queries) | |||
Threaded Mode
