Search results for query: *

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

Can I use INDEX, MATCH, or OFFSET to return data from a table on another worksheet (in the same workbook)? For example: If I use these formulas (no particular combination) on Sheet1, can they lookup the data table if it's on Sheet2? I'm using INDEX(MATCH on Sheet1, with both the lookup values...

I forgot about that rule, thanks. I have a bunch of crap in B that would make every line unique. Thanks for your help. Your script works great. Regards, Candy

Ken's a freakin' genius! (re-working reports as we speak...) Thanks. Candy

(...I can't believe I'm actually providing help instead of asking for it!) This should seem simple, but to us non-wizards it can be frustrating (I'm an apprentice witch, by the way, thanks to the wizards' help!). I've done this a bunch of ways--some very involved to consider weekends and...

xlbo: It works! I love it and it's now in my Personal.xls "toolbox". Last question: Can the range (A1:B) be changed to two non-contiguous ranges? For example, if the data I want to filter is in columns A and C, instead of A and B. Many thanks, Candy