+ Reply to Thread
Results 1 to 14 of 14

Extracting some data values from excel worksheet

  1. #1
    Registered User
    Join Date
    02-28-2014
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    7

    Extracting some data values from excel worksheet

    I have an excel sheet with data results of samples analysis from ICP-MS
    the sheet includes the name of the sample and its results, I want to extract for each sample only the ( average value "x" , standard deviation "S" and " %RSD) and sort these values in columns , see the photo and the excel sheet attached ...
    what is the best way to do it and how ?
    I would be very greatfull for any help ...
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by shadihamdan; 02-28-2014 at 11:35 AM.

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Extracting some data values from excel worksheet

    Hello and welcome.
    Please see below
    27022014(1).xls
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,486

    Re: Extracting some data values from excel worksheet

    Maybe:

    Please Login or Register  to view this content.

    Regards, TMS
    Attached Files Attached Files
    Last edited by TMS; 02-28-2014 at 10:05 AM.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Registered User
    Join Date
    02-28-2014
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Extracting some data values from excel worksheet

    Thank you very much Robert , only one remark , the corresponded value actually should be taken from column D not C " the blue value" , can that be fixed ?

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,486

    Re: Extracting some data values from excel worksheet

    The code in post #3 takes the data from column D.

  6. #6
    Registered User
    Join Date
    02-28-2014
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Extracting some data values from excel worksheet

    TMShucks , You are just great ... thanks so much for your support

  7. #7
    Registered User
    Join Date
    02-28-2014
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Extracting some data values from excel worksheet

    Thank you very much

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,486

    Re: Extracting some data values from excel worksheet

    You're welcome.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

  9. #9
    Registered User
    Join Date
    02-28-2014
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Extracting some data values from excel worksheet

    just another question please !
    What if I have more data? more rows?

  10. #10
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Extracting some data values from excel worksheet

    Quote Originally Posted by shadihamdan View Post
    Thank you very much Robert , only one remark , the corresponded value actually should be taken from column D not C " the blue value" , can that be fixed ?
    Change this bit:

    INDEX($C$3:$C$425
    to
    INDEX($D$3:$D$425

    just another question please !
    What if I have more data? more rows?
    Extend all your ranges
    changet the 425 in first row
    to let say 1000,5000, 10000 etc.
    Drag down.
    Remeber: this will take lot of resources so above certain level of rows Trevor's macro will work more efficient.
    Last edited by RobertMika; 02-28-2014 at 11:06 AM.

  11. #11
    Registered User
    Join Date
    02-28-2014
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Extracting some data values from excel worksheet

    I did change it but it returns #VLUE! . this happened with any change in the statement !

  12. #12
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Extracting some data values from excel worksheet

    This is array formula
    You need to confirm Control+Shift+Enter not just Enter

  13. #13
    Registered User
    Join Date
    02-28-2014
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Extracting some data values from excel worksheet

    Ok! It works perfectly now .. Thank you again Robert

  14. #14
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Extracting some data values from excel worksheet

    You are welcome.
    Thank for rept

+ 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. Extracting rows of data to another worksheet based on a columns values
    By JohnnyBoyxxx in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-19-2013, 09:54 AM
  2. Replies: 3
    Last Post: 09-15-2013, 12:47 AM
  3. Replies: 0
    Last Post: 06-13-2012, 02:36 PM
  4. Excel 2007 - Extracting Data from Worksheet
    By timharding in forum Excel General
    Replies: 3
    Last Post: 09-22-2011, 06:23 AM
  5. Replies: 1
    Last Post: 01-17-2009, 06:34 AM

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