110 reputation
211
bio website
location
age
visits member for 1 year, 5 months
seen 2 days ago

Sep
1
awarded  Notable Question
Jul
15
awarded  Notable Question
Jul
15
awarded  Popular Question
Jun
7
comment remove lines with duplicate words
You need to provide more details. Do you only need the first entry for each word1, word2...?
May
21
comment Block MAC address from accessing hosted wifi on laptop
I need to be able to tell them "Hey I'm using it, Jack can too and so can Jill...must be some problem with your phone! Sorry!!" :-)
May
21
comment Block MAC address from accessing hosted wifi on laptop
Again, this invites the question "Hey how are you using it?"
May
21
comment Block MAC address from accessing hosted wifi on laptop
Like I said, I'm open to suggestions..are there any other applications that already provide this feature?
May
21
comment Block MAC address from accessing hosted wifi on laptop
They'll simply ask for the new password once they see that I am using it! Will also invite the ire of some...exactly the thing I'm trying to avoid!
May
21
asked Block MAC address from accessing hosted wifi on laptop
Apr
30
awarded  Popular Question
Dec
11
awarded  Popular Question
Dec
2
accepted Excel-Count number of visible cells containing certain string
Dec
2
comment Excel-Count number of visible cells containing certain string
This sounds good...I'll try it out and see if it helps...thanks a lot for your help!
Dec
2
comment Excel-Count number of visible cells containing certain string
~2000 rows...I will consider the helper column. btw can you please explain dynamic named range.
Dec
2
revised Excel-Count number of visible cells containing certain string
edited title
Dec
2
comment Excel-Count number of visible cells containing certain string
Finally something that works...thank you sir! However as you mentioned...it does slow down the process considerably. And I have to reference the whole column as the last row number will always vary. Is there no way to speed things up?
Dec
2
revised Excel-Count number of visible cells containing certain string
added 55 characters in body
Dec
2
comment Excel-Count number of visible cells containing certain string
In this case...yes.
Dec
2
comment Excel-Count number of visible cells containing certain string
I did as you said..replaced (Sheet1!A:A="<Text to search>") with COUNTIF(A:A,"*apple*") but it's showing some garbage value.
Dec
2
comment Excel-Count number of visible cells containing certain string
What I need is the count of all visible cells containing the word "Apple". Note that this should exclude the hidden (filtered out) cells.