#1
|
|||
|
|||
Excel is killing me .. help!
hi.. excel s driving me nuts .. I wanna know how do it get values from a row to a column .. but the condition is that the each cell in a row are 4 cells apart while all cells in the column lie one after the other... for example: i want the values of A1, F1, K1, P1, U1, Z1 to columns A10,A11,A12,A13.... Anyone one know this, kindly help me.. Thank you |
#2
|
|||
|
|||
in A10, put this formula: =INDIRECT("A"&COLUMN($A$1))
Then, in A11: =INDIRECT("R1C"&(1+COUNT($A$10:A10)*5);FALSE) You can copy this down, as needed... Pay attention to your regional settings, you might need to change the separators in formula from ";" to "," |
#3
|
|||
|
|||
Thank you Catalin. B
Thats really nice of you |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2007 custom ribbon not showing in Excel 2010 | Paulzak | Excel | 2 | 02-17-2012 06:35 PM |
saving data in excel 2010 from excel 2003 | johnkcalg | Excel | 1 | 02-06-2012 07:33 PM |
Excel Hyperlinks crash Excel programme | martinlest | Excel | 8 | 01-26-2011 04:23 AM |
Opening multiple Excel files within the same Excel window. | lost9471 | Excel | 2 | 05-01-2010 01:57 PM |
Time is killing me!!! | rhale1122 | Excel | 2 | 12-02-2008 09:39 PM |