Search results for query: *

I thought that would work but it still does it - very frustrating. I did however come up with a solution to convert them that is working. I put a new column next to them and put in the formula: =text(A1,"####################") That seems to do the trick. It keeps all the alphas as they are...

I have data with serial numbers that are up to 20 digits in length. They are alpha numeric but sometimes only happen to have numbers. When that is the case Excel converts them to Exponential numerics as soon as it sees them. The only way I can restore the text version is to manually insert an...

It seems as though for the last few years or so, whenever Excel gets bogged down in something it is impossible to cancel out of it by hitting escape as the screen says to do. Similar when a popup comes up warning you that it cannot complete an operation with the available memory and a cancel...

Yes, the problem cells are those with nothing in them, but your formula works. I could also use: =IF(AND(B5=1,A6=A5,NOT(E6="")),E6,"") Thanks.

I checked out the link. It looks like they essentially do the same thing I did (Option 3), so I guess that's just what you have to do and I'll consider the matter resolved. Thanks for your answer.

I have this simple formula form in many cells: =IF(AND($B5=1,$A6=$A5),E6,"") When there is nothing in cell E6 (in this case), it returns a zero instead of blank. Zero is also a valid possibility for cell E6, so I can't just change all zero returns to blanks. I can get around by using this...

I have Office 365 but I also still have Office 2010 installed. I don't like the way 365 does certain things and so I want to use 2010 as my default app in Excel. I was able to set this up without any trouble my other computer but on my new computer, even though it shows that there are two Excel...

When I create line graphs, sometimes it sets them up in such a way that the horizontal axis labels are specified in the same dialog box as the series name and the vertical data points, like the first screen shot in the attached document. Other times it only has the series name and the series...

I am making various reports that are basically the same but with different specifics. So for the first on I created a nice Excel sheet in which a I can carry out all my manipulations and I have various ranges of that sheet linked to charts in the Word document. Now I want to be able to make a...

Combo - Now I see it. That fixes everything for this situation. I kept clicking on the line itself and trying to find the option in that pop up. I didn't think to right-click on the actual label. Clearly I've not played enough video games. Daniall, I looked over your Solver method. It's...

I don't think they would be sinusoidal. They are traffic counts during 1-hour intervals for just a few days. I have similar sets for different stretches of highway. They are for estimating traffic during a specified hour based on a daily traffic volume, I wanted to find a formula for predicting...

Deniall, I tried bumping all of the coefficients up or down to the maximum amount the would leave the rounded coefficients unchanged, in the direction that would increase the total. By doing this, I was able to get the total to increase beyond where it needed to be, so I figured your theory...

My 2nd issue today is that I can’t figure out what is going on with the trend line equations. I have this particular chart to which I have fit a 4th order polynomial trend line. It looks great – just what I would expect. However when I plug the x values into the equation it has provided, I do...

The first issue I have is that when I copy an entire worksheet which includes multiple charts, all of the charts keep the reference to the origin sheet in their data definitions. This makes me blue because I just want to be able to paste new data into the new sheets and be done! But instead I...

Thanks for your replies. I'm going to experiment with this last group of functions to see if anything within them will get there.

That could be done in this case, but we are trying to find a more general solution for when the function may not explicitly known but implied by a collection data. I am gathering, however, that Excel doesn't have a specific tool that does that. I was hoping it might be something they provided...

The plots are driven by sets of points. The values of the points have been derived from functions, but as far as the Excel sheet knows they are just sets of points.

Is there a way in excel to find the intersection of two line plots and create a line that goes from that point to the x and/or y-axis.

So, this is hands down the craziest thing a computer program has done to me to date. I have a very complicated (lots of command buttons, macros, sheets, complex equations) spreadsheet that is used as a template for specific cases. It's been working fine for a long time. Suddenly the following...

I never could track it down. I decided to take my chances and went ahead and broke the links. thanks for the input.