# Search:

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

Page 1 of 6 1

1. ## Thread: Match the same data from different rows

by jorismoerings
Replies
5
Views
183

### 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:

2. ## Thread: Working hrs. Minus breaktime (8hrs/day) from range of days

by jorismoerings
Replies
5
Views
212

Hi,

3. ## Thread: Working hrs. Minus breaktime (8hrs/day) from range of days

by jorismoerings
Replies
5
Views
212

### 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. ## Thread: Return value based on latest date for entry

by jorismoerings
Replies
1
Views
114

### 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. ## Thread: count values between dates

by jorismoerings
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. ## Thread: How to get blank cell from IF formula

by jorismoerings
Replies
4
Views
140

### 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. ## Thread: Count Once Based on Criteria and Another Column

by jorismoerings
Replies
4
Views
166

### 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. ## Thread: New Analyst - New Problems

by jorismoerings
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. ## Thread: Extract email messages from outlook to excel with attachment(s) information

by jorismoerings
Replies
3
Views
52

### 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. ## Thread: Help regarding SUM formula

by jorismoerings
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...

by jorismoerings
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:

by jorismoerings
Replies
9
Views
115

### Re: If function

Hi,

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
13. ## Thread: Count Once Based on Criteria and Another Column

by jorismoerings
Replies
4
Views
166

### 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. ## Thread: IF Statement using Networkdays.intl formula

by jorismoerings
Replies
2
Views
174

### 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. ## Thread: If count formula counting hours threshold

by jorismoerings
Replies
3
Views
173

### 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. ## Thread: Search for a value with two criterias

by jorismoerings
Replies
7
Views
151

### 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. ## Thread: Formula Help: Counting Blanks

by jorismoerings
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. ## Thread: If count formula counting hours threshold

by jorismoerings
Replies
3
Views
173

### 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. ## Thread: Complex IF formula

by jorismoerings
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. ## Thread: Complex IF formula

by jorismoerings
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. ## Thread: Round Value Based On Criteria

by jorismoerings
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. ## Thread: Change Worksheet Tab Names based on a cell reference on another worksheet

by jorismoerings
Replies
4
Views
373

### 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. ## Thread: regarding recognition of date & after recognition value placement in the designated cell

by jorismoerings
Replies
3
Views
99

### 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:...

by jorismoerings
Replies
3
Views
128

### Re: PLease i need help

Hi,

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

Now your...
25. ## Thread: COUNTIFS with Date Criteria Help

by jorismoerings
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.