+ Reply to Thread
Results 1 to 5 of 5

Need help weeding out values from one cell to another

  1. 09-24-2016, 01:08 AM #1
    forestavekids
    forestavekids is offline
    Forum Contributor
    Join Date
    10-10-2015
    Location
    nj
    MS-Off Ver
    Office 2021
    Posts
    203

    Need help weeding out values from one cell to another

    Hi All,

    Made a big mistake with my inventory system..

    I was able to weed down all the sku's to a small sample size in column B, I will need to manually count the rest...

    In column A, the values I need moved into another column are listed "#value" in column B...

    IE. B6 has "#value", data from A6 is copied over to C6.

    Thanks for any help.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-24-2016, 01:22 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,969

    Re: Need help weeding out values from one cell to another

    something like this?
    =IF(ISERROR(B1),A1,"")
    copied down
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 09-24-2016, 01:24 AM #3
    forestavekids
    forestavekids is offline
    Forum Contributor
    Join Date
    10-10-2015
    Location
    nj
    MS-Off Ver
    Office 2021
    Posts
    203

    Re: Need help weeding out values from one cell to another

    Bingo, perfect. Thanks!!!
    Reply With QuoteRegister To Reply
  4. 09-24-2016, 01:50 AM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,969

    Re: Need help weeding out values from one cell to another

    Happy to help and thanks for the rep
    Reply With QuoteRegister To Reply
  5. 09-24-2016, 07:19 PM #5
    forestavekids
    forestavekids is offline
    Forum Contributor
    Join Date
    10-10-2015
    Location
    nj
    MS-Off Ver
    Office 2021
    Posts
    203

    Re: Need help weeding out values from one cell to another

    Hey I actually need a little more help with this.

    Along with weeding out '#value" I also need #n/a" weeded out as well.
    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. Weeding out rare numbers that skew an average or chart
    By Excel15 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2014, 06:00 PM
  2. Comma Separated Cell Values to Column of Unique Cell Values
    By Nuggetross in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-02-2014, 07:24 PM
  3. counting and weeding out duplicates
    By tudelson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-05-2013, 11:58 PM
  4. [SOLVED] Macro to loop through cell values in a column and format multiple cell values
    By Roop in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2012, 05:39 PM
  5. Changing macro from absolute cell values to relative cell values
    By dtanios in forum Excel General
    Replies: 1
    Last Post: 04-24-2012, 09:24 PM
  6. Data Weeding
    By Maow in forum Excel General
    Replies: 2
    Last Post: 06-07-2006, 04:20 AM
  7. weeding out overlapping items
    By Madenjl in forum Excel General
    Replies: 2
    Last Post: 02-14-2005, 05:37 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