Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index


Regina,

Thanks for the help, works like a charm.
And yes, I've now read the full help of SUBTOTAL() and I see all kind of uses :-)

Thanks again,

Rob.

On 9 okt. 2015, at 18:12, Regina Henschel wrote:

Hi Rob,

if you filter using an Autofilter, then you can use function
SUBTOTAL(4;<Range>)
instead of MAX. See help on SUBTOTAL.

Kind regards
Regina

Rob Jasper schrieb:
Hi,

I have a list of music pieces with dates they are, or will be handed out.
The format looks like:

26-10-15     11A     Stille Nacht
26-10-15     12A     Bethlehem
26-10-15     28      Ere zij God
24-08-15     242     Jacob's Ladder
26-10-15     265     See amid the winter's snow
M    275     Dicht bij het hart van God
24-08-15     363     Zie de Zon
5-01-15      369     Heer mijn hart zoekt u te vinden
24-03-14     396     Geef aan de wereld vrede
M    453     Dank zij U Heer
24-08-15     456     Sanctus
M    480     The Creation
24-08-15     493     The Exodus Song
26-10-15     498     For unto us a child is born
29-09-14     499     Dochter van Sion
29-09-14     500     Zingt een nieuw lied (naar Psalm 98)
5-01-15      502     Wees stil voor het aangezicht van God
5-01-15      503     'k heb gehoord van een stad
5-01-15      504     Van Oranje
14-12-15     509     Nooit meer nacht
9-02-15      510     Zing voor de Heer met hart en stem
7-09-15      511     Somebody bigger than you and I
14-12-15     512     Wilhelmus Cantate

The header line should contain "Per <hjighest date> in the binder".
I have now the formula =CONCATENATE("Per ",TEXT(MAX(B1:B9999),"dd-mm-yyyy"), "  in the binder") 
to create the header dynamically.
It now shows: Per 14-12-2015 in the binder

What I want is that if I filter 14 dec 2015 in the list, that then the header shows 26-10-2015. 
So the formula needs to be 'filter aware'.

How can I accomplish this?

Rob.






-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.