excel formula help

W

WYN

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
 
B

Bob Phillips

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