Follow via:
RSS
Email Alert
Question
-1 Votes
+ -

Excel 2003 Special Filter

I have a spreadsheet containing data on radio signals. There are 13 columns and over 1500 rows and each row contains a unique set of data. I need a macro which would be accesible from a rt mouse click. The macro should enable me to select a cell in any column (say d1234) and with a rt mouse click, display all rows of data which include identical data to that in d1234. So, for example if a cell in Column C contained "Radio Monaco" I need to see all rows of data where Column C contained "Radio Monaco"
A further click of the mouse would cancel the filter. Hope this is enough to explain what I need.
Tags: software
24th Mar 2011

Answers (1)

1 Vote
+ -
Utility
Check out ASAP utility which gives default provision for highlighting duplicate/identical records.
http://www.asap-utilities.com/
14th Apr 2011

Replies

Many thanks, this could be the answer to several problems I have with Excel. Thnaks a lot
Peter
peterwillmo 14th Apr 2011
Answer the question
Formatting +
BB Codes - Note: HTML is not supported in forums
  • [b] Bold [/b]
  • [i] Italic [/i]
  • [u] Underline [/u]
  • [s] Strikethrough [/s]
  • [q] "Quote" [/q]
  • [ol][*] 1. Ordered List [/ol]
  • [ul][*] · Unordered List [/ul]
  • [pre] Preformat [/pre]
  • [quote] "Blockquote" [/quote]

Join the TechRepublic Community and join the conversation! Signing-up is free and quick, Do it now, we want to hear your opinion.