Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 01-12-2019, 10:42 PM
gpktm gpktm is offline Windows 10 Office 2010 64bit
Join Date: Nov 2015
Posts: 4
gpktm is on a distinguished road
Default 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.
Attached Images
File Type: png 2019-01-12_14-14-05.png (38.6 KB, 29 views)
Reply With Quote
Old 01-13-2019, 10:40 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,381
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light

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),....
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
Old 01-13-2019, 03:17 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Join Date: May 2017
Posts: 446
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough

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).
Reply With Quote

Thread Tools
Display Modes

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

All times are GMT -7. The time now is 07:41 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft