Microsoft Office Forums Apply a formula or not depending on checkbox status

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-12-2018, 11:51 AM
14spar15 14spar15 is offline Apply a formula or not depending on checkbox status Windows XP Apply a formula or not depending on checkbox status Office 2000
Advanced Beginner
Apply a formula or not depending on checkbox status
 
Join Date: Mar 2011
Posts: 41
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 Apply a formula or not depending on checkbox status Windows 7 64bit Apply a formula or not depending on checkbox status Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 706
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
Apply a formula or not depending on checkbox status 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
Apply a formula or not depending on checkbox status 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 05:59 PM.


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