Replies

someone told me you need too use Latin Square formulas. Don’t know what those are

I have about 20 charts on 7 different sheets that reference the 2011DataPull worksheet within the same excel file. I need to change them all to reference a new worksheet (but the exact same ranges) named 2012DataPull. Thanks for the help – Joan

I’ve tried Alt-F9 keys but nothing happens. When I use Replace and enter 2011DataPull for find and enter 2012DataPull in the replace box and I select workbook, it doesn’t search within the data source for each bar chart or pie chart in the workbook. It only changes my paste links not the data source of the chart objects.

wow :o:
fantastic

I’m wondering how to do the same thing. Did you ever find out? Thanks

Works great! Many Thanks

Sorry, I’m not quite sure how to use this formula. I’m uploading a file and put the trigger cell in A1. The formula is in F3. Thank you for the help.

ok, thanks for the explanation.

Now, I have the max formula working and then i tried to copy it to the next row and change max to MIN. The help screen says to use the fx bar but it doesn’t show the word “MAX”, it starts with the IF.

I did click the fx and the braces disappeared and i changed MAX to MIN and then hit ctl+shift+enter but it changed both the formulas to MIN. I have the max formula in B6 and want the min formula in B7.

thanks for the formula Hans. Does the “*” between the 2 criteria mean “and”, is there an “or” operator?

Thanks for the formulas. Is there a way to deal with duplicates using formulas? Thanks

thanks, worked great!

ahhh, perfecto!

actually, the ugly way is what I need. A macro won’t work for my purposes. Thanks – Joan

Is there a way to do it with formulas? I need to do several like this that will automatically update. Thanks for the help.

Fantastic! Thanks so much