I am using the line below to determine characteristic qualities of a set of values. How is this being read? I would like for the test to meet the first part of the test and at least one of the second characteristics defined by the OR statement and contained within parenthesis.
If Cells(kk, 3)...
Hi,
I need to filter a dynamic range of data whose number of columns keep changing based on the first column. The table is such:
Characteristics. Date1. Date2. Date3. Date4. ........
The columns have different data of different date and its dynamic based on the number of files...
Hello,
I have a problem statement. I need to filter data based on specific characteristics. So characteristics is in column 1 ( A24:A258). I need a method and code to add a separate activex control so as to filter the data based on these characteristics.
The problem I am getting is I have 3...
i couldnt find this meaning in google search,i want to know about this special characteristics for?
1)*#*
2)"*"
3)"@"
4)"???.???"
5)xlWhole, , , , False, True
6)"[!0-9A-Za-z]"
7)"."
8)Cells(@,1)
9)""
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.