PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Discussion Filtering problem

Reply

Filtering problem

 
Thread Tools Rate Thread
Old 04-10-2005, 05:48 PM   #1
gaftalik
Guest
 
Posts: n/a
Default Filtering problem



Dear All,

Is it possible to return results from the same row but within differen
columns using a filter?

I appreciate your help

--
gaftali
-----------------------------------------------------------------------
gaftalik's Profile: http://www.excelforum.com/member.ph...info&userid=645
View this thread: http://www.excelforum.com/showthread.php?threadid=47302

  Reply With Quote
Old 05-10-2005, 12:07 AM   #2
Zack Barresse
Guest
 
Posts: n/a
Default Re: Filtering problem

Hi there,

Not sure what you mean there. Can you explain 'return results'?

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)


"gaftalik" <gaftalik.1wdxqa_1128441903.0178@excelforum-nospam.com> wrote in
message news:gaftalik.1wdxqa_1128441903.0178@excelforum-nospam.com...
>
> Dear All,
>
> Is it possible to return results from the same row but within different
> columns using a filter?
>
> I appreciate your help .
>
>
> --
> gaftalik
> ------------------------------------------------------------------------
> gaftalik's Profile:
> http://www.excelforum.com/member.ph...nfo&userid=6450
> View this thread: http://www.excelforum.com/showthrea...threadid=473027
>



  Reply With Quote
Old 05-10-2005, 01:00 PM   #3
gaftalik
Guest
 
Posts: n/a
Default Re: Filtering problem


What i meant is exactly related to this thread i posted few days ago :
http://www.excelforum.com/showthread.php?t=472560

In which i have attached a sheet

Thank you for your concern

--
gaftali
-----------------------------------------------------------------------
gaftalik's Profile: http://www.excelforum.com/member.ph...info&userid=645
View this thread: http://www.excelforum.com/showthread.php?threadid=47302

  Reply With Quote
Old 05-10-2005, 11:05 PM   #4
Zack Barresse
Guest
 
Posts: n/a
Default Re: Filtering problem

Not exactly sure what you want regarding a filter still though. From what I
understand, you can't use Filter in such a capacity (again, as I understand
your query). It looks like you want a DGET formula.

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)


"gaftalik" <gaftalik.1wfeia_1128510303.969@excelforum-nospam.com> wrote in
message news:gaftalik.1wfeia_1128510303.969@excelforum-nospam.com...
>
> What i meant is exactly related to this thread i posted few days ago :
> http://www.excelforum.com/showthread.php?t=472560
>
> In which i have attached a sheet
>
> Thank you for your concern.
>
>
> --
> gaftalik
> ------------------------------------------------------------------------
> gaftalik's Profile:
> http://www.excelforum.com/member.ph...nfo&userid=6450
> View this thread: http://www.excelforum.com/showthrea...threadid=473027
>



  Reply With Quote
Old 07-10-2005, 02:11 PM   #5
gaftalik
Guest
 
Posts: n/a
Default Re: Filtering problem


Hi,
I tried the dget formula but what about if i have more than a
transaction of the same date in the same column , it would return only
the first one ,while i need to list each date with its value separately
eventhough it is of same date .

Any suggestions?

Thank you .


--
gaftalik
------------------------------------------------------------------------
gaftalik's Profile: http://www.excelforum.com/member.ph...nfo&userid=6450
View this thread: http://www.excelforum.com/showthrea...threadid=473027

  Reply With Quote
Old 07-10-2005, 05:44 PM   #6
Zack Barresse
Guest
 
Posts: n/a
Default Re: Filtering problem

As I'm unfamiliar with your requirements, can you post what they are in
detail? Which cell(s) are the criterioin?

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)


"gaftalik" <gaftalik.1wj9eb_1128690302.2641@excelforum-nospam.com> wrote in
message news:gaftalik.1wj9eb_1128690302.2641@excelforum-nospam.com...
>
> Hi,
> I tried the dget formula but what about if i have more than a
> transaction of the same date in the same column , it would return only
> the first one ,while i need to list each date with its value separately
> eventhough it is of same date .
>
> Any suggestions?
>
> Thank you .
>
>
> --
> gaftalik
> ------------------------------------------------------------------------
> gaftalik's Profile:
> http://www.excelforum.com/member.ph...nfo&userid=6450
> View this thread: http://www.excelforum.com/showthrea...threadid=473027
>



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off