[Example] Update soccer football table 2

[Obi]

Hello to everyone,

A few years ago i posted a screenshot, now i did it concretely: that is possible away wins up to 0-15/9-15 (which is shown as 0-F/9-F because A to F are high hex digits), and not "only" to 0-9/8-9. (I just wanted to test this, perhaps no REAL sence, but a theoretical use surely)

The version here is full functioning and with a few significant changes.
You can start immediately.


But you can of course set up and use your own number system here with a list, done with VLOOKUP until "Z",35 then (Fourth parameter not set). Football matches never go higher than that; Rugby/American Football(as we call it in Germany) does, i am sure i remember.

Possible could be also two digit draws or 11-12, 12-10 f.e.,too, with length = 4 (includes the "-").
+ There's a needless 'VALUE' in AY115pp. at the HEX2DEC/at new VLOOKUP.


Done without A.I. (which is not Amnesty international)

BA220pp. and BB220pp. are empty now: deleted them because of space, but you can undo this quickly via re-inserting (use Copy) these two columns BA and BB from version 4 and checking version 5 AZ/BB them refs more far right (these are still two 'AZ' Refs):
by selecting: BD220:BD594 and BF220:BF594 (both in sequel) in the 5,
THAN DO THAT WITH FIND & REPLACE:
Edit - 'Find and Replace', replace 'AZ's with 'BB's in the boxes, expand to 'More Options',
then, checked, 'Current Selection Only' must be checked!! , choose 'Replace All' then.

Chris

((EDITh:Thread-ID in the file has to be actually 113077))

---------------------------------------------------------------------------------------------------

DID the changes now :