I was wondering if someone can help me. I am looking for a formula that can pick up the last with content of X01, X02 etc.. within a Row. As i need the formula to pick up only cells that have "X"
I am currently using =IF(A17="","",(LOOKUP("xx",L17:AE17))) to pick up the any content but i need another one that pick up specfic cell that Contain X01, X02 etc,
See attachment as reference
Thanks
Bookmarks