Walter Hildebrandt wrote:
Another condition is that both columns A and B are "compacted" at the top of
the columns.
If there are 10 words in either column A or B, then these words will appear
in rows 1 through 10.
If there are 10 words in column A and 100 words in column B, then column A
will have the words in rows 1 through 10 and column B will have the words in
rows 1 through 100
Hi,
Calc is named Calc since spreadsheets are calculators in the first
place.
Everything related to row sets belongs to databases. Spreadsheets are
quite insufficient surrogates for databases
SELECT "Words" FROM "List 1" UNION SELECT "Words" FROM "List 2"
gives unique words from both lists.
SELECT "List 1"."Words" FROM "List 1","List 2" WHERE "List
1"."Words"="List 2"."Words"
lists all words from first list having an equivalent in the second list.
SELECT-queries return a list derived from other lists in any order of
rows and columns.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
