Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    7
    Views
    180

    Re: INDEX and MATCH Function

    I am writing this for a macro. It is part of the coding. Should I be looking at this different?
  2. Replies
    7
    Views
    180

    Re: INDEX and MATCH Function

    That worked too!!!
  3. Replies
    7
    Views
    180

    Re: INDEX and MATCH Function

    YAHOO!! That worked. Now can I incorporate this into a loop? I want the loop to go through all the employee numbers and corresponding dates looking for the Employee number and the date ranges for...
  4. Replies
    7
    Views
    180

    INDEX and MATCH Function

    I am trying to use the INDEX and MATCH function to look up a date within a range to bring back a annual salary amount. Here is the LOOKUP table which is on a sperate tab in the workbook call...
  5. Re: Search for date in Range for each Employee VBA

    I think I may need a triple VLOOKUP? Look up the employee number, then look up the date in the date ranges, and bring back the corresponding annual salary?
  6. Search for date in Range for each Employee VBA

    I have 850 employees and I need to calculate an estimated costs for them. I need to be able to loop through the employees, for each employee, look up their annual salary based on date ranges and...
  7. Replies
    7
    Views
    102

    Re: Countif vba???

    You absolutely rock, Fluff!!!!!! If worked perfectly!!!! Thank you so much!!!
  8. Replies
    7
    Views
    102

    Re: Countif vba???

    I tried your formula above. OK. Perhaps I give you a bit of detail. I need to pro-rate a cost based per EE number and the same date range (which is variable). So if any employee has only one date...
  9. Replies
    7
    Views
    102

    Re: Countif vba???

    That worked! Now to add another level. For each employee I need to calculate the number of times a date shows up with their employee number. I keep getting zero when I should get an answer of...
  10. Replies
    7
    Views
    102

    Countif vba???

    I am trying to find a away to count how may times an employee number shows in Column F and results in Column U. I just can't get it to work with a formula let alone a VBA! I need the information to...
  11. Re: VBA Coding to select cell under Headings when using filter

    No, I printed it off. I got it to work. Thanks for you help!
  12. Re: VBA Coding to select cell under Headings when using filter

    I am getting a compile Error:

    Block If without End if. I have tried putting the end if in several places with no success.
  13. Re: VBA Coding to select cell under Headings when using filter

    Thank you!!!!
  14. VBA Coding to select cell under Headings when using filter

    I am using a filter to show all "BB" transactions and delete the rest of the rows that are not "BB". Here is what I recorded when I did it:

    'Set autofilter on Column E for "BB" and delete all...
  15. If ...else if statement using cut and paste to another WS

    I am trying to create a If...then....else if statement loop with a cut and paste function to another worksheet. I have one master data worksheet "CAS_PPDR" and I have a column E that has the GL...
  16. Re: Error: We Cannot Convert a value of Type Function to Type list

    I will give it a try!
  17. Re: Error: We Cannot Convert a value of Type Function to Type list

    I need the information to stay in table format unfortunately :(
  18. Replies
    2
    Views
    571

    Re: Lopp through table like macro????

    I will give it a try!!! Thanks!!!!
  19. Replies
    2
    Views
    571

    Lopp through table like macro????

    I am trying to figure out if you can loop through data in the table in power query. Here is my scenario. I have employees who receive a bilingual bonus (BB). This amount gets charged to a cost...
  20. Error: We Cannot Convert a value of Type Function to Type list

    I have been trying to create a function to calculate the number of working days (including holidays). I found instructions on how to create fnNetworkdays but I am getting the following error when I...
  21. Replies
    3
    Views
    555

    Re: Calculation of Net Working days

    WOW! The coding is way over my head!! Also, I want to include holidays.
  22. Replies
    3
    Views
    555

    Calculation of Net Working days

    Is there a way to calculate the number of work days between two days? If so, how? Very new to Power Query....
  23. Re: Custom or Conditional Column to Copy data to Null Cells

    Yes. I didn't realize it had that functionality. New to Power Query
  24. Re: Custom or Conditional Column to Copy data to Null Cells

    I figured it out. I am trying to make this harder than it needs to be :)
  25. Custom or Conditional Column to Copy data to Null Cells

    I am trying to go through a column (CC) and when it finds a number (such as 120199999), I want power query to copy that number to the "Null" areas above it then find the next number in the column and...
Results 1 to 25 of 133
Page 1 of 6 1 2 3 4