Unanswered: Last cell with entry
This ought to be pretty simple, and worse still, I have done a few spreadsheets with similar functions creating sums.
Nevertheless, I have the following problem, that I just can't seem to solve.
On the left-most sheet, labelled "main sheet" I have a column A containing rows with labels for a series of tasks.
Next to each task there is a cells that ought to contain their respective latest entry in a subsheets.
Each task has a subsheet that contains 2 columns.
A, contains a date, DD:MM
B, contains a variable text, referring to what was done on that dae
My problem is, on the main sheet I can't get the cell related to task to show the latest column B entry.
What function should I use? I try to build an IF statement, but it just doesn't work.
Cheers, and thanks in advance,
IT squid: networks, servers, firewalls, routers and I dabble a little with SQL-server and Access as well....