USCHO Fan Forum
This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!
-
The USCHO Fan Forum has migrated to a new plaform, xenForo. Most of the function of the forum should work in familiar ways. Please note that you can switch between light and dark modes by clicking on the gear icon in the upper right of the main menu bar. We are hoping that this new platform will prove to be faster and more reliable. Please feel free to explore its features.
Excel Help v. 1,000,000
- Thread starter AMC
- Start date
ExileOnDaytonStreet
Drunkard
Re: Excel Help v. 1,000,000
Where it gets really complicated is if I had to do this over a three column spread (and it'd be a lot easier if there was an option within COUNTIFS that allowed for selecting an OR condition)
Works as well as anything I could think of.
Where it gets really complicated is if I had to do this over a three column spread (and it'd be a lot easier if there was an option within COUNTIFS that allowed for selecting an OR condition)
Last edited:
Re: Excel Help v. 1,000,000
I am trying to create hyperlinks to another sheet in my document. I need to copy the same link multiple times, then sort by a different column, then do the same thing for that column, etc.
After I do one column, and sort, the links all get messed up. Anyon e know how to get around this without having to do each cell inidivudally?
I also tried using =HYPERLINK(sheet!cell,"name"), and it only works the first time I click on it. After that, it says cannot open the specified file.
I am trying to create hyperlinks to another sheet in my document. I need to copy the same link multiple times, then sort by a different column, then do the same thing for that column, etc.
After I do one column, and sort, the links all get messed up. Anyon e know how to get around this without having to do each cell inidivudally?
I also tried using =HYPERLINK(sheet!cell,"name"), and it only works the first time I click on it. After that, it says cannot open the specified file.
Last edited:
JF_Gophers
2147483647
Re: Excel Help v. 1,000,000
If you only want one or the other to never change, you can just use the dollar sign in front of one of them (i.e. $A2, A$2).
My guess is that it gets messed up because you aren't making the cell placement permanent. Try using a dollar sign in front of the cell row and column (i.e. $A$2). Then it will never change.
If you only want one or the other to never change, you can just use the dollar sign in front of one of them (i.e. $A2, A$2).
Re: Excel Help v. 1,000,000
didn't work. it isn't that the link points to the wrong place - it doesn't point anywhere. it's like it linked that cell, and when I sorted, it didn't sort the link along with the data.
this apparently was a known problem in 2007, but I have 2010 and can't find reference to it still being a problem there.
edit: it appears to be a problem with PASTING the links. anything pasted doesn't stay linked after the sort. if I do them all individually, it appears to work. 300 lines.
didn't work. it isn't that the link points to the wrong place - it doesn't point anywhere. it's like it linked that cell, and when I sorted, it didn't sort the link along with the data.
this apparently was a known problem in 2007, but I have 2010 and can't find reference to it still being a problem there.
edit: it appears to be a problem with PASTING the links. anything pasted doesn't stay linked after the sort. if I do them all individually, it appears to work. 300 lines.
Last edited: