Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bhujanga

    Prevent Converstion of Long Numeric Strings to Exponential Format

    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...
  2. bhujanga

    Prevent Converstion of Long Numeric Strings to Exponential Format

    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...
  3. bhujanga

    Does Excel Cancel Just not Work?

    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...
  4. bhujanga

    Simple cell reference formula returns 0 when cell is blank

    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.
  5. bhujanga

    Simple cell reference formula returns 0 when cell is blank

    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.
  6. bhujanga

    Simple cell reference formula returns 0 when cell is blank

    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...
  7. bhujanga

    Specifying non-Office 365 Version as Default App

    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...
  8. bhujanga

    Chart Dataset Selection Question

    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...
  9. bhujanga

    Changing Data Source for an Excel Chart in a Word Document

    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...
  10. bhujanga

    Issue #2: Trend Line Equation doesn't Seem to Match Plot

    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...
  11. bhujanga

    Issue #2: Trend Line Equation doesn't Seem to Match Plot

    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...
  12. bhujanga

    Issue #2: Trend Line Equation doesn't Seem to Match Plot

    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...
  13. bhujanga

    Issue #2: Trend Line Equation doesn't Seem to Match Plot

    ...based on it. Is there something I’m not properly understanding in the way this equation is represented? For example if I plug in 15 I get: (.000003 * 15^4) – (.0002 * 15^3) + (.0034 * 15^2) – (.0162 * 15) + .028 = (.000003 * 50,625) – (.0002 * 3,375) + (.0034 * 225) – (.0162 * 15) + .028 =...
  14. bhujanga

    Issue #1: Copying Charts without bringin source sheet reference

    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...
  15. bhujanga

    Finding Axis Intercepts of Graph Intersection points.

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

    Finding Axis Intercepts of Graph Intersection points.

    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...
  17. bhujanga

    Finding Axis Intercepts of Graph Intersection points.

    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.
  18. bhujanga

    Finding Axis Intercepts of Graph Intersection 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.
  19. bhujanga

    What New Manor of Evil if This???

    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...
  20. bhujanga

    Can't Purge Links

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

Part and Inventory Search

Back
Top