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 somehow,
At 12:41 14/06/2021 +0200, Silvio Siefke wrote:
I have a table like:
11.04.2022;service a;250
12.04.2022;service a;250
13.04.2022;service a;250
14.04.2022;service b;250
15.04.2022;service b;250
12.05.2022;service b;250
13.05.2022;service c;250
14.05.2022;service c;250
17.05.2022;service d;250
18
On Mon, 14 Jun 2021 19:25:15 +0100
Brian Barker wrote:
> o I hope the date column contains genuine date values and not just
> pieces of text that look like dates.
had date format no text :)
> PS: You are too late to start those service B processes!
>
> I trust this helps.
It had worked out
Dear Brian,
On 2021/06/13 18:52, Brian Barker wrote:
At 15:01 13/06/2021 +0200, Hylton Conacher wrote:
A simple sum will do it i.e.: In cell Y4 insert [...]
=SUM(M18-$W$4)
I'm often puzzled by suggestions such as this. In what way do you think
that =SUM(Xm-Yn) differs from =Xm-Yn? The minus
To get the number of work days:
=workday(end date; -25)
https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_WORKDAY_function
And assuming each service gets a different date:
=workday(end date; -service B)
You can do a lookup table for each service.
--
Registered Linux User: #480675
Reg
On Mon, 14 Jun 2021 05:58:54 -0500
Wade Smart wrote:
> Question: does the meter per day have any relevance to the date?
> Is a working day equal to a business day? -> Mon - Fri only?
Yes the meters per day mean what is the daily output. Different
services with different daily output.
> > Servi
Question: does the meter per day have any relevance to the date?
Is a working day equal to a business day? -> Mon - Fri only?
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
On Mon, Jun 14, 2021 at 5:44 AM Silvio Siefke wrote:
>
> Hello,
>
> I have a t
Hello,
I have a table like:
11.04.2022;service a;250
12.04.2022;service a;250
13.04.2022;service a;250
14.04.2022;service b;250
15.04.2022;service b;250
12.05.2022;service b;250
13.05.2022;service c;250
14.05.2022;service c;250
17.05.2022;service d;250
18.05.2022;service d;250
Service a need 10