Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    5
    Views
    165

    Re: Compare two worksheets

    Ya, that was the first think my eyes catched. Nice work.
  2. Replies
    4
    Views
    116

    Re: V look up help needed

    Nice! I'm glad I could help!
  3. Re: Copying data from one workbook into another workbook based on specific data in the first workbook

    An example would be great, at least for me...
    However, instead for searching for updates, can you copy all over again? In other words, every time you run the code, you are going to copy all cells...
  4. Replies
    4
    Views
    116

    Re: V look up help needed

    =VLOOKUP($A$2,Sheet2!$A$2:$C$10,2,FALSE) - Job Titles

    =VLOOKUP($A$2,Sheet2!$A$2:$C$10,3,FALSE) - University

    Sheet1
    <tbody>
    Description
    Job Title
    University
  5. Re: Adding Copied Data into next row in Table

    How different?
    The data that you want to copy isn't always on the columns J to P?
    Because on the 3 subs that you presented, the range was always the same "J10:P109". :)
  6. Re: Adding Copied Data into next row in Table

    I think the easiest solution is to allow the user to write the pages like:
    A B
    Initial : 2
    Final : 3

    So the sheets 2 and 3 would be the ones that was copied.
    Then I would put every...
  7. Replies
    10
    Views
    316

    Re: IF(AND with IF(OR

    I've tryed mine, and works perfectly. One True gives "TRUE", 3 Falses gives "FALSE".
  8. Replies
    10
    Views
    316

    Re: IF(AND with IF(OR

    =IF(OR(A10="True",B10="True",C10="True"),"TRUE",IF(AND(A10="False",B10="False",C10="False"),"FALSE","Unknown"))

    Is that?
  9. Re: Complicated Match/Lookup in between dates formula?

    Nice! Didn't know! Always learning something! Thank you!
  10. Replies
    18
    Views
    619

    Re: SUMIF based upon worksheet name?

    Let's see if this is what you want.
    I've created 3 sheets, "Total", "July", "June".

    https://i.ibb.co/rMQhxtc/july-sheet.jpg
    https://i.ibb.co/XbXWqkH/june-sheet.jpg...
  11. Re: Complicated Match/Lookup in between dates formula?

    Couldn't download because asks for a login, although I think DanteAmor will find a solution for you.
  12. Re: Complicated Match/Lookup in between dates formula?

    So the "*" works as entering another IF in the 'True' section?
  13. Replies
    10
    Views
    458

    Re: count total among several tables

    Hi there,

    at first sight it will be much easier if you convert the last table into something like this:


    <tbody>

    Off target
    Off target
    Off target
  14. Re: Complicated Match/Lookup in between dates formula?

    =sum(if($e$2:$e$5=l2;if(k2>$c$2:$c$5;if(k2<$d$2:$d$5;j2;index($b$2:$b$5;match(min(abs($c$2:$c$5-k2));abs($c$2:$c$5-k2);0)));index($b$2:$b$5;match(min(abs($c$2:c$5-k2));abs($c$2:$c$5-k2);0)));"no"))...
  15. Re: Complicated Match/Lookup in between dates formula?

    Sorry, didn't see your response. Perhaps yours is better than mine. But they are very similar! :)
  16. Re: Complicated Match/Lookup in between dates formula?

    https://i.ibb.co/Y87JRRF/help-tables.jpg

    ...
Results 1 to 16 of 16