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 ...

Hello and welcome.
Please see below
27022014(1).xls

Maybe:

Please Login or Register  to view this content.

Regards, TMS

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

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.

Originally Posted by shadihamdan

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.

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

You are welcome.
Thank for rept