Forum Discussion
Solved
Formula which present the values as required
I have tried at my end to make such a formula which fulfill the data Quarterly as Q12020, Q22020 after that then H22020, H12021, H22021 and so on. But i could not done this then posted here to get th...
Hi Hans, I hope you are doi n well. I need some changes nin formula if you can help me out further with this that,
If I select Q42020 then first cell shoul show
Q42020
Q12021
Q22021
Then
H22021
and further
Same if i select
Q22020
Then formula first cell will be
Q22020
Q32020
Q42020
Then
H12021
H22021
and so on
Rest will be same as already available in formula.
If I select Q12020 or Q32020
Then first 2 cell will be quarter then half.
If I select Q42020 then first cell shoul show
Q42020
Q12021
Q22021
Then
H22021
and further
Same if i select
Q22020
Then formula first cell will be
Q22020
Q32020
Q42020
Then
H12021
H22021
and so on
Rest will be same as already available in formula.
If I select Q12020 or Q32020
Then first 2 cell will be quarter then half.