Hi,
I am trying to automate a calculation based on information from different columns and not quite sure if it's possible. This is what I am looking to do. Within the Reformat Data Sheet, first I am grouping by vial so for all the Areas within that group I am looking for the highest value, when found I take the RT value and use it as the denominator for the other RT values and put that new value in the RRT column. The files can be as large as 8000 rows with several groups so automating it will save lots of time. See example below:
Vial A,1 group - max value corresponds with an RT of 4.219
SampleName Vial Vial Id RT Area RRT
0-INITIAL A,1 1468 0.614 6769 0.146
0-INITIAL A,1 1468 0.668 1007 0.158
0-INITIAL A,1 1468 0.709 858 0.168
0-INITIAL A,1 1468 1.071 653 0.253851624
0-INITIAL A,1 1468 6.741 719 1.597771984
0-INITIAL A,1 1468 6.984 454 1.655368571
0-INITIAL A,1 1468 1.875 419 0.444418109
0-INITIAL A,1 1468 2.533 316 0.600379237
0-INITIAL A,1 1468 2.969 815 0.703721261
0-INITIAL A,1 1468 3.748 2631 0.888362171
0-INITIAL A,1 1468 4.219 1844241 1
0-INITIAL A,1 1468 6.433 1102 1.524768903
0-INITIAL A,1 1468 6.67 142 1.580943352
Is it possible, can someone please help me?
Thanks,
Michelle
Bookmarks