Evening all, First time post, so I apologize if this is misplaced or not laid out properly.
I am having issues referencing specific cells using both IF and COUNTIF....Maybe it'll be easier if I just post the fomulae and show you what is happening...
I am using the following code to locate the last non-blank cell of a row, and the cell 8 before it
Now both of those will return the desired results of $B$112 and $B$104. But when I try to use either the above codes as reference points in my logical statement, or when I use them in a separate cell and reference that cell, I get an error. Looks something like this:
That will return a result of False, even though the cell that is being referenced (B112) does contain the text value of "Pal". When I manually enter the results ($B$112), the result comes back as True. I can't even get a single cell reference to work, much less use those in a range, which is part of the end goal. I am way out of my element here, so any assistance would be greatly appreciated.