Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Discussion (Misc queries) > Help; data filter
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 23
Default Help; data filter
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

Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 26
Default Help; data filter
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

Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 23
Default Help; data filter
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

Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 26
Default Help; data filter
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

Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 23
Default 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

Reply With QuoteReply With Quote
  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 26
Default Help; data filter
Doh,

Try

=OFFSET(INDIRECT("A"&CHOOSE(ROW(A2),0,2,14,26)),CO LUMN(A:A)-1,)

VBA Noob


Ahmad wrote:
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

Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Hybrid Mode Hybrid Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
sorting 2 colums of numbers and incremening them down blk&wht Excel Discussion (Misc queries) 10 October 9th 06 10:12 PM
Vlookup to Return a Range of Data James Excel Discussion (Misc queries) 0 July 13th 06 09:44 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Pivot Table Data Filter Problem Pepikins Excel Discussion (Misc queries) 0 June 16th 05 09:12 AM


All times are GMT +1. The time now is 10:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement