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 :
[Example] Update soccer football table 2
[Example] Update soccer football table 2
- Attachments
-
- SolutionVLOOKUPFootballSoccerTable_Forum2.ods
- explanations, better understanding
- (126.1 KiB) Downloaded 6 times
-
- SolutionFootballSoccerTableLastSteps_Forum.ods
- expert version
- (127.59 KiB) Downloaded 4 times
-
- FootballSoccerTable_ForumVersion5.ods
- (123.61 KiB) Downloaded 14 times
Last edited by MrProgrammer on Tue Sep 23, 2025 4:47 pm, edited 1 time in total.
Reason: Mark topic as [Example] for Calc, since it isn't a question
Reason: Mark topic as [Example] for Calc, since it isn't a question
Apache OpenOffice 4.1.3, meanwhile 4.1.9 on Windows seven
link to my little football table helper tool here in the forum: ... and then /viewtopic.php?f=9&t=110721
link to my little football table helper tool here in the forum: ... and then /viewtopic.php?f=9&t=110721