Filtering

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.
 
D

Dave Peterson

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.
 
M

Myrna Larson

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top