 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
I'm at work looking through an old spreadsheet and I have a cell formula saying =@$30:$30 but I'm not entirely sure what it does. It certainly doesn't do what I think it should, which is: look down column A for last cell with an entry then return the value in column X in that row.
Any ideas a) what the @ does, and b) how to do what I think it should do?
I've figured b) out with a bit of =INDEX() but still stumped on the a),
The @ can appear for a few reasons. I most often see it in tables where a function has been automatically copied down to the next row as the table expands by Excel itself. In your case the @ doesn't do anything as the result is always a single cell but where the result would be several cells the @ defines which of the several cells to return. I'm guessing that Excel just always automatically adds it when expanding the table as that is the safe thing to do. If the formula isn't in a table like that then I don't quite understand why it is there though
Might be wrong though
use the trace precedents/dependents function to work out what its referring too.