Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter in Microsoft Excel
Hi all,
I am using microsoft excel 2000. I need help in filtering the data. I have two columns as below Name Value a 1 a 2 a 3 a 7 b 1 b 3 b 9 b 4 c 1 c 3 c 7 I want to find all the distinct Name that doesn't have the given value. If we give value as 2. Then my output will be as follows. b c If we give value as 7. Then my output will be as follows. b How we will define this filter. Please help me.... Thanx for reading. Robin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I covert Microsoft Word file into Microsoft Excel one? | Excel Discussion (Misc queries) | |||
Advance Filter can be based on cell Color in Microsoft Excel | New Users to Excel | |||
Microsoft Visual Basic errors displaid when opening Microsoft Word 97 & Excel (7 | Setting up and Configuration of Excel | |||
Change individual cell heights/widths in Microsoft Excel 2000 like Microsoft Word | Excel Discussion (Misc queries) | |||
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) |