Search results

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

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

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

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

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