SOLVED

..reporting a quarter to a date...

Occasional Contributor

Hello all,

 

hope you are doing good...and hope someone would be able to help me with this.

The subject looks a bit weird but i don't know how to describe it another way so... let's try to explain it.

 

I have a tab in excel where someone collects this information (related to some tests done on quarters over the years)

 

Kaddrik_1-1650897827468.png

 

What i need to do is... on another tab, i have dates identified by month

 

Kaddrik_3-1650898029410.png

 

I would need on this second tab , to have a value "Y" or "N" at the level of the quarters for the different years.  If all the entries of a test for a quarter on the first tab are "Y" then on the first tab it should show "Y" for the corresponding quarter .

Else if one or all of the values of a quarter in the first tab is "N" then it should show a "N" on the second tab for the corresponding quarter.

 

Do you think it's possible ?

if it is... would you please be able to help me with this ? 

and if readapting the values somewhere helps you...what should i readapt on my excel sheets ?

 

Hope someone will be able to help me ...

 

thanks a lot in advance

 

2 Replies
best response confirmed by Grahmfs13 (Microsoft)
Solution

@Kaddrik 

You can try the attached sample file with a few helper columns.

Hi @Quadruple_Pawn,

Waw...thanks a lot for this !!!
I just had a look at your file and it seems to be exactly what i need. I will have to add a few columns but as long as it work....

Will give it a try tomorrow.

Thanks a lot for your help !!