Hi,
I would like to know how to do this.
So in the attached sample file, rows for all columns B to F will only have value 1. So for all the rows, only one column from B to F will have value 1.
Now, I want to get the category name and value in Cell J2 and K2, corresponding to date in cell I2 using a formula.
How to do this
Thanks
Bookmarks