Forum Discussion
If a cell has a text, how to move the cell associated to it to a new location (T&F Coach)
I'm sure there are other ways to do this (Excel always has multiple ways to skin the cat), but the simplest and most straight-forward is to set your roster up as a table and use the Data...Filter capability. I've done that here for the folks running the 100. All of the others are still there, just filtered out of the view for now.
See those little carets at the top next to each heading? Click on the caret for "Event" and you can change the filter.
By the way, your spreadsheet would be less liable to confusion if you took all that stuff off to the right, and down below under the roster...separate that stuff into separate spreadsheets. The COUNTIF function, along with any others you have used (good for you!), will still work even if it's on a separate sheet.
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?
