Forum Discussion
If a cell has a text, how to move the cell associated to it to a new location (T&F Coach)
I used that data --> filter suggestion that you said and it worked IF the 100 was listed as Event 1. If the 100 was under the Event 2 column, it would not appear as part of the filter....am I missing something?
Also, I agree with you on moving the stuff on the far right of the page to another spreadsheet, but I do not know how to use the countif function from one spreadsheet to another.......I just set the print area so that part of the spreadsheet does not show up.
Any help is much appreciated!
It's less complicated than it might appear.
So dealing with your two questions:
- On the data filter for events 2, 3 and so on, because you have them as separate columns, you have to use the filters one at a time. So to filter only for the 100 event as Event2, make sure that all the other columns are showing "All"--as I've done in the attached. [It is possible to use multiple filters at the same time, but they operate in conjunction with one anther; that's why so long as event 1 was already set to "100" it would be self-defeating to also ask for "100" in event 2, unless there's a single runner doing it twice.]
- All you needed to do was open other sheets and copy and paste the other data to those other sheets. The formulas took care of themselves, and (in the process) serve to illustrate for you how you can refer to data on sheet 1 in formulas in other sheets.
First, I figured out how to copy and paste into other sheets, thanks so much!
But, back to my main question...the way I have this spreadsheet setup, is there no way to compute what I am looking to do (if the same event is in different columns due to how I presently have the roster sheet constructed)....
Or, is there another way to format it that I am not aware of to make this work and simply things for roster creations?
You got an answer from Patrick2788 which looks like it definitely works. My concern about that is that it's a fairly advanced methodology that I've not used. Why don't you start with that, if it does indeed give you a way to move forward.
Let's see what others come up with. I believe that some variation on Power Query would work for you as well--unfortunately, my version of Excel doesn't seem to have that capability so I'm not able to offer guidance.