#1
|
|||
|
|||
Matching a word with variants
Hi all
I need a function where Excel can identify variants of a word. In my example I want Excel to identify the word "1 & OVER" but I have variants of this word like "1 & OVER 1.5", "1 & OVER 2.5", "1 & OVER 3.5" and "1 & OVER 4.5" I tried to do it by using OR but I had no luck. |
#2
|
||||
|
||||
Please post a sample sheet (with expected results) so we can work on it. Pictures are useless. Thanks
You can try something like =IF(ISNUMBER(SEARCH("1 & OVER*",B20),....
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
The easiest way:
1. On separate sheet you need a table, where in left column are all possible values of Bet Types, and in second column value for bet group (in your worksheet values in range G2...?2); In 1st part of your formula, instead of IF()'s use COUNTIf() or COUNTIFS() to count rows in this table, where the value of 1st column equals with Bet Type in your original table, and the value in second column eguals with value in 2nd row of same column in your original table. And then you check the count - is it 0 (no matches were found) or >0 (at least one match was found). |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Document variants | Felicc | Word | 1 | 06-08-2018 04:48 PM |
Find paragraph matching an expression in Word and exporting to Excel spreadsheet | ballpoint | Word VBA | 23 | 03-23-2018 02:04 PM |
Matching last in a list | salse | Excel | 3 | 06-08-2016 08:08 PM |
powerpoint Variants | HelpReceiver | PowerPoint | 2 | 04-03-2015 11:55 AM |
refering to the msoFileDialogueOpen variants | smndnm | Word VBA | 23 | 07-20-2014 04:55 PM |