• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. I

    Count unique dates within given period with multiple criteria

    Thanks Narayan, this is exactly what I needed. I expanded it to include [Counted]: =SUM(IF((customer_time[Extensions]=M$1)*(customer_time[Counted]=1)*(customer_time[Date Int]>=mtd_start)*(customer_time[Date...
  2. I

    Count unique dates within given period with multiple criteria

    Thanks Faseeh. This is a good start, but I think it counts the total number of dates that meet the criteria but doesn't narrow it down to unique dates. I updated the example doc w/ a pivot table that I believe calculates the correct answers (11 for L2, 8 for M2, 0 for N2). Is there a way to...
  3. I

    Count unique dates within given period with multiple criteria

    I know there are quite a few post on this but I haven't been able to get any of the solutions to work. I have a table of call logs w/ the employee extensions (customer time[extensions]) in one column and dates (customer_time[date int]) in another (converted to an integer so the time data is...
  4. I

    In what month will we earn a profit?

    We're paid an upfront annual commission (avg comm/deal) for each client. On month 13, we start to receive a monthly commission (avg comm/deal / 12) for each client. We also have certain costs associated with obtaining each client (Total cost/deal). Each of these is variable & can be changed w/i...
  5. I

    Debugging custom vba function

    I fixed 5 sheets in like 1/2 an hour thanks to your info! After puzzling over the code for a week, it *was* a little vindicating to find that the error wasn't in my code but in the data itself. Ok, that makes sense. I was confused that the watch value didn't change depending on whether was...
  6. I

    Debugging custom vba function

    Amazing! ? united.name gave an error. The sheet was named "United National" with the object name as "United_National" so when I changed both to just "United" it worked. Thanks a million not just for helping me solve this problem but teaching me what to look for so I can solve future issues...
  7. I

    Debugging custom vba function

    Wow, this info is awesome. Ok, using the immediate window `? rate_str' shows the correct value right up until Dim Area_range1 As Range, Area_range2 As Range Set Area_range1 = United.Range("United_Area_1") Set Area_range2 = United.Range("United_Area_2") 'Now we search the...
  8. I

    Debugging custom vba function

    I hope you will do me the favor of giving me another tip on debugging... I set up some watches (any command that was rate_str = ) on another similar file & experimented with setting the breakpoint. When I set it at rate_str = rate_str & "_" & Tobacco the watch values are False (no...
  9. I

    Debugging custom vba function

    Asa: First, thank you a million times for confirming I'm not crazy. I've been tweaking that code for a week & I was sure it looked okay. I can't believe something as simple as a dash is responsible for nearly driving me insane! The info on the Constitution sheet is usually copied or exported...
  10. I

    Debugging custom vba function

    It just returns N/A on the main sheet (the proposal page). It should return the applicable rate based on age/zip/etc like the other functions.
  11. I

    Debugging custom vba function

    I'm having trouble with a custom function that pulls an amount from a worksheet based on factors entered on the main sheet (age, zip, etc). I've updated these on several different workbooks(we have one for each state) before with no problem but this week none of the ones I've added seem to work...
  12. I

    Create a list based on criteria in another list

    Thanks for two excellent solutions. I'm just starting to learn both pivottables & VBA so I will have fun playing with these a bit. Thanks again!
  13. I

    Create a list based on criteria in another list

    I apologize in advance as I suspect this has been answered before but I'm just not searching for the correct terms. I have a table in worksheet with a list of policy information (status, account #, name, date, etc). In a second worksheet, I'd like to autogenerate list of all accounts that have...
Back
Top