Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-12-2018, 11:51 AM
14spar15 14spar15 is offline Windows XP Office 2000
Advanced Beginner
 
Join Date: Mar 2011
Posts: 32
14spar15 is on a distinguished road
Default Apply a formula or not depending on checkbox status


I have 50 - 200 URL’s that have a common type structure in column A. They each have a part number embedded in them (in the same fashion) that I want to stand alone. So for example in column B I may have a formula that deletes everything after the 3rd “/” from the string in column A. In column C I might take the string in column B and delete everything up to the last “)” and in this case it would leave me with just the actual part numbers. Sometimes I may have to go through one or 2 more formulas to get this original URL stripped down to just the part number. With each vendor I deal the formulas are always different depending on how they write there URL’s for their product line but all of their part numbers are embedded throughout their product line in the same fashion. With about 10 to 12 different formulas I can deal with just about any vendor’s different URL arrangements. So I don’t have to assemble a new Excel sheet with each vendor I would like to have a column for each of my 12 different formulas that are only used if I have a check box in row 2 checked. I tried hiding the columns that are not being used but each of the formulas reference back to a column and depending on which formulas/columns I’m using this is never consistent.
Reply With Quote
  #2  
Old 10-12-2018, 01:14 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 650
NoSparks will become famous soon enoughNoSparks will become famous soon enough
Default

Will you be posting a workbook indicative of all that ?

You want this done via formula not macro, right ?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Graph depending on weeks Whooops Excel 0 04-24-2018 11:32 PM
MS Outlook 2010 custom form - validation or formula to request user to check a checkbox emsa Outlook 0 09-08-2017 09:37 AM
Formula that will use different rates depending on the value entered zsteve Excel 4 08-11-2016 09:16 AM
Applying a formula from a checkbox in VBA jap7675 Excel Programming 7 12-02-2015 02:21 AM
Page in status bar is wrong; other status bar errors, as well amz Word 3 08-12-2015 02:27 PM


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


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