Forum Discussion
Calculate the width of square dynamically based on columns and rows
mathetes Hi, I manually input the correct row and column the images are on. its just using a formula on the rows and columns to get the size of it.
For instance. =IF((A3-A2)>1,A3-A2,1) gets me the correct columns but does not account for the size of the games that span multiple rows
Since nobody else has chimed in (yet), I'll give it another try. I still need to give you a more clear explanation to someone who's not inside your head. You know what you're saying, what you're doing. It's still not clear to me.
I've asked before, and I'll ask once more:
Walk me through how you'd do those calculations that you want if you were NOT trying to write it in Excel. That's what I meant in one of my earlier messages when I asked you to walk through a complete example for (I said then several rows because I was going the other direction) ..
So now, I'm asking that you walk through .for several images and spell out what you're doing to get the numbers you are looking for. Don't talk about rows and columns; talk about numbers and where you get them from, what you do with them, how you get the size/weight from those.
Maybe another way to say it: if you were back in school working this out on a blackboard (or whiteboard), how would you do it and explain it to the others in the class?
- mathetesAug 07, 2020Gold Contributor
I've given you a few thoughts on the attached. But bottom line, I'm not sure that this can be done dynamically, as your original request seems to be seeking. I'd be delighted to see others chime in with suggestions.......
Are you really doing this with the kinds of images you've shown? Why is it important? Part of some game?
- jacksaxbyAug 07, 2020Copper Contributor