+ Reply to Thread
Results 1 to 11 of 11

Remove values from A to C that are crossed

  1. 02-20-2019, 09:57 AM #1
    Eduards
    Eduards is offline
    Forum Contributor
    Join Date
    11-01-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    280

    Remove values from A to C that are crossed

    I need to remove all strikethrough lines from A to C columns and leave anything outside of it.

    Also, if the whole row is not completely strikethroughed just the one value is, then still remove the whole row.

    i have attached a sample with examples
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-20-2019, 10:15 AM #2
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Remove values from A to C that are crossed

    Do we include col D in the check for strikethrough?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.
    Reply With QuoteRegister To Reply
  3. 02-20-2019, 10:16 AM #3
    Eduards
    Eduards is offline
    Forum Contributor
    Join Date
    11-01-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    280

    Re: Remove values from A to C that are crossed

    Hi Arkadi,

    No Just from A to C leave the D. Thank you!
    Reply With QuoteRegister To Reply
  4. 02-20-2019, 10:20 AM #4
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Remove values from A to C that are crossed

    1. What I mean is... if D is has strikethrough, do we clear the other columns?

    2. Also, is D always the last column or does that vary?

    3. Do we remove the Strikethrough from column D? or just the others.
    Reply With QuoteRegister To Reply
  5. 02-20-2019, 10:22 AM #5
    Eduards
    Eduards is offline
    Forum Contributor
    Join Date
    11-01-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    280

    Re: Remove values from A to C that are crossed

    Leave column D as it is even if its strikethrough, the data should remain there.

    But inside A to C anything has a strikethrough, delete the whole row. But deletion is limited inside A to C only, anything outside C column remians as it is.

    Thanks
    Reply With QuoteRegister To Reply
  6. 02-20-2019, 10:26 AM #6
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Remove values from A to C that are crossed

    As I understand it, we are only concerned with columns A-C for checking strikethrough font then, and only clear A-C if any of those cells have strikethrough...


    Give this a try:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 02-20-2019, 10:31 AM #7
    Eduards
    Eduards is offline
    Forum Contributor
    Join Date
    11-01-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    280

    Re: Remove values from A to C that are crossed

    Legend!!! Thats perfect, how would I change the area sorry? Instead of A to C. A to D and have data in the E column?
    Reply With QuoteRegister To Reply
  8. 02-20-2019, 11:00 AM #8
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Remove values from A to C that are crossed

    You would change the 3 to a 4 in the 2 lines where you see:

    Please Login or Register  to view this content.
    That would check the first 4 columns for strikethrough and then clear those 4 colums if found.
    Reply With QuoteRegister To Reply
  9. 02-20-2019, 11:10 AM #9
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Remove values from A to C that are crossed

    Thanks for the rep and marking the thread as solved
    Reply With QuoteRegister To Reply
  10. 02-20-2019, 12:51 PM #10
    Eduards
    Eduards is offline
    Forum Contributor
    Join Date
    11-01-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    280

    Re: Remove values from A to C that are crossed

    Could you explain whats going on in the code ? If not, thats ok
    Reply With QuoteRegister To Reply
  11. 02-20-2019, 03:14 PM #11
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Remove values from A to C that are crossed

    Hope this helps a bit:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Lookup crossed with auto sum
    By Morleyb in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-26-2016, 07:02 AM
  2. How to find local maximas/minimas in-between points that crossed 0 on the x-axis?
    By thewrestlingspider12 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-17-2016, 10:17 AM
  3. crossed two cells
    By berner3 in forum Excel General
    Replies: 2
    Last Post: 12-05-2015, 08:24 PM
  4. # of times midnight is crossed between date and time ranges
    By thuddleston11 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-12-2013, 08:03 AM
  5. Hlookup crossed reference with a vlookup help
    By gandyling in forum Excel General
    Replies: 3
    Last Post: 03-26-2012, 05:08 PM
  6. Yellow box with a crossed off F
    By Jazzy Max in forum Word Formatting & General
    Replies: 1
    Last Post: 09-06-2010, 01:04 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1