Filtering

  • Thread starter Thread starter Denny Leung
  • Start date Start date
D

Denny Leung

Dear all,

Q1: I've a long column of names which I want to filter
them by using the 1st or 1st and 2nd characters, such
as: "L" or "La" etc. Please kindly tell me how to do this.

Q2: I've a date in (A1) and in B1, I want to show another
date equals to (A1) + 2 years. What will the formula be in
B1? Please advise.

Thanks in advance.
 
Choose custom from the dropdown arrow.
Select begins with and type L (or La)

=date(year(a1)+2,month(a1),day(a))

is one way.
 
For your first question, with AutoFilter, select the Custom option. One of the choices is
"begins with". For the 2nd =DATE(YEAR(A1)+2,MONTH(A1),DAY(A1))
 
Back
Top