I would like to return the numeric value in the cell that is always 5th back from the last entry in a row (moving left to right) while ignoring cells that contain text or blanks. Assume my data is in the 6th row that starts in C6 and moves right with each new entry, the last cell used will be AA6. The formula I have been using is:
This has served me well by returning the 5th value back while ignoring blank cells. However, I needed to add cells containing only text to the row. Now the formula counts the cells containing text and returns the text as the value when it is the 5th cell back. I would like it to ignore all cells containing text so they will not be included in the 5 count and will not be returned as a value. Currently if the very last cell (furthest right and first to be counted) contains text it seems to ignore and skip it, however if there are other cells containing text within the last 5 cells it counts those. The worksheet has many rows so once I have the formula for row 6 I will copy down to the bottom of the worksheet. Any solutions would be greatly appreciated.
Thanks in advance for your time and wisdom.
Bookmarks