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