Forum Discussion
Help, Excel Spreadsheet Formula w/ Over and Under
Hi, I have a simple question but I am unsure on how to do it. I am attempting to create a sheet that will read out how many units over/under you are based on what numbers you have inputted vs the...
HansVogelaar Thank you! Feel foolish it was so simple. Is it possible to format a table so it will fill automatically as values are entered?
If you format the data as a table, and enter the formula
=[@Count]-[@Base]
in C2, then fill down if necessary, Excel will automatically enter the formula as you add new rows to the table.