Forum Discussion
relative cell references in a formula
I have a worksheet that performs a lookup to another sheet to count how many items of the type are there. Anyone familiar with disc golf will recognise what I have in the image below. The only fo...
Do you have the data in an Excel Table? That only allows entire records to be sorted and a unit and tends to be more meaningful.
- I'll take a look. I've heard of tables, but never used them.
Thanks.- Ctrl/L or Ctrl/T are shortcuts to creating a table when a cell within the would be Table is selected. Make sure there is blank space around the table.
PeterBartholomew1 sorry, that didn't work. I created the table (those alternating stripes are annoying... but, no matter), but when I sorted on a column with the automatically applied filter tool, the cell retained the formula reference for the location it had before the sort, rather than the cell five to the right of its current position.
