Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page SMALL function with multiple IF statements (or alternative suggestion)
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 02-05-2018, 08:53 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,101
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
Welcome!



Please press Go Advanced and upload your Excel file. It is cumbersome to enter all your data.
Reply With Quote
  #2  
Old 02-05-2018, 09:24 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)
Thanks xor.
My apologies.
I have now attached the spreadsheet.

Regards,
garymon9AX
Attached Files
File Type: xlsx Forum Query.xlsx (10.4 KB, 11 views)
Reply With Quote
  #3  
Old 02-05-2018, 09:55 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,101
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
Maybe like the attached. Be aware that it is array formulas.
Attached Files
File Type: xlsx Job_Number.xlsx (11.1 KB, 11 views)
Reply With Quote
Reply

« Previous Thread | Next Thread »


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:40 AM.

Contact Us - Privacy Statement - Top

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