Hi,
There are two ways to fix your problem:
1) Insert cells to place the new entries at the top, above cells A2-B2
, which will move down the reference of the last cell automatically.
The new cells must be in the range of the search array (if you insert
above A1, the search array reference will
On 10-4-2019 05:32, Tim Deaton wrote:
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
-
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