On 07/21/2014 08:39 AM, Tanstaafl wrote:
> was working on a 'wtf?'
Is that the new MS Office format? ;-)
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.
On 7/20/2014 1:54 PM, Florian Reisinger wrote:
Without trying, so not exact names
If(month(today()) < 8; sum(jan-jul);sum(aug-dez))
Hope this helps...
Hmmm... yeah, I guess I could create a named range for each possible
period - jan, jan-feb, jan-mar, etc - then do it ion a nested IF, but
I'
Thanks for the reply Paul,
I was working on a 'wtf?' reply as to why the list converted my HTML
email (had the values in a simple table) to plain text.
Also, I have no clue what happened with the 'DUM' in the subject - I
didn't type that... weirdness...
Blindly converting HTML to plain text
At 13:47 20/07/2014 -0400, Charles Marcus wrote:
... we keep sales for Sales by month, with the Sales Rep in a Row
and each month in a column... So something like this:
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD
Sales Rep
Rep 1
Rep 2
What I'm trying to do is com
On Sun, 20 Jul 2014 13:47:35 -0400
Tanstaafl wrote:
> Hi all,
>
> Ok, we keep sales for Sales by month, with the Sales Rep in a Row and
> each month in a column...
Sounds simple, but...
> So something like this:
This didn't come through properly (my email client does text by
default, and did
Hi,
Without trying, so not exact names
If(month(today()) < 8; sum(jan-jul);sum(aug-dez))
Hope this helps...
Liebe Grüße, / Yours,
Florian Reisinger
> Am 20.07.2014 um 19:47 schrieb Tanstaafl :
>
> Hi all,
>
> Ok, just one more thing and I'll have this spreadsheet done for my boss...
>
> Ok, we
Hi all,
Ok, just one more thing and I'll have this spreadsheet done for my boss...
Ok, we keep sales for Sales by month, with the Sales Rep in a Row and
each month in a column...
So something like this:
Jan
Feb
Mar
Apr
May
Jun
Jul