Forum Discussion
DennisMetro
Jul 02, 2021Brass Contributor
Excel formula
1. =IF((C10="")*(D10=""),"",IF(C10>D10,$B$10,$E$10)) this formula correctly fills G16 with either B10 or E10 data. 2. G17 contains a graphic which is linked to a named range and which works...
- Jul 05, 2021
You may add named formulas for each cell with flag, e.g. for L17
=XLOOKUP('Linked Picture'!$L$16, 'Linked Picture'!$Z$31:$Z$46, 'Linked Picture'!$AA$31:$AA$46,'Linked Picture'!$AA$47)
and for O17
=XLOOKUP('Linked Picture'!$O$16, 'Linked Picture'!$Z$31:$Z$46, 'Linked Picture'!$AA$31:$AA$46,'Linked Picture'!$AA$47)
SergeiBaklan
Jul 05, 2021Diamond Contributor
You may add named formulas for each cell with flag, e.g. for L17
=XLOOKUP('Linked Picture'!$L$16, 'Linked Picture'!$Z$31:$Z$46, 'Linked Picture'!$AA$31:$AA$46,'Linked Picture'!$AA$47)
and for O17
=XLOOKUP('Linked Picture'!$O$16, 'Linked Picture'!$Z$31:$Z$46, 'Linked Picture'!$AA$31:$AA$46,'Linked Picture'!$AA$47)
DennisMetro
Jul 05, 2021Brass Contributor
Sergei, Thank you very much indeed. That works quite well. I will have to look at it in details to try to understand but I think I know how it ties up with the linked cell. I found that the place holder is best made the same colour as the empty background. Adjusting the transparency of the placeholder, say to 0, means the inserted image when the score is known is also transparent. At any rate you've helped me reach a more satisfying outcome. Although I understand a bit in Excel I always have a feeling that there is a better way or an easier, more logical way that I don't know. For example I still have to work out the underlying facts about linking graphics and the size compared to the cells; trying to make the placeholders a bit smaller in relation to the graphic being linked; and checking to see if when a result is entered and a subsequent game is populated with new teams - the names go in but the format doesn't. I'm guessing that to have the correct format the team names would also have to be treated almost like another set of graphics.
Anyways, thank you again very much for your knowledge and help. Dennis
Anyways, thank you again very much for your knowledge and help. Dennis
- SergeiBaklanJul 06, 2021Diamond Contributor
DennisMetro , you are welcome, glad it helped.
That's bit more practice, try with different variants for better understanding how it works. In general not a rocket science.