Forum

Anders Sehlstedt
Anders Sehlstedt
@sehlsan
Noble Member
Joined: Dec 7, 2016
Last seen: Mar 8, 2026
Topics: 8 / Replies: 978
Reply
RE: Contain "?"

Hello, What FIND function gives you is the character position number if it finds what is looked for, else a #VALUE! error. By wrapping this with th...

7 years ago
Reply
7 years ago
Forum
Reply
RE: Using conditional formatting with IF

Hello Alan, Just providing a link to some more information about conditional formatting using formulas.

7 years ago
Reply
RE: Google Blocked Me

Hello, What kind of issue do you have when running the code? Is it what Philip writes in his article? "The big drawback of using Wait or Sleep, ...

7 years ago
Forum
Reply
RE: Google Blocked Me

Hello, I do recommend you to check out the blog section, there are great articles to be found there.

7 years ago
Forum
Reply
RE: Extract data from website to Excel

Hello, Have you tried using Power Query? Here is a good article how to use VBA to get data from web pages.

7 years ago
Forum
Reply
RE: auto number with duplicate -first-last bench

Hello, I am not clear with what you want help with, I don't see any formulas in your attached file.

7 years ago
Reply
RE: How can I get the most up to date version of Excel?

Hello, That is correct, as you have ProPlus version you have an enterprise product, so the setting for Office Insider is available for the administ...

7 years ago
Reply
RE: Enrollment Data

Hello Stephen, Great that you have it all working. I am just glad that I could give a helping hand.

7 years ago
Reply
RE: How can I get the most up to date version of Excel?

Hello, The Office suite is in its core American English, same with Windows 10. The different languages are just added/installed language packs. So ...

7 years ago
Reply
RE: How can I get the most up to date version of Excel?

Hello Anne, For getting latest features you need to be on the monthly update channel. More about the differences here.

7 years ago
Reply
RE: Enrollment Data

Hello Stephen, Nothing wrong with the formulas, but the data needs to be cleaned. I just trimmed the ENTRYYEAR and STUDENTTYPE data and after th...

7 years ago
Reply
RE: How do you Exclude 0

Hello Paul, When you have two or more criterias you have to use AVERAGEIFS function. The syntax is =AVERAGEIFS(average_range, criteria_range1, c...

7 years ago
Reply
RE: 16 table in to 1

Hello Jay, I an not sure that I have grasped fully what it is you want to do, for example, what is to be matched? Any way, from what I understan...

7 years ago
Reply
RE: How do you Exclude 0

Hello, You have to add ”<>0” as a criteria.

7 years ago
Page 49 / 66
0