• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Is it possible to create a 'test' for subject headings?

J

jlombard_

New Member
I’m trying to create a ‘test’ function within excel where I can enter subject headings from an email and then they’ll either be approved or rejected based on various criteria.

Here are the criteria;

- Text length between 18-25 characters

- Any words on a ‘bad’ list will flag the input (and the word if possible)

- Any words on a ‘good’ list will flag the input (and the word if possible)

- If the test is ‘approved’ the subject text would then follow through underneath or perhaps with a tick symbol?

- If the test was ‘rejected’ the subject text in the test highlights the box in red?

- I’d also want the cell with ‘text’ written in it to work also?

I’m awful with excel and it’s something I’m fairly new too, aside from the odd report it’s something I don’t have much familiarisation with, especially on this level. – so is this possible and if so does anyone fancy helping me build it?
 

Attachments

  • Subject Tester.xlsx
    17.6 KB · Views: 4
You'll likely need VBA for this, as your patterns overlap and can occur mid word (ex. "our" can occur within "your", etc).
 
I see, is this something that would be relatively pain-free to set up? or am I better off paying someone who understands it all lol
 
Last edited by a moderator:
jlombard_ said:
A what?
Click to expand...
Please read the forum rules extraction regarding cross-post :-

- Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.

- If you do cross-post, please put that in your post.

- Also if you have cross-posted and get an answer elsewhere, have the courtesy of posting the answer here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

It is advised you to put the link of the other forums in your original post.

Regards
Bosco
 
You must log in or register to reply here.
Back
Top