Search results

Just to tack on to the above, I realized that the graph is correctly omitting entries with 0 values (one has a negative value, which confused me initially but that's another issue). However, it is NOT showing all of the entries that do have values. Can you help correct this? FYI, there are...

Hi Hui - So (I think) I made all the changes per your instructions and example that you sent back to me, but the chart isn't working correctly. What I want the chart to do is only graph the risk entries on the list that have a value, but with the changes the graph is now showing some entries...

Thanks Hui! I am going through this trying to figure out exactly what you did on the file. If it's OK, I may ask you a follow up question later. In the meantime, I sent you a thank you :)

Hi! I have a bar chart that I have formatted to automatically display the individual bars in different colors depending on their value. However, my boss now wants me to omit any data points (bars) that have a zero value from the chart. I can't figure out how to do this automatically and...

OMG!! My jaw has completely dropped! This is awesome! Worked like a charm... I feel so powerful now! Thanks a bunch for this tip - live long and prosper, my friend!

Hi Ninjas! I hope this is easy for you, but it has bedeviled me for months. When I download Excel extract reports from our databases, the dates are always in a general format and preceded by a ' (i.e., 'MM/DD/YYYY"). I want to be able to easily convert these to true dates by changing the...

Posted a sample workbook below. In this workbook, I am trying to have the contents from the cells in columns B:G on the Plan Objectives tab transfer to the correct quarterly worksheet based on the value in the cell in Column I. If the value in Column I is "ongoing", then the activity should...

Hi! I have a workbook w/5 sheets - an annual plan sheet and 4 quarterly sheets. I don't want my users to have to cut and paste their activities from the annual plan sheet to the correct quarterly sheet (or to each sheet if it is a year-long activity). I have one cell that designates the...

Narayan!! You are the man! This works perfectly. Thanks again - peace to you, sir!

Hi Narayan - thanks for your response! However, I must be doing something wrong. I set up the modifiers table on a separate worksheet and named the range Modifiers_table. Then I plugged the formula in for the first cell, but I'm getting a #name? error. The formula I'm using is based on what...

Hi - I have a set of values in column A that I need to multiply by a modifier selected from a list of values in column B. The final value would be displayed in column C. The user has a dropdown list of avail modifiers in col B that range from +25% to -25%. I cannot figure out how to write the...

Luke - Awesome!! The force is truly with you, sir - this works great! Thanks a bunch -

I have multiple names in one cell;, i.e, cell A1 contains the names "Chandoo, Luke, Prasad", cell A2 contains the names "Ninja, Luke, Darth", and cell A3 contains the single name "Darth". I need a formula that will look at the contents of each cell in column A and tell me the number of times...

I have a column that uses a macro (thanks to Chandoo!) to allow for more than one name to be selected from a drop down and added to the cell. What I need is a formula that will scan the column and count how many times a name appears in that column, and then give me a total for each name on a...