Numbers only
Results 1 to 5 of 5

Thread: Numbers only
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2013
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Numbers only

    A B C D E
    Prod A 1234 yell thi
    Prod B 1234 owe rfd
    Prod C rew 2344 feft
    Prod D yth defg 3232

    Hi Guys,

    I have an issue with a formula I cannot resolve. As you can see from the table above,I have three rows of information, which I need to collate into 1. Essentially, one of the columns B,C or D has a price (number), the other two columns will not be a number but writing.

    Unforunately, my data is a bit different, so the price will always be in one of the 3 columns. Is there a formula I can use in column E to always extract the number?

    Thanks in advance!

  2. #2
    Board Regular Alan_P's Avatar
    Join Date
    Jul 2014
    Location
    Chester, UK
    Posts
    596
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Numbers only

    Hi Bal_Ocado,

    If the other 3 of the 4 columns are always text then you can just use Sum to extract the number?

    =SUM(A1:D1)

    Cheers,
    Alan.
    I'm using Excel 2010 in work, Excel 2013 at home. Unless otherwise stated I assume you are using the same version I am!

    - Posting guidelines, forum rules and terms of use - Try searching for your answer first, see how - Read the FAQs - List of BB codes

  3. #3
    Board Regular
    Join Date
    Dec 2009
    Location
    Yorkshire, UK
    Posts
    87
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Numbers only

    In E2: =IF(ISNUMBER(B2),B2,IF(ISNUMBER(C2),C2,D2))

  4. #4
    New Member
    Join Date
    Dec 2013
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Numbers only

    Hi Alan,

    This returns a 'VALUE' error for me?

    Thanks

  5. #5
    New Member
    Join Date
    Dec 2013
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Numbers only

    Brilliant! Thanks

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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