Forum Discussion
Need Help with this problem i dont know if its VBA or formulas any help would be great
I'm working on this spreadsheet and in order to get it to do what I want I need to count the number of times a cell has changed. Problem is I have 54 Assets and 298 total variables. its outlined by a...
instead of having a fixed layout where you change the values at each location you should consider creating a running LOG file and you can have columns be like DATE, LOCATION, ID, ...
Then you can have another page showing the most recent value for each location as a visual 'report' of the present state and then you can also easily tally the # of entries for particular locations, the times between changes, etc...
Then you can have another page showing the most recent value for each location as a visual 'report' of the present state and then you can also easily tally the # of entries for particular locations, the times between changes, etc...