Steve & Brian, thanks for your replies.
Despite decades of working on spreadsheets, I can't say I expected it.
But then, it's the first time I'd found myself in this particular
scenario. But after your first sentence, I think I can see the logic -
even though I wish the spreadsheet was
I get the same on 6.07, it is what I would have expected from a sort
(the contents of the cells are moved about, the cell positions are not
changed). Seems logical to me but possibly not the desired outcome for
others.
If you use a lookup function on sheet 2 (include an index for each row
for
At 19:48 09/04/2019 -0400, Tim Deaton wrote:
I'm building a spreadsheet to serve as a food diary. On Sheet1 I
have a list of different foods, and on Sheet2 I have what foods I
ate at which day and meal. So far, I've only got a couple of days'
data posted. As I add more meals, I eat items that
I'm building a spreadsheet to serve as a food diary. On Sheet1 I have a
list of different foods, and on Sheet2 I have what foods I ate at which
day and meal. So far, I've only got a couple of days' data posted.
As I add more meals, I eat items that are not already on the Sheet1
list. So I