OK-
I created 1 tab with all years concatenated, and replaced the 'year-sheets' to
select from the main concatenated list.
Thanks to all for the reactions.
Rob.
On 6 feb. 2017, at 13:48, Bruce Hohl wrote:
> For more compactness, maybe you could create a maxifs() pointed to each
> sheet then
For more compactness, maybe you could create a maxifs() pointed to each
sheet then a maxifs() against those maxifs() results. I agree with Brian
on the point of keeping all data in one sheet if practical. With that
approach it's still possible to have separate tabs for each year for the
analysis
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
Hi,
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
