| Instructions for finding subsets | |||
| go to find | |||
| select entire page | |||
| delete | |||
| go to data | |||
| select column A | |||
| copy | |||
| go to find | |||
| select column B | |||
| paste | |||
| go to A1 | |||
| control F and enter the search word | |||
| control R | |||
| repeat until all lines are done | |||
| go to data | |||
| select column C | |||
| copy | |||
| go to find | |||
| select column B | |||
| paste | |||
| control R | |||
| repeat until all lines are done | |||
| go to data | |||
| select columns A thru H | |||
| go to find | |||
| select column B | |||
| paste | |||
| select entire page | |||
| sort by column A | |||
| select rows that have one in column A | |||
| copy | |||
| go to misc | |||
| select new row at bottom | |||
| paste | |||
| sort by columns G, H, I | |||
| copy those rows in columns B thru D | |||
| paste to other application | |||