I am having a data table with 3 column, 1st is Month (April to September), 2 is Name and 3rd is Status of the month (i.e. Pass or Fail).

I want a formula where i can capture the monthly status i.e. Pass or Fail in a particular month (in table Name are mentioned in col level & Month are mentioned in row lavel)

pls suggest

Thanks and Regards,




It's important to know not only the source of data but also the design of the report where you want the formula. Please attach a workbook to your question which contains both.
In order to attach the workbook you need to "Edit" your question.
Variatus (rep: 3378) Dec 14, '19 at 2:59 am
Please also use a descriptive title for your questions.
don (rep: 1745) Dec 14, '19 at 3:14 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login