I have uploaded a screenshot of the excel speadsheet.
What am I trying to do is:
1. In the AR4 cell, I'm trying to create a formula that will return the value in the cells between columns AP and AH. Firstly returning the cells from column AP, if there is no value then it will go to the next column. Once it finds a cell with a value in, I need it to return the cells with a value in which also ahs a true expression in the AQ column.
Bookmarks