functions similar to filter

[llusionism]

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.

 

[Stefi]

Autofilter has a Custom filter feature, including condition "Contains"
certain strings.

Regards,
Stefi

„llusionism†ezt írta: