+ Reply to Thread
Results 1 to 6 of 6

Grab numeric values from column B to Column C

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Grab numeric values from column B to Column C

    Hello everyone
    I have two columns : In A I have sequence 1 - 2 - 3 - 4 - 5
    In Column B I have some numeric values ( 5 values) but in disorder)

    The required is a formula in column C to order the numbers in the same order of sequence ..
    I have put expected output
    Thanks advanced for help
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Grab numeric values from column B to Column C

    with a helpcolum to count the value and after that index match.

    See the green cells in the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,055

    Re: Grab numeric values from column B to Column C

    In C1, copied down (array entered):

    =IF(A1="","",INDEX($B$1:$B$100,SMALL(IF(ISBLANK($B$1:$B$100),"",ROW($B$1:$B$100)),COUNT($A$1:A1)-ROW($B$1:$B$100)+1)))
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Grab numeric values from column B to Column C

    Thank you very much for this great solution
    In fact the columns A & B are helper columns so if possible I need a formula without the need of helper column
    Regards

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Grab numeric values from column B to Column C

    Mr. Glenn
    I am so sorry I didn't see your post till I replied .. Your formula is great and exactly as i need
    Thank you very much

  6. #6
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Grab numeric values from column B to Column C

    I am so sorry for disturbing you Mr. Glenn
    I tried to apply the formula to my file .. but it doesn't give me exact results
    Column A is a helper and it contains a formula which results "" in some cells
    I tried editing the formula at this part
    Please Login or Register  to view this content.
    Tried to use Countif($A$1:A1,">0") but didn't return correct results too

    I have figured it out at last
    I replaced this part
    Please Login or Register  to view this content.
    with
    Please Login or Register  to view this content.
    Last edited by YasserKhalil; 10-03-2016 at 12:18 PM.

+ 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. make cells from column grab data from another column
    By bsapaka in forum Excel General
    Replies: 3
    Last Post: 01-03-2014, 04:15 PM
  2. Replies: 9
    Last Post: 11-18-2013, 07:40 AM
  3. [SOLVED] Grab Values in a Row based on filter -- Move to another spreadsheet -- Input column Nam
    By tsgallivan12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2013, 01:24 PM
  4. Compare a cell against a column and grab date from another column help?
    By whispers in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-23-2013, 01:25 AM
  5. [SOLVED] Grab the number of x in column a if found in column b under a specific name
    By HNoel33 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-03-2013, 01:56 PM
  6. [SOLVED] Help find MAX value in one column when numeric & alph-numeric values are present
    By KevinAB in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-01-2013, 11:29 AM
  7. The sum of the numeric values (VLOOKUP) of a column
    By alonsogar in forum Excel General
    Replies: 2
    Last Post: 01-31-2011, 03:21 AM
  8. Numeric reference of column. Data Grab ?
    By bigexcelfan in forum Excel General
    Replies: 3
    Last Post: 01-04-2006, 07:26 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