Hello,
I have limited knowledge of Excel and I was wondering if you could help me with a question about building a formula in excel. If you can here's what I have. The goal is to have one column where data can be filtered. The reason for this is that the specific group of columns will be hidden. I am using =IF($I2>0,"Current","") in cell ?A2? but if it returns a blank I want the formula to move to the next cell in that row with this formula =IF($J2>0,"0-30","") and so on until it finds a cell that?s not blank then stop and then populate cell "A2" with the title for the cell where the information was captured. Below is a row from the spread sheet in question.
I thought using this formula in cell ?A2? would work but of course it didn?t work and searching online is not helping.
IF($I2>0,"Current","", IF($J2>0,"0-30","", IF($K2>0,"31-60","", IF($L2>0,"61-90","", IF($M2>0,"91-120","", IF($N2>0,"Retention",""))))))
Bookmarks