Search results

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

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

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!

Perfect Luke! Thank you!

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

Got it! Thanks again to all!

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

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.

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

Got it SirJB7! Thanks a million!

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

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

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.

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

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

W$3 is the "Flow Meter I F"

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

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

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

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?

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