Search:

Type: Posts; User: seguin85; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    3
    Views
    82

    Re: Warning about duplicate entries

    Great! That worked perfectly!
  2. Replies
    3
    Views
    82

    Warning about duplicate entries

    Hi,

    I have a table that we use to help schedule employees and want some type of warning if we double book them. It is setup as such:

    <tbody>

    A
    B
    C
    D
  3. Re: Nested IF statements combined with Tenure Length

    Can you provide an example of how the data is setup? One way of figuring out how long their tenure is would be: =today()-A2, where A2 is the start date.
  4. Replies
    3
    Views
    270

    Re: Macro is Adding extra columns

    One thing you can to to see where it is duplicating the data is to hit F8 on your code. It will scroll through the code one line at a time, instead of running through the entire code. This way you...
  5. Replies
    6
    Views
    156

    Re: Non Array Summary

    Hi Rick,

    I would be willing to run macros, I didn't even think of that as a solution. I do have some experience so I imagine I can get your code to work. This way whenever I dump their data into...
  6. Replies
    6
    Views
    156

    Re: Non Array Summary

    Aladin: I don't have minifs and maxifs...

    63falcon and DRSteele: Is there a way to determine what method would use the least amount of resources? This is going to be a file I will be using a lot...
  7. Replies
    6
    Views
    156

    Non Array Summary

    Hi,

    I get a data summary from another department and I am trying to pull certain data from it.

    It is setup similar to the following:


    <tbody>

    A
  8. Replies
    5
    Views
    127

    Re: Odd Matching Question

    Thanks Eric!

    It worked perfect!
  9. Replies
    5
    Views
    127

    Odd Matching Question

    Hi,

    I have some data setup similar to this:


    <tbody>
    Customer
    Region
    Program
    Unique Program
  10. Replies
    5
    Views
    151

    Re: Summarize Weeks into Month

    I've never even heard of the aggregate function. How does it affect the performance? I have to use it in a bunch of areas throughout the file and don't want it to slow down too much.
  11. Replies
    5
    Views
    151

    Summarize Weeks into Month

    Hi All,

    I have some data by week set up similar to:

    <tbody>

    5/22/17
    5/29/17
    6/5/17
    6/12/17
  12. Replies
    12
    Views
    334

    Re: Advanced Filtering

    Can't the date be my header? You think I should set up my data like:

    <tbody>
    Name
    #
    Date
    Type


    John
  13. Replies
    12
    Views
    334

    Re: Advanced Filtering

    Thanks, I used the helper column (great idea and very easy to implement). I added a macro and attached it to a button to I don't have to scroll all the way to the right of the page to filter by the...
  14. Replies
    12
    Views
    334

    Re: Advanced Filtering

    Thanks, I'm going to try the advanced filter first, then if it doesn't get to what I need I will try the macro.

    Thanks so far.
  15. Replies
    12
    Views
    334

    Re: Advanced Filtering

    Oh sorry yes, columns N-JA.

    Here is an example of my data:


    <tbody>
  16. Replies
    12
    Views
    334

    Advanced Filtering

    Hi All,

    I have a sheet with names and other personal information from columns B-M.

    I have dates for each day from rows N-JA.

    What I want is to be able to set up a filter that will show if a...
  17. Replies
    4
    Views
    201

    Re: Number Formatting Problem

    Thanks Rick!

    That worked perfect!
  18. Replies
    4
    Views
    201

    Re: Number Formatting Problem

    If the value is greater than 0 but less than 100,000 it also shows up as blank.

    I'd like it to show up as $##.#K
  19. Replies
    4
    Views
    201

    Number Formatting Problem

    Hi,

    I have written the following number formatting code for a graph:
    [>1000000]$0.00,,"M";[>100000]$0,"K";$0.0,"K"

    Where if it is over 1 million it will give two decimal place, if it if over...
  20. Re: scheduling tool using SUMPRODUCT(SUMIF()) with arrays of different sizes

    Would adding another column on sheet 1 be a possibility? For example in column C you could have duration and then do a lookup formula to bring in the duration of each code. Then on sheet 3 you could...
  21. Re: Prevent Code from running on cell change

    Awesome! Thanks! I just needed to add the enable events to my code.
  22. Prevent Code from running on cell change

    Hi All,

    I have the following code that works great:


    Private Sub Worksheet_Change(ByVal target As Range)
    If Not Intersect(target, Range("M21:M6000")) Is Nothing Then

    On Error Resume Next
  23. Re: Last Day of the Month Conditional formatting

    Assuming the 19th is in cell B1, this should work as a formula in conditional formatting:

    =DAY(B1)>DAY(C1)
  24. Re: Can you update formatting on a master sheet from a formatting change on a related sheet?

    I have a workaround but may not be suitable for what your needs require. Anyways, what this code will do is always select the "Year End" page when you select any of the monthly sheets. So when you...
  25. Re: Match cell values to column range for two respective columns

    Naomi,

    Assuming your data starts in cell A2, try this in cell E2:

    =IF(SUMPRODUCT(--((A2&B2)=($C$2:$C$9&$D$2:$D$9)))>0,"active","inactive")

    and drag down column E. $C$2:$C$100&$D$2:$D$100...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4