Re: [libreoffice-users] Question on wildcards

At 22:46 05/02/2017 +0100, Rob Jasper wrote:
> I am looking for a way to use MAXIFS over the equivalent ranges in 
> multiple tabs. Something like:
> =COUNTIF('2*'.E$2:E$200;C2)
> Explanation: For all ranges in tabs with name 2.* (2002, 2003, 2004, 
> etc.), range E2:E200 give me the number of occurrences of the value 
> define in C2. Is this at all possible?

A simple workaround is to assemble copies of the relevant ranges from 
multiple sheets on a single summary sheet. (After all, the value you 
are trying to derive definitely relates to the data generally, not to 
any specific year.) Then the function reference is simple. Instead of 
simply copying values, you will want to create formulae in the 
summary sheet to harvest values from the individual sheets. That way, 
the values on the summary sheet will automatically update as you work 
on the individual sheets.

Or you could use one sheet instead of multiple, yearly sheets in the 
first place. After all, 1 January 2003 comes as soon after 31 
December 2002 as 31 December 2002 did after 30 December 2002. 
Contrary to the theories of some partygoers, nothing particularly 
discontinuous happens to time at the new year!

I trust this helps.

Brian Barker


--
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