Extracting Certain Conditions from a Master Worksheet.

[NucEng]

So I am a engineer running a test that usually has 150 conditions. Every odd condition is a "equilibrium condition" that is meant to stabilize the test rig between the even conditions. The even conditions are the actual results I want to look at and evaluate.


I've been trying to use a IF functions or Vlookup to extract the even conditions into a separate worksheet automatically. But I can't seem to figure out how to grab the information I want automatically.


So basically I want to take all of the corresponding values for condition 2 (the whole row of values) and put them in a separate worksheet. A repeat for every even condition, regardless of how long it is or how long the other conditions are. Sometimes the data points are taken at different times and so having a template that works regardless of the amount of data would be amazing.


I included a sample of what it looks like. ( very basic, usually the conditions are much longer.)


Thanks for your help!!! I've watched hours of tutorial videos and I can't seem find a easy way to do this automatically.

Condition	Data 1	Data2	Data 3	Data 4
1	0	0	0	0
1	0	0	0	0
2	100	24	54	654
2	104	29	40	677
3	0	0	0	0
3	0	0	0	0
4	150	40	90	700
4	155	42	88	721
5	0	0	0	0
5	0	0	0	0
6	210	80	200	900

<tbody>
</tbody>

 

[cyrilbrd]

So I am a engineer running a test that usually has 150 conditions. Every odd condition is a "equilibrium condition" that is meant to stabilize the test rig between the even conditions. The even conditions are the actual results I want to look at and evaluate.


I've been trying to use a IF functions or Vlookup to extract the even conditions into a separate worksheet automatically. But I can't seem to figure out how to grab the information I want automatically.


So basically I want to take all of the corresponding values for condition 2 (the whole row of values) and put them in a separate worksheet. A repeat for every even condition, regardless of how long it is or how long the other conditions are. Sometimes the data points are taken at different times and so having a template that works regardless of the amount of data would be amazing.


I included a sample of what it looks like. ( very basic, usually the conditions are much longer.)


Thanks for your help!!! I've watched hours of tutorial videos and I can't seem find a easy way to do this automatically.

Condition	Data 1	Data2	Data 3	Data 4
1	0	0	0	0
1	0	0	0	0
2	100	24	54	654
2	104	29	40	677
3	0	0	0	0
3	0	0	0	0
4	150	40	90	700
4	155	42	88	721
5	0	0	0	0
5	0	0	0	0
6	210	80	200	900

<tbody>
</tbody>

Hi, not sure if this will fit your query.
Given in Sheet1 cell A1:
<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { text-align: center; vertical-align: middle; white-space: normal; }</style>

Condition	Data 1	Data2	Data 3	Data 4
1	0	0	0	0
1	0	0	0	0
2	100	24	54	654
2	104	29	40	677
3	0	0	0	0
3	0	0	0	0
4	150	40	90	700
4	155	42	88	721
5	0	0	0	0
5	0	0	0	0
6	210	80	200	900

<colgroup><col style="width:65pt" span="5" width="65"> </colgroup><tbody>
</tbody>

In Sheet2 cell A1:
<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }</style>

condition	4
	150	40	90	700
	155	42	88	721

<colgroup><col style="width:65pt" span="5" width="65"> </colgroup><tbody>
</tbody>

Formula in B2 is =IFERROR(INDEX(Sheet1!B$2:B$12,SMALL(IF($B$1=Sheet1!$A$2:$A$12,ROW(Sheet1!$A$2:$A$12)-MIN(ROW(Sheet1!$A$2:$A$12))+1,""),ROW(Sheet1!A1))),"") Ctrl + Shift + Enter, not just enter on a PC or Command + Return on a MAC.
Copied right till Column E and down till needed.

Change value in B1 to fit your required condition.

Would that be close to what you need?

 

[NucEng]

Yes that's exactly what I was looking for. Thank you so much for your help! You've saved me hours of work.

 

[cyrilbrd]

Yes that's exactly what I was looking for. Thank you so much for your help! You've saved me hours of work.

Most welcome.
Glad it worked for you, and thanks for the feedback.