Excel Filter Data Help required

Excel Filter Data Help required

Post by KAUSHIK SAVL » Wed, 24 Aug 2011 01:20:05



Hi All,

I want hello in filtering data.

In attached file if I am applying in Column BE Filter, then I am choosing
Custom Option I am choosing Option does not equal to 0.00
then also i am getting data which shows amount as zero.

Please help urgently.

Regards.
Kaushik

  Claims Reconciliation Report.xls
690K Download
 
 
 

Excel Filter Data Help required

Post by XLS » Wed, 24 Aug 2011 01:30:32


because it's not a right condition  not equal to 0.00..........please try it
self ...just copy and paste spicel and check cell value..


> Hi All,

> I want hello in filtering data.

> In attached file if I am applying in Column BE Filter, then I am choosing
> Custom Option I am choosing Option does not equal to 0.00
> then also i am getting data which shows amount as zero.

> Please help urgently.

> Regards.
> Kaushik

> --

> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip

> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel

--
.........................

 
 
 

Excel Filter Data Help required

Post by XLS » Wed, 24 Aug 2011 01:41:55


please see attachment.....

please use =INT(then ur formula)


> because it's not a right condition  not equal to 0.00..........please try
> it self ...just copy and paste spicel and check cell value..


>> Hi All,

>> I want hello in filtering data.

>> In attached file if I am applying in Column BE Filter, then I am choosing
>> Custom Option I am choosing Option does not equal to 0.00
>>  then also i am getting data which shows amount as zero.

>> Please help urgently.

>> Regards.
>> Kaushik

>> --

>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip

>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel

> --
> .........................

--
.........................

  Copy of Claims Reconciliation Report-2.xls
690K Download
 
 
 

Excel Filter Data Help required

Post by rajan verm » Wed, 24 Aug 2011 01:51:43


see if it helps


> because it's not a right condition  not equal to 0.00..........please try
> it self ...just copy and paste spicel and check cell value..


>> Hi All,

>> I want hello in filtering data.

>> In attached file if I am applying in Column BE Filter, then I am choosing
>> Custom Option I am choosing Option does not equal to 0.00
>>  then also i am getting data which shows amount as zero.

>> Please help urgently.

>> Regards.
>> Kaushik

>> --

>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip

>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel

> --
> .........................

>  --

> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip

> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel

--
Regards
Rajan verma
+91 9158998701

  Claims Reconciliation Report.xls
733K Download
 
 
 

Excel Filter Data Help required

Post by XLS » Wed, 24 Aug 2011 01:56:18


use this...

=INT(ROUND((BC3-BD3),1)) then put filter


> see if it helps


>> because it's not a right condition  not equal to 0.00..........please try
>> it self ...just copy and paste spicel and check cell value..


>>> Hi All,

>>> I want hello in filtering data.

>>> In attached file if I am applying in Column BE Filter, then I am choosing
>>> Custom Option I am choosing Option does not equal to 0.00
>>>  then also i am getting data which shows amount as zero.

>>> Please help urgently.

>>> Regards.
>>> Kaushik

>>> --

>>> ----------------------------------------------------------------------------------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip

>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel

>> --
>> .........................

>>  --

>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip

>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel

> --
> Regards
> Rajan verma
> +91 9158998701

> --

> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip

> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel

--
.........................
 
 
 

Excel Filter Data Help required

Post by KAUSHIK SAVL » Wed, 24 Aug 2011 02:02:25


Thanks all for the help
Problem got resolved,

Regards,
Kaushik

 
 
 

1. Help please: Excel Data Filtering

 I am running Excel 5.0 on Windows 3.1.  The following is a simplified example
of
 a problem that I am having with extracting large lists of data.

 Using the commands Data, Filter, Advanced Filter, with :

 List range :   code
                        Packet
                        Packet red
                        Packet blue
                        Parcel

 Criteria range :        code
                        Packet

 the output that I get is :     code
                                        Packet
                                        Packet red
                                        Packet blue

 whereas what I want is :               code
                                        Packet

 Due to the large amount of data that I am processing and the frequency of
processing,
 I need a solution that doesn't require any changing of the base data.

 Can anyone help ?

2. Nynex Name Change

3. Excel Autofilter - Selecting Filtered Data

4. Problems with Watcom 10.6 Profiler

5. can't filter data using formula in advanced query in Excel

6. DBServer Editor generated FieldDescription

7. Excel: Data, Filter limit

8. OS/2 3.0 or OS/2 2.3????

9. Filtering Data in Excel

10. Filtering Data in Excel with EDATE function

11. Excel filtered data selection

12. excel function required to sum data on basis of criteria