Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.05 seconds.

  1. Re: Match the same data from different rows

    Hi,

    Maybe not the most efficient solution but it works. Take a look t this and see if this helps:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color:...
  2. Re: Working hrs. Minus breaktime (8hrs/day) from range of days

    Hi,

    You can download the file from here
  3. Re: Working hrs. Minus breaktime (8hrs/day) from range of days

    Hi,

    Approach: divide working day in 2 shifts. First shift runs from 8 till 12 hrs, second shift runs from 13 till 17 hrs.
    So take a look at this and see if this helps:

    <b></b><table...
  4. Re: Return value based on latest date for entry

    Hi Tami,

    This is the first response to your question on MrExcel.

    In many cases we're able to help but to do so we require information to go on and we live by a set of rules and use guidelines...
  5. Replies
    11
    Views
    327

    Re: count values between dates

    Hi and welcome to MrExcel,

    try this:
    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  6. Re: How to get blank cell from IF formula

    Hi,

    This is a true problem and most experts will agree "excel can't solve this"
    Why?

    Anything you see on the excel sheet you've created is a formatted view of something you've entered.
    So a...
  7. Re: Count Once Based on Criteria and Another Column

    Hi,

    That's possible. In fact your formula sums the result of 3 countifs functions. I added the unique name in all 3 and by doing that it's possible one of the COUNTIFS comes up with 0.
    Because...
  8. Replies
    8
    Views
    310

    Re: New Analyst - New Problems

    Hi,

    This is the first response to your question on MrExcel.

    In many cases we're able to help but to do so we require information to go on and we live by a set of rules and use guidelines we...
  9. Re: Extract email messages from outlook to excel with attachment(s) information

    Hi,

    Can you describe your exact need a bit more extensive:
    1. is there always just 1 attachement or could there be multiple attachement;
    2. what's the type of information you want stored in the...
  10. Replies
    6
    Views
    493

    Re: Help regarding SUM formula

    Hi,

    Assuming you'll start in A1 on sheet B with the result of column D in sheet 1, try something like this:
    =SUM(OFFSET(Sheet1!$D$9,0,ROW()-1,21,1))

    As your range runs from 9 till 29 there are...
  11. Replies
    9
    Views
    115

    Re: If function

    Hi,

    Can you check if you are posting formula's with typo's within.
    I still can't recreate your error:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color:...
  12. Replies
    9
    Views
    115

    Re: If function

    Hi,

    I can't reproduce your results.
    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  13. Re: Count Once Based on Criteria and Another Column

    Hi,

    Try this

    `=SUM(sum(1/COUNTIFS(TT[Fiscal Law 301 CBT],"<"&TODAY()-1065,TT[Fiscal Law 301 CBT],">"&TODAY()-1095,TT[Fiscal Law In-Residence],"<"&TODAY()-1065,TT[Fiscal Law ...
  14. Re: IF Statement using Networkdays.intl formula

    Hi,

    try something like this:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  15. Re: If count formula counting hours threshold

    Hi,

    Change the formula to :

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  16. Re: Search for a value with two criterias

    Hi,

    Last attempt:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  17. Replies
    1
    Views
    130

    Re: Formula Help: Counting Blanks

    Hi,

    Try this:

    =SUMPRODUCT(--(FREQUENCY(IF(NOT(ISBLANK(A$2:CD$2)),"",COLUMN(A$2:CD$2)),IF(ISBLANK(A$2:CD$2),"",COLUMN(A$2:CD$2)))>=2))

    enter it as an array formula by using <CTRL-Shft-Enter>...
  18. Re: If count formula counting hours threshold

    Hi,

    Assuming you've got some columns scheduled for the days of the month starting at column M and the cell also contains the daynumber (ic from 1 till 31)
    check this and see if it helps:...
  19. Replies
    9
    Views
    262

    Re: Complex IF formula

    Special-K99 tyija1995

    Noticed it myself as well, but i used the OP's text
    Comparing list of criteria with text leaves an open interpretation but i think we got the OP on track by shortening his...
  20. Replies
    9
    Views
    262

    Re: Complex IF formula

    Hi,

    Check if this works for you:
    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  21. Replies
    3
    Views
    146

    Re: Round Value Based On Criteria

    additional if you want to pursue the INDEX/MATCH setup you've already started.

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
  22. Re: Change Worksheet Tab Names based on a cell reference on another worksheet

    As to my knowledge this can't be done without VBA.
    Take a look at this:https://www.extendoffice.com/documents/excel/2762-excel-dynamic-name-sheets-from-cell-values.html#dynamic
  23. Re: regarding recognition of date & after recognition value placement in the designated cell

    Hi,

    something like this:
    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  24. Replies
    3
    Views
    128

    Re: PLease i need help

    Hi,

    Not fond of getting private messages saying "
    hey man can you please help !"
    I'm supporting the forum if and when I am able to help.
    So please stop using private messages.

    Now your...
  25. Replies
    1
    Views
    93

    Re: COUNTIFS with Date Criteria Help

    Hi,

    Can you explain based on above example what your expected result is because I've tried to recreate your issue but I couldn't.
    <b></b><table cellpadding="2.5px" rules="all"...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4