Hi All,
Yet another challenge for me.
Sample sheet attached which I hope helps you understand
Thanks for any help offered.
Hi All,
Yet another challenge for me.
Sample sheet attached which I hope helps you understand
Thanks for any help offered.
Hi again,
You seem to be surrounded by many challenges ...!!!
Could you post your file with all your manual calculations for Column D ...
see attached ..
If my understanding is correct ...
See attached test file with your formula ... :wink:
Hi Carim
Almost there but I dont want a sum, just a value of 1 returned if a "y" exists anywhere in the range
with of course the limitations of NA being present in H17 and or I17
Updated sheet attached with a few options to show the variables and expected results.
Thanks
Hi again,
Thanks for your explanations ...
Attached is your Version 3 adjusted ... :wink:
Hope this will help
Hi Carim
Justthe job, great work.
You seem to be surrounded by many challenges ...!!!
I think this is due to age, but cannot be sure :cheers:
Many thanks
Display MoreHi Carim
Just the job, great work.
I think this is due to age, but cannot be sure :cheers:
Many thanks
You are Welcome ...!!!
Thanks for your Thanks :guitar: and for the Like :thumbcoo:
:facepull:
Hi Carim,
In my haste to get a result, I omitted a vital criteria from this calculation.
"y" must be present over the whole range Act 1, Act 2, Act 3 as a minimum but can include Act 4 and Act 5 if they are active.
In the example I have inclued a sum column to show my thought process, but I cannot include this on the actual worksheet (no columns between the data sets)
But if it is required, I could change a few things around.
See attached which hopefully exaplains
Thanks
Hi again,
Hope the attached Version 5 is is in line with ... your thought process ...:wink:
Hi Carim
Thanks for the assistance "Again"
Almost there, but I do not want a sum of the row, just a 1 in the left column if all the criteria is acheived.
Thanks
My only objective was to ... properly replicate your Column J ... which ... to me ... was your Expected Result ... !!! :drunk:
What about the surprise of ... Version 6 ... :drink:
Hi Carim,
Sorry I have really confused you now.
Attached is an updated sampe to hopefully explain a little more.
Thanks
for further clarity, and if its simpler, the calculations in column D do not need to be for each row.
This can be a single calculation in D18 to show achievement of all the criteria.
Thanks
Attached is the last Version 8 ...
Hi Carim
Your time and efforts are very much appreciated
It is indeed the last version as everything works great.
I just need to incorporate the extra 2 columns into the worksheet now.
Should be just a case of moving stuff around, but array formulas can be awkward.
Thank you
Nice relief ... to hear this problem is finally over ...:lol::lol::lol:
Thanks again for your Thanks ...AND for the Like ...
Hello JL,
For the sake of consistency ... have quickly revisited your Test file with a Version 9 (identical to the number of Questions :wink:)
Both Counting Rows and Columns is performed with the same formula structure ...
to generate Checks for your blocks of 9 Questions ...
Hope this will make things easier to maintain ... :lol:
Hi Carim
Thats great, thank you for the follow up.
I modified the solution slightly as the same columns in the sample sheet are replicated accross the columns many times but with 1 column spacing between.
so, the rows and columns calculations have moved, but nevertheless an awesome solution
btw, that is some Array formula, and I have no idea what is means :duh:
Amazing support once again.
Thank you
Hi Carim
btw, that is some Array formula, and I have no idea what is means :duh:
Neither do I ... :lol: :lol: :lol:
Don’t have an account yet? Register yourself now and be a part of our community!