Still Not getting it!!

[SeaStar]

Issue Type MAR APR
Category A 13959 48% 10320 44%
Category B 4407 15% 3758 16%
Category C 2220 8% 2373 10%
Category D 195 1% 151 1%

above is the layout. I have over 20 months going along the page. The File is called Outcomes. I want to insert a sheet, with formulas that will only pick up the % figures. So if the first % figure is in column C3, the next is in F3 (as there is one blank column inbetween) and so on, i want to put these formulas in a blank sheet so that it picks up a % figure in each and every 3 column. Does this make sense.
Therefore my new sheet would have the % figures in column C4, C5, C6 with no blank columns.

 

[dave3009]

Hi Does this help

Lets say this sheet is called Outcomes and your new sheets is called Percentages

In percentage C3 you would type ='Outcomes'!C3
In Percentage D3 you would type = 'Outcomes'!F3

Etc etc etc for your 20 months. Then highlight the row and copy it down as far as you need

KR

Dave

 

[Andrew Poulsom]

Assuming your sample data in in A1:F5 on Sheet1, in C5 on another sheet enter:

=INDEX(Sheet1!$D2:$IV2,1,((COLUMN(C5)-COLUMN($C5))*2)+1)

and copy down and across.

 

[SeaStar]

It still doesnt work

Thank you all for my replies, my formula now works a treat.

Thanks,