Using the Whole Enchilada

[dicentra63 <dicentra@xmission.com>]

--- In HP4GU-FAQ at yahoogroups.com, Catherine Coleman <catherine at c...>
wrote:
> In message <008001c2db36$79c3fec0$723b3244 at a...>, 
> elfundeb <elfundeb at c...> writes
> >Hi all --
> >
> >I wonder if we could get instructions on doing filters on the Whole
> >Enchilada Catalogue.  I tried to do a sort, but it quit as soon as
it reached
> >a painted line, and I couldn't get the filter to work at all.  
> >
> 
> I think the problem with my catalogue, and Eloise's is that we used 
> Works instead of Excel.  I did think that they were completely 
> compatible though, both being Microsoft applications (and Works really 
> just being a truncated version of Excel).  Certainly, I have imported 
> .xls files into Works without any problem.
> 

If you're using the whole_enchilada.zip that I uploaded, there should
be no colored lines.  I went through and deleted them all. 

When compiling the thing, I ended up having to export it to text-only,
then import it as a new file because there was something wrong with it
-- it wouldn't let me sort even two consecutive rows.  So whatever
weird stuff might have been in the files due to different versions of
Excel, those were purged when I exported to text (tab-separated).

To look for stuff, first you position your cursor somewhere in the
first row of terms (just one cell), then hit the sort button.  Or, you
select the whole table, then select "Data | Sort" from the main menu
and configure it to sort by the B column.  Now everything is sorted
alphabetically by the terms in the first term column.

You can either scroll down until you find the desired term, or you can
hit CTRL + F to call up the "Find" dialog box.

You'll need to do this three times, once for each column.

BTW, the whole_enchilada.zip that I uploaded has two copies of all the
35000s.  I'll upload a corrected version in a second, here. 

--Dicey