Help; data filter
Hi
my data is a 12x3 table,
VBA Noob yazdi:
Hi,
It assumes the data is a 9 x 4 Table and data starts in A1
CHOOSE(ROW(A2),0,2,11,20,29))
When you drag down Row(A2) changes to Row(A3) which is 3. This is then
used in the choose function to return 11 and the indirect changes it to
A11
VBA Noob
Ahmad wrote:
Dear VBA Noob;
I have try your function there are some wrongs in the second and theerd
rows, while the first row is ok
VBA Noob yazdi:
Hi,
Try
=OFFSET(INDIRECT("A"&CHOOSE(ROW(A2),0,2,11,20,29)) ,COLUMN(A:A)-1,)
VBA Noob
Ahmad wrote:
Dear all; I need to filter my data in that cell under data (one cell)
to twelve cell like as results cells
see my
example again
data results
261.0 261.0 231.7 277.3 308.3 306.0 322.0 204.5 263.0 302.9 237.4 249.3 219.3
231.7 214.6 240.7 246.8 206.5 253.0 257.9 274.0 259.0 260.2 258.9 310.3 267.4
277.3 264.4 254.6 329.2 296.0 341.3 250.4 319.8 221.6 286.2 297.1 327.6 267.5
308.3
306.0
322.0
204.5
263.0
302.9
237.4
249.3
219.3
214.6
240.7
246.8
206.5
253.0
257.9
274.0
259.0
260.2
258.9
310.3
267.4
264.4
254.6
329.2
296.0
341.3
250.4
319.8
221.6
286.2
297.1
327.6
267.5
|