Recent content by drmichaelw

That was easy Thanks!

How do you create a drop down box in a cell with the only choice of Yes or No?

I did read the help and found it a bit confusing. So if my results for the 19 months is -26.0%. That means what?

Thanks for the info. The formula works, can you explain what this formula is doing? Why doesn't a positive # work for the guess and why doesn't the value change when I use guess of "-.5" or "-.9"?

I am using the IRR function and I am getting #DIV/0! returned. When I check my data there is no zero value. Here is my formula. Can you tell me why I am getting #DIV/0! =IRR(B6:T6)*12 Here are my values: ($24,000.00) ($128,448.45) ($30,000.00) ($100,000.00) ($27,000.00) ($50,000.00)...

Dale, That sounds great. I will go through the data tomorrow and will send you a sample worksheet. The feature which sends the graphs to powerpoint sounds great as well. I will communicate with you soon Regards, Michael

What I would like to do is click a button that runs code, which creates bar graphs of my data. Mytable columns: Description, Part ID, Fab, system division, total/partId for each part Id I have different fabs, systems and total/partId. Iknow what I want to do however I don't have much...

I forgot to mention that the excel data is comming from Access. My alternative would be to create the charts in access, and export them to excel. I never used chart in Access. Can anyone help with this alternative. Please refer to my initial question. Thank you.

I'm only a little bit familiar with vbscript, but is there a way to create a macro to graph my data. My table columns are (name, part,fab,totals,division and totals/part.) I would like to create a different graph for every part. The x axis would be fab and the y axis would be totals. I am...

Worked well! How do I add in the leading and trailing 0 before and after the decimal place.

Sorry for the confusion! Sample data: 0 00 000000 000000-000-00 000-000-00-000 Each month I receive new data and I won't know in advance how many part id will have data like the above, and what combination of zeros and or dashes they will have. Any Part id that contains zeros with or without...

SELECT system, total, system/total AS [sys/total] FROM table; Iwould like to return only one decimal place instead of many for [sys/total]. How can I format to one decimal place?

Bob, I'm not sure what you are doing on the WHERE clause. It looks to me that the only value that won't be selected is the one you listed, or are you saying to make a WHERE clause like this WHERE [part id] <> '0' AND <>'00' AND <> '000', etc.?

Select CLng([Part ID]) From table WHERE [Part ID] >0 I get an error in the expression. Problem out of the over 20000 rows some of the part ids have letters. Would this blow up the Clng function?

I have a select statement that includes [part id] The excel table that I am linking to has &quot;dirty data&quot;. Some [Part Id] have been assigned 0,00,000,0000,etc. [Part Id]is text not a number. I am performing a COUNT function on [Part ID] and it counts the [Part Id} with the...