LinkBack URL
About LinkBacks
hello
i m using array function in my below formula...but there is an debug error
what going wrong
Please Login or Register to view this content.
Filter data using Array Function
hello
i m using array function in my below formula...but there is an debug error
what going wrong
Please Login or Register to view this content.
Try instead
Formula:
Please Login or Register to view this content.
Not sure why you are specifying two criteria when the C8 range is the same.
Last edited by Richard Buttrey; 04-22-2014 at 11:57 AM.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hello haroon2015,
The AutoFilter method accepts a maximum of 2 criteria. It does not use arrays. Besides, your logic for Criteria1 is a tautology. You need only use ">=".
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hello Both Mod
i m using only ">=" but blank cells is not showing
...but what does C8 contain..?
c8 contain words...
if i want to filter "Ahsaan G" then
i type Ahsaan G in C8 then run the macro,,
So are you saying you want to show blank cells as well as whatever is in C8?Originally Posted by haroon2015
Hello Both Mod
i m using only ">=" but blank cells is not showing
Yes mod
i want to show blank cells as well as whatever is in c8
Hi,
In that case
Please Login or Register to view this content.
Hello Mod
Thanx a lot very very much ,,,,
works perfect
will add u +1 reputation
will u plz look at this thread
http://www.excelforum.com/excel-prog...ilter-dat.html
thanx once again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks