Hello,
There are ways of doing this without scripting, but if your entries
contain text, then scripting may be required, because my method of
sorting/removing duplicates requires the RANK() function and this
function only works with numbers. If your cells do contain text and the
lengths are short
Regarding the following, written by "Brian Barker" on 2021-08-18 at 02:33 Uhr
+0100:
Sorry, but I have no idea what this picture represents. It is usually
more helpful to explain how your sheets are organs.
Sorry, these were ASCII-formatted tables, but something munged them
on the way. Here
At 22:29 17/08/2021 +1200, Martin F Krafft wrote:
I've got several sheets with values such as the following:
| Thu | Fri | Sat |
|:|:|:|
| 5 | 6 | | | | 9 | 10 | | 1 | | 2 | | | 9 | 10 | | 11 | | 12 | | 7
| 8 | | | | 3 | 4 | | 11 | | 12 |
Here is another
| Thu | Fri | Sat |
Hey,
I've got several sheets with values such as the following:
| Thu | Fri | Sat |
|:|:|:|
| 5 | 6 | |
| | 9 | 10 |
| 1 | | 2 |
| | 9 | 10 |
| 11 | | 12 |
| 7 | 8 | |
| | 3 | 4 |
| 11 | | 12 |
Here is another
| Thu