Recent content by CandyS

How can I set up my combo box to show only unique values in the drop-down list instead of all the repeating values? Thanks, Candy

That's a huge help--thanks Ken! Regards, Candy

My goodnes--another Wizard! Hi Jedi! Nice too see you again, Loomah! Thanks, Most Able Wizards--this is really good stuff. I appreciate your valuable help! One last request--sorry I forgot about this: I need to insert a formula in the cell adjacent to each added text string (col. B), so if...

I want to be able to insert four rows underneath every row with data in Column A, and then have it enter text in the leftmost cell (col.A) of each new row. I found some simple code to add rows, one by one, but that'll take me forever (the list is probably 200 rows long). For example, Here's...

Here's another good resource I found for creating dynamic charts: http://www.tushar-mehta.com/index.html?http://www.tushar-mehta.com/excel/newsgroC:\PROGRA~1\INTERN~1\iexplore.exe Candy

Wow--great stuff, x and zath. I'll give each a shot because I can find other reports to use your recommended solutions. Thanks again! Regards, Candy

PS. xlbo--thanks again for the first formula (used in the example above)! Candy

I think this involves an OFFSET function but I'm not certain: Here's the scenario: Column A will contain X's (marks items to be taken off list) Column B contains codes: There are three of these, and there will be many of each in the column: I'll name this range "Range" (how...

xlbo: It works! Thanks so much for your valuable help! Regards, Candy

Great question and great solutions--thanks guys! Regards, Candy

I need to create an array formula to do the following: The formula will be in cell A2, and the range is named "ST" (to simplify "site type") I need the formula to read the range and multiply the occurences of the site types by their respective rates, and sum: For example...

Thanks, dyarwood: The end user will be confused if I include the rate and totals on the same sheet. Yeah, it's goofy, but it's happened before! Thanks, Candy

I'm sorry...I should have considered this... The values "1", "2", "3" and "4" are text values (ie. "Chicago", "New York", "Tampa", "Miami"). I used numberic values to simplify the example (but it ended up...

I can do this using a single variable, but, alas, putting multiple variables together in a formula coherently is eluding me... I have to calculate items in a list based on variable rates: In plain language, this is what I need to do: Assuming the list is in Column A, I need the formula in...

Thanks, Skip. I'll give it a(another) shot! Regards, Candy