• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    Best free add-ins for excel

    Thank you for the response Luke. I was looking around but without success but, where would I find "Luke M's Tools"? Thank you
  2. S

    Best free add-ins for excel

    For myself, I really enjoy Megastat for a variety of reasons. The reason for the post is that I have recognized that there must be other add-ins that are terrific as well that I am just not aware of and this string could not only make myself better but other's that read it as well. Thank you...
  3. S

    Best free add-ins for excel

    I currently use a couple of different add-ins for excel and did a search on this website that wasn't successful. But there are so many awesome individuals on this site, perhaps you wouldn't mind sharing what are your favorite free add-ins for excel and why? Thanks in advance!
  4. S

    .xls opening without popup about "This workbood contains one or more links.."

    Good morning all. I have been using a spreadsheet on our company's sharepoint site that is in an Excel 2010 .xlsx format. I create other reports as an export from a completely different program and that program creates the documents in .xls without an alternate option. When I open my .xlsx...
  5. S

    Best Fit??

    Got it! Thanks again to all!
  6. S

    Best Fit??

    Okay, still have issues with the equation. Here is what I have: X data points are:60, 80, 100 Y data points are: 1.55, 3.49, 4.79 When I do the trendline for the graph, I am selecting a 2nd degree polynomial, display equation on chart, and display 4-squared value on chart. My equation for the...
  7. S

    Best Fit??

    As always Hui, great answer. Still having some problems but I will spend some time working through the links and see if I can resolve the problem. The main problem that I am having is major issues between calculated values and real world values.
  8. S

    Best Fit??

    Is there a function that I could use on three data points that would provide the best fit funtion for three data points. I have about 70 fans that I would like to use the affinity laws to predict the power consumption based upon speed. The kicker for me is due to the dynamics of the...
  9. S

    Using Developer

    Got it SirJB7! Thanks a million!
  10. S

    Using Developer

    SirJB7 - awesome job on the attachment and it works great in the attachment. For some reason though, I can't impliment the code because of an issue with the macro settings. I have save the file as macro-enabled but I still can't get it to work. I will work with it some more but thank you very...
  11. S

    Using Developer

    I am currently using developer in the creation of a form. I would like to know how to do the following. If I create a check box and have the cell link =$N$7, then when I check the box, N7=TRUE. Here is the solution that I am looking for. If N7=TRUE, then I would like to have the contents of...
  12. S

    Looking up a value based upon two variables

    I will give the information in the link a try and report back if it worked or not. Thank you very much Faseeh and Luke M for your replies.
  13. S

    Looking up a value based upon two variables

    I am trying to find a value based upon a couple of variables contained within a different workbook. The first layer of filtering would be based upon site. The second layer would be based upon room within the site. The last would be based upon location within the room of the site. Not sure...
  14. S

    Max number of data points that HLOOKUP can reference?

    Turned out to be operator error. When ctl c and ctl v and subsequent modification of the equation, didn't modify the range. The range previously had been overly broad but in this sheet, it was restrictive and couldn't pull data through. Thanks all for your time and consideration in providing...
  15. S

    Max number of data points that HLOOKUP can reference?

    W$3 is the "Flow Meter I F"
  16. S

    Max number of data points that HLOOKUP can reference?

    =IF(PDU!$C$1>ROW()-4,HLOOKUP(W$3,'Flow Trend Apr 2013.xls'!$A$3:$U$2976,ROW()-2,FALSE),"")
  17. S

    Max number of data points that HLOOKUP can reference?

    I am having issues with a spreadsheet not referencing all the data points in a seperate workbook. I have verified that the function works because if I change the reference name to one that is working, the data is pulled through (ex. "Flow Meter I S" works but "Flow Meter I F" does not. I am...
  18. S

    Concatenate to link cells and create a link across workbooks on a network drive

    I am able to get this string to work on my C:/ but not on the corporate X:/ IT changed some settings but it still seems to be an issue. One additional question for you Hui since I have seen your posts all over and you obviously have a lot more exceo experience than myself. Indirect seems to...
  19. S

    Concatenate to link cells and create a link across workbooks on a network drive

    Thank you very much for the invite Hui. You are absolutely right. This was just a mistake made when I was entering it into this forum. But for some reason, I am still having issues with the formula. Any other thoughts?
  20. S

    Concatenate to link cells and create a link across workbooks on a network drive

    Having a bugger of time with this one. Creating a short cut for users so all they have to do is enter a date. The date is broken down into year and month in seperate cells. I am then trying to link cells and text to create a pathway to draw data out of specific workbooks. Example. A1=Feb...
Back
Top