Reg: Excel query [Closed]

Question

Reg: Excel query [Closed]

Report

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

Reg: Excel query
Excel Query Urgent Please. ✓ - Forum - Excel
Excel - Search & Display query - How-To - Excel
Excel power query change date format - How-To - Excel
Excel name match query ✓ - Forum - Excel
Transfer data from one excel worksheet to another automatically - How-To - Excel

1 reply

Ask a question

RayH · Answer 1 · 2011-12-30T11:03:58-0500

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.

Reg: Excel query [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!