+ Reply to Thread
Results 1 to 3 of 3

Help me make this command able to see numbers with dashes and not break.

  1. 07-17-2017, 02:15 PM #1
    beeker223
    beeker223 is offline
    Registered User
    Join Date
    07-14-2017
    Location
    Miami, Florida
    MS-Off Ver
    2007
    Posts
    8

    Cool Help me make this command able to see numbers with dashes and not break.

    Sample. The command breaks whenever I put a number in that has a dash.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-17-2017, 02:27 PM #2
    Jonmo1
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Help me make this command able to see numbers with dashes and not break.

    I would concentrating on separating the data in the Warehouse so that the ID and SumValue are in seperate columns.
    Then simple sumif formula works fine.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 07-17-2017, 02:54 PM #3
    leelnich
    leelnich is offline
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Help me make this command able to see numbers with dashes and not break.

    Hi all- @beeker223, change you formula so the look-up works with text instead of numbers:
    Original formula
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    becomes
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee
    Last edited by leelnich; 07-18-2017 at 02:02 AM.
    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. Letters Numbers and dashes
    By Parts Peddler in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-02-2014, 03:25 PM
  2. Reformat SSN to add dashes between numbers
    By wheatgrass in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-17-2013, 04:39 PM
  3. Add Dashes Between Numbers
    By chrisnat in forum Excel General
    Replies: 2
    Last Post: 04-01-2011, 11:06 AM
  4. Column of numbers that have dashes, how do I get rid of the dashes
    By oddcarout in forum Excel General
    Replies: 1
    Last Post: 05-14-2008, 07:55 PM
  5. Adding numbers with dashes
    By boyaco in forum Excel General
    Replies: 5
    Last Post: 02-19-2008, 01:00 PM
  6. Removing dashes from numbers
    By sigdig in forum Excel General
    Replies: 1
    Last Post: 10-23-2006, 10:59 PM
  7. Convert phone numbers with dashes in them to just numbers
    By J H in forum Excel General
    Replies: 2
    Last Post: 06-23-2006, 02:00 PM
  8. [SOLVED] Convert phone numbers with dashes in them to just numbers
    By J H in forum Excel General
    Replies: 2
    Last Post: 06-22-2006, 09:45 PM

Tags for this Thread

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