Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-05-2018, 09:44 AM
xor xor is offline SMALL function with multiple IF statements (or alternative suggestion) Windows 10 SMALL function with multiple IF statements (or alternative suggestion) Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,103
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default


What about Job number in A8?
Reply With Quote
  #2  
Old 02-05-2018, 09:59 AM
garymon9AX garymon9AX is offline SMALL function with multiple IF statements (or alternative suggestion) Windows 10 SMALL function with multiple IF statements (or alternative suggestion) Office 2013
Novice
SMALL function with multiple IF statements (or alternative suggestion)
 
Join Date: Feb 2018
Posts: 9
garymon9AX is on a distinguished road
Default 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
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
SMALL function with multiple IF statements (or alternative suggestion) 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft