Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
would like to ask if there are any functions similar to filter? my data are as follows: c1 c2 r1 aa 1 r2 bb 2 r3 aa 3 r4 cc 4 and what i would like to achieve as my eventual result would be (eg: displaying records that contains "aa"). note: c1 stands for column 1 and r1 stands for row 1 etc.. c1 c2 r1 aa 1 r3 aa 3 thanks alot. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Max/min functions similar to SUMIF | Excel Discussion (Misc queries) | |||
Filter similar contact numbers. | Excel Worksheet Functions | |||
XL2003 FILTER FUNCTIONS VS. XL2007 FILTER FUNCTIONS | Excel Worksheet Functions | |||
Need help on filter or something similar | Excel Worksheet Functions | |||
How many similar functions can be put in one cell? | Excel Worksheet Functions |