excel formula help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi all, i have two questions (1) ineed help on a formula to count names in a
filtered list. (2) is it there a way to use ron's easyfilter when the page is
protected. any help will be appreciated.
thx wynb
 
1) =SUBTOTAL(3,B2:B20) gives the number of items in a filtered list.

2) I will leave that to Ron.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Similar Threads

excel personal sheet 1
problem with a formula 1
links to a second sheet 2
check numbers in a list 3
can you please help 1
EXCEL - IF(IFERROR(VLOOKUP question 0
LOOKUP FORMULA 2
counting blank cells within two columns 2

Back
Top