Greetings,
The semicolon is used as my separator because my locale (Canadian
French) wants decimal commas.
In such a case, the list separator is changed to the semicolon to
remove the chance of conflict between a number (1 1/2 is written as 1,5
and not 1.5) and its position in the list. The same
On 2021-06-14 20:25, Thomas Blasejewicz wrote:
On 2021/06/13 2:55, Johnny Rosenberg wrote:
Another way to get around it is to name your range. Then your
formula could look something like =VLOOKUP(N76;ZipCodes;2;0)
Named ranges are absolute, always.
...
Defining the data range in the sheet "Zip
On 2021/06/13 2:55, Johnny Rosenberg wrote:
Another way to get around it is to name your range. Then your formula
could
look something like =VLOOKUP(N76;ZipCodes;2;0)
Named ranges are absolute, always.
Kind regards
Johnny Rosenberg
After futile efforts to make all those symbols work
Greetings,
The management of sheet names works in the same way as cell addresses.
Whenever you give a cell address (like A3), a copy/paste of the cell to
the next cell to the right will transform A3 into B3. To prevent that,
you place a "$" sign in front of the column address, like: $A3. You can
Den lör 12 juni 2021 kl 11:06 skrev Thomas Blasejewicz :
> Good evening
> I am probably, again!, too stupid to figure this out by myself,
> so I would be grateful for a hint.
>
> I have a file with something like 25 sheets listing the patients who
> visited my clinic before
> grouped by year. In
Good evening
I am probably, again!, too stupid to figure this out by myself,
so I would be grateful for a hint.
I have a file with something like 25 sheets listing the patients who
visited my clinic before
grouped by year. In one sheet I have all names (about 2,000).
To make my work easier I
