+ Reply to Thread
Results 1 to 4 of 4

Formula needed to help convert input data into desired output data format, thank you

  1. #1
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Formula needed to help convert input data into desired output data format, thank you

    I show in the attached file my input data. My desired output in Column B, which I need a formula to get too. However I cant think of a formula that would achieve this!
    In Column C I have shown the formula I have attempted, but as you can see it doesnt quite work.
    File attached. Thanks so much

    DaveHelp!!!.xlsx
    Last edited by davidx; 09-15-2015 at 04:33 AM.

  2. #2
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Re: Formula needed to help convert input data into desired output data format, thank you

    Is that better Fotis?

  3. #3
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Formula needed to help convert input data into desired output data format, thank you

    Yes it is. Thank you.

    Try in C2 and copy down

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by Fotis1991; 09-15-2015 at 05:46 AM.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  4. #4
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Re: Formula needed to help convert input data into desired output data format, thank you

    You're a genius, thank-you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Please help me with the attached problem. thank you.
    By lyung in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 10-30-2014, 01:47 PM
  2. VLOOKUP problem (attached file)
    By daang90 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-06-2014, 12:07 PM
  3. Replies: 2
    Last Post: 03-03-2012, 05:41 PM
  4. Maths Problem With Percentages
    By luvthavodka in forum Excel General
    Replies: 1
    Last Post: 08-14-2010, 08:58 PM
  5. Problem with Iterative Code, Excel Precision, or my maths??
    By Phil_V in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-19-2009, 09:59 AM
  6. VBA for the attached problem
    By vioravis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2009, 01:50 PM
  7. [SOLVED] Setting up a fiile/template to generate a new number when opened?
    By Ladybug726 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-05-2005, 03:50 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1