Previous Topic Next Topic

Reg: Excel query

Closed
jith - Dec 28, 2011 at 04:10 AM
 RayH - Dec 30, 2011 at 11:03 AM
Respected Sir/Madam,

This is regarding a query that i have in MsEXCEL.

I would like to know is there any formula or script so that i can get the below output from the source.

Source:
--------------
Coloumn1 Coloumn2 Coloumn3 Coloumn4 Coloumn5 Coloumn6
AAAA 12/5/2011 zzz 1 hh rw
BBBB 12/1/2011 yyy 2 tt fg
CCCC 12/3/2011 xxx 3 rr hj
DDDD 11/29/2011 zzz 4 ss kl
EEEE 12/6/2011 yyy 5 ff as
FFFF 11/25/2011 yyy 6 ee we
GGGG 12/3/2011 xxx 7 yy rt
HHHH 12/4/2011 yyy 8 jj uio
IIII 12/1/2011 xxx 9 hh vb
JJJJ 11/30/2011 zzz 10 kk df

Output:
--------------
Coloumn1 Coloumn2 Coloumn3 Coloumn4 Coloumn5 Coloumn6
AAAA 12/5/2011 zzz 1 hh rw
BBBB 12/1/2011 yyy 2 tt fg
CCCC 12/3/2011 xxx 3 rr hj
EEEE 12/6/2011 yyy 5 ff as
GGGG 12/3/2011 xxx 7 yy rt
HHHH 12/4/2011 yyy 8 jj uio
IIII 12/1/2011 xxx 9 hh vb

Kindly provide the necessary solution, if any. Expecting a positive reply.
Thanks in advance.

Yours Faithfully,
Ajith


1 reply

Answer 1 / 1
RayH
Dec 30, 2011 at 11:03 AM
It would help if you told us why DDDD, FFFF and JJJJ will be excluded from the output. Is it because of their dates being in November and not December?
What is the source? Could the filter be applied at input?
Can you just not filter the data and exclude records based on the chosen criteria?
Will this criteria change on a regular basis?
I'm sorry but there are more questions than answers.
Expecting a positive reply.
0