|
|
|
|
#2
02-05-2018, 09:59 AM
|
|||
|
|||
SMALL function with multiple IF statements (or alternative suggestion)
Ah yes sorry xor, I forgot to mention that.
There are some jobs with an 's' prefix which would also need to be ignored (as with the suffix hyphen and it's following numbers). We need to match only the part of the job numbers after any 's' prefix and before the hyphen. Thanks for your patience with the newbie  Regards, garymon9AX 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Multiple If statements,
|
Jamal NUMAN | Excel | 16 | 11-15-2022 11:59 PM |
| Need help with Indexing and Small Function in MS Excel 2010 | msp2sxs | Excel | 3 | 11-07-2017 03:46 PM |
| LARGE function with 3 IF statements??? | FloorManager | Excel | 3 | 08-23-2017 01:06 PM |
| Alternative for Multiple If Conditions? | zguan1 | Excel | 2 | 05-25-2017 09:12 AM |
| Multiple If statements | bremen22 | Excel | 2 | 10-15-2013 06:37 AM |
Windows 10 
Office 2016
Hybrid Mode