Filter in Excel

Posted on 2013-09-17
Medium Priority
Last Modified: 2014-01-24
1.  How can we set the filter for the alternative columns in Excel.

i.e, we need to set filter for Column A and Column D. The Filter should not be set column B and Column C.

2.   In a single cell how to have two hyperlink?
Question by:Murugesh Perumal
  • 3
LVL 16

Expert Comment

ID: 39499125
Hi schellaa:
1. Filters work on lists, and Excel recognizes only one list per sheet, so filtering two non-adjacent columns at the same time cannot be done.
2. Clicking on a cell hyperlink can follow only one hyperlink at a time, but you could make it change depending on the result of another cell using the HYPERLINK formula for example. Or a macro could be triggered when the cell is clicked using a Worksheet_FollowHyperlink

Perhaps if you could provide more detail on what outcomes you would like, then we can help you a bit more?

Author Comment

by:Murugesh Perumal
ID: 39501888
Hi Terry,

1.      Please refer attached Filter and Hyperlink.docx for the  table details. In that User need to filter only product type and Condition of the product. User should not filter on Product name and Image.
               Ex. User can filter the record which are all Product Type = Hardware and Condition = Good
              The user should not be allowed to filter on column Product name and Image (that is user cannot set filter as Product Name = mouse).

2.      For the Product name ‘Mouse’ we have three images  Mouse1.png, Mouse2.png, Mouse3.png  (with respective hyperlinks ) in a single cell. When the user wants to open the Mouse2.png image. how it can be done?

Can you give me a sample for having two or more hyperlinks in a single cell.

Accepted Solution

Murugesh Perumal earned 0 total points
ID: 39793491
my conclusions  given below .

1.  Auto filter can’t be set to the alternative columns .

2.      It is not possible to set two hyperlink in one cell . It can be achieved by workaround method.
Step for the workaround method :
     a.      Place two rectangle control into a cell.
     b.Background and boarder of the rectangle need to be made as transparent.
     c.      Assign hyperlink1 to rectangle 1 and hyperlink2  to the rectangle2 (we can assign hyperlink by using macro also).

Author Closing Comment

by:Murugesh Perumal
ID: 39806074
Auto filter can’t be set to the alternative columns  &  two hyperlink in one cell can be achieved by workaround method.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question