I have a spreadsheet that is constantly updating itself from the internet.
The spreadsheet has a list of 30 people and their respective data from an
online game.
I am trying to make a column labelled "Last Played", I would like this
column to automatically update, unfortunately the information available from
the internet does not show an entry for the last time a player logged on. The
only way I can tell is if their score changes. So in column "AH" I have all
the players overall scores (updated automatically every 24 hours), in column
"AJ" I have any points gained since column "AH" was updated (updated
automatically every 2 mins).
If in column "AN" (my "Last Played" column) I put the formula
=IF (AJ10,today(),)
then today's date is shown in cell "AN1€� that works nicely.. my problem is
if "AJ1" = 0, (showing that a certain player has gained no points that day)
how can I keep the date shown in the cell "AN1" to show that date that their
points increased, i.e. show the last date that "AJ1" did not equal 0.