Jump to content
Sign in to follow this  
sree161

Filter particular and take count of rows in that filter and remove filter later

Recommended Posts

Hi, 

i have an excel with data from A to MX.

I have to apply filter for all rows and filter N to specific term say "Yes" and take count of number of rows in that filter.
Later i have to remove that filter.

I am not sure where to add that "Yes" term in Excel_FilterSet ( $oWorkbook, $vWorksheet, $vRange, $iField [, $sCriteria1 = Default [, $iOperator = Default [, $sCriteria2 = Default]]] )

Any suggestions and ideas??

Share this post


Link to post
Share on other sites

I am not sure you are taking the right path if you intend just to get a count.  Filter is used normally to show a different view of the data, not to simplify count or other math operations.  Since we do not know exactly what you want to achieve, I would suggest this :

Local $aSelect = _Excel_RangeFind ($oWorkbook, "Yes", "I1:I99")
_ArrayDisplay ($aSelect)

 

Share this post


Link to post
Share on other sites

Hi ,

i have tried this,

$oRange = $oExcel.ActiveSheet.Range("A:A")
MsgBox(4096, "Excel Count Non-Blank Cells", $oExcel.WorksheetFunction.CountA($oRange))

Now i am getting total count of columns..but not filtered ones..

Will any edit in this help?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By AdmiralAlkex
      -></( Latest version is v2.3.3 )><-
      Have you ever felt that there is something missing in your life?? Then try this, I can guarantee 100% satisfaction!! (or else you get your money back!! )



      Some of the features:
      Disable (or enable ) DirectShow filters/codecs!
      Set buffers for ffdshow! (support for multiple presets!)
      Supports both x64 and x86 DShow/ffdshow!

      Try this and you will never go back to manually edit your registry again!!

      What do you think??


      Announcement post for 2.3.3 HERE <--- link

      As of 2.2.3 requires AutoItObject.au3 and oLinkedList.au3 from AutoItObject UDF <--- link
      As of 2.2.8 requires _RegFunc.au3 from Custom Registry Functions UDF <--- link
      As of 2.2.8 requires GUICtrlHyperLink.au3 from GUICtrlHyperLink UDF <--- link

      CodecControl 2.3.3.au3
      CC.ico
      CodecControl.ico

      Old versions (as well as new) can be downloaded with CodecControl Source Downloader.


      Old stuff for the historians:



      Later releases was by attachment:
      CodecControl1_3.au3 (6.09K)
      Number of downloads: 205
      CodecControl1_5.au3 (6.75K)
      Number of downloads: 241
      CodecControl 1.6 (was downloaded 42 times), BUGGY!! Use bugfix 1.7 instead.
      CodecControl1,7.au3 (13.21K)
      Number of downloads: 66
      CodecControl 2.1.1 (was downloaded 24 times), BUGGY!! Use bugfix 2.1.2 instead.
      CodecControl 2.1.2.au3 (13.68K)
      Number of downloads: 61
      CodecControl 2.1.5.au3 (16.46K)
      Number of downloads: 56
      CodecControl 2.2.3.au3 (16.76K)
      Number of downloads: 46
      CodecControl 2.2.5 (accidentally removed, was downloaded about 31 times)
      CodecControl 2.2.8.au3 (20.59K)
      Number of downloads: 58
      CodecControl 2.2.9.au3 (20.67K)
      Number of downloads: 43
      CodecControl 2.3.1 (accidentally removed, was downloaded about 50 times)

×
×
  • Create New...