Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    1
    Views
    251

    Re: Unfilter only the active column

    Hi,

    Try this:


    <code>Sub RemoveActiveFilter()

    Dim FilterNum As Long
    Dim FilterRange As Range
  2. Re: Year to Date Totals - Automatic formula adjusting

    Hi,

    Two options, try which one works best for you.

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

    Re: very hidden sheets add-in

    Hi,

    take a look at this and see if this helps https://www.excelcise.org/how-to-listpopulate-sheet-names-to-a-listbox-on-a-userform-vba/
  4. Re: double click a cell with time as a value

    Hi,

    This effect is caused by standard features of Excel and (unfortunately or not) there's not a whole lot you can do about it. However it's not a calculation and it didn't ADD anything. Excel...
  5. Re: time calculation on working hours less weekend

    Hi,

    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: Match Date to Nearest Month + Match with text field

    Added to post #4 .

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  7. Re: Match Date to Nearest Month + Match with text field

    Hi Peter_SSs

    Thoughts are similar but i didn't change the request of the OP being "nearest date". If OP added "past nearest date" or had intention to ask but forgot to mention it, my solution...
  8. Re: Need to find is value is between multiple ranges

    With Peter_SSs suggestion (make sure you check his assumption of chronologically sorted dates) just change the range in the VLOOKUP.
    Following my suggestion:

    <b></b><table cellpadding="2.5px"...
  9. Re: Match Date to Nearest Month + Match with text field

    Hi,

    I can't match all your desired results for the obvious reason being I don't see 201806 in any of your table's.
    Take a look at this:

    <b></b><table cellpadding="2.5px" rules="all"...
  10. Re: Need to find is value is between multiple ranges

    Hi,

    Take a look at this. The result of the formula will return the number of the range in which the date falls in between. 0 as a result will mean no range applies.

    <b></b><table...
  11. Replies
    4
    Views
    1,468

    Re: =UNIQUE coming to O365?

    Hi,

    As to my knowledge the UNIQUE function is one of the new beta features, and not even available to all office insiders but a subset of Office Insiders at this time.
    Microsoft announced last...
  12. Re: Return result for 1st, 2nd, and 3rd Row

    Hi,

    In the way you've entered the formula it will not default the data but it will just continue to the next salesrep.
    This can be solved to limit the Index source just to the Salesrep you're...
  13. Re: How can I look up the value in the next cell?

    hI,

    You've posted this question with the hope of getting an answer you can use.
    Unfortunately you gave us not enough information to go on and by doing that, made it impossible for us to answer...
  14. Replies
    2
    Views
    136

    Re: Index Match and Sums

    Hi and welcome to MrExcel,

    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;...
  15. Replies
    1
    Views
    96

    Re: Countif formula help

    Hi,

    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:...
  16. 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:...
  17. Re: Working hrs. Minus breaktime (8hrs/day) from range of days

    Hi,

    You can download the file from here
  18. 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...
  19. 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...
  20. Replies
    11
    Views
    405

    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:...
  21. 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...
  22. 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...
  23. Replies
    8
    Views
    373

    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...
  24. 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...
  25. Replies
    6
    Views
    541

    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...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4