# Search:

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

Page 1 of 6 1

1. ## Thread: Can MDX be used for this?

by Matty
Replies
1
Views
563

### Re: Can MDX be used for this?

Hi,

Update...

I've managed to write a Calculated Measure that returns the following:

<tbody>
Short Month
A
2. ## Thread: Can MDX be used for this?

by Matty
Replies
1
Views
563

### Can MDX be used for this?

Hi Team,

I have a Pivot Table report linked up to a data model held in the Power BI Service. OLAP is used for fast querying.

I now need to present some of the data in a slightly different way...
3. ## Thread: Formula to calculate how many weekend days

by Matty
Replies
15
Views
388

### Re: Formula to calculate how many weekend days

This thread is a duplicate of the following:

https://www.mrexcel.com/forum/excel-questions/1101892-missing-days-without-weekends.html

treeppm - Please keep questions of the same nature within...
4. ## Thread: Missing days with and without weekends

by Matty
Replies
22
Views
498

### Re: Missing days with and without weekends

Given the above example, I work out that there are 4 weekend days in that range:

<tbody>
Date
Day
Weekend Days In Date Range

09/04/2019
5. ## Thread: SUM and VLOOKUP (I think!)

by Matty
Replies
9
Views
366

### Re: SUM and VLOOKUP (I think!)

Excel Regional Settings mean that some symbols don't travel too well.

Here's dazkangel's formula formatted in a way that hopefully works for you:

...

by Matty
Replies
5
Views
238

Matty

by Matty
Replies
5
Views
238

### Re: Delaying production

Hi,

Assuming your data resides in range A1:D13, try:

=IF(ROWS(D\$2:D2)<=C\$2,0,INDEX(B\$2:B\$13,ROWS(D\$2:D2)-C\$2))

In D2, copied down.

Cheers,
8. ## Thread: Matching given month to a column containing the same month

by Matty
Replies
2
Views
141

### Re: Matching given month to a column containing the same month

Hi, and welcome to MrExcel.

That doesn't give us a lot to go on. Could you provide a small mock up and post it? You can use one of the HTML makers here to do that:
...
9. ## Thread: Countif in power bi

by Matty
Replies
14
Views
2,519

### Re: Countif in power bi

Hi,

Have a look at Ken's article here:

https://www.excelguru.ca/blog/2018/06/27/number-rows-by-group-using-power-query/

Cheers,

Matty
10. ## Thread: Expanded Table for Many To Many Relationship?

by Matty
Replies
4
Views
753

### Re: Expanded Table for Many To Many Relationship?

Hi Mike,

I suspect the only way to make this model work would be to create a single table in Power Query that brings BridgeAuthorBooks and dAuthors together so that you have one table with the...
11. ## Thread: Index and match vertical and horizontal data

by Matty
Replies
6
Views
300

### Re: Index and match vertical and horizontal data

That is a fairly big data set for Excel to cope with.

In the absence of a proper database, e.g. SQL Server or Access, consider using Power Query instead. You could then carry out any data...

by Matty
Replies
4
Views
187

### Re: help with If statement

Hi,

If O33, P33, V33 and W33 are all numeric, try:

=IF(AND(C3<>"",Q2<>"",STDEV(O33,P33,V33,W33)=0),SUM(Q11:Q31),"ERROR")

Else:

by Matty
Replies
4
Views
187

### Re: help with If statement

Hi,

What does this mean:

"O33 needs to be equal to P33, V33 and W33"

Is it that O33 must equal the sum of P33 + V33 + W33? Or O33 = P33 and O33 = V33 and O33 = W33?

Matty
14. ## Thread: How to extract specific data from a cell

by Matty
Replies
19
Views
582

### Re: How to extract specific data from a cell

Hi,

Can you provide a few examples - including the desired results - so that we can test options?

Cheers,

Matty
15. ## Thread: Vlookup between 2 dates ?

by Matty
Replies
7
Views
183

### Re: How can this vlookup be achieved between 2 dates ?

Hi,

Given the following exists across range A1:J5:

Name
StartDate
EndDate
16. ## Thread: Index and match vertical and horizontal data

by Matty
Replies
6
Views
300

### Re: Index and match vertical and horizontal data

Hi,

Below set up across A1:I7 for illustrative purposes only. Please change ranges to suit your actual data set.

<tbody>
productID
18/05/2019
17/05/2019
16/05/2019
17. ## Thread: 2nd Occurrence index match on dates

by Matty
Replies
4
Views
166

### Re: 2nd Occurrence index match on dates

Hi,

Based on your data residing in range A1:I2, try:

=INDEX(B1:I1,MATCH(2,1/(B2:I2<>0))+1)

Array entered, i.e. with CTRL+SHIFT+ENTER.

Note: This solution will always return the first...
18. ## Thread: Formula to calculate forward coverage

by Matty
Replies
7
Views
8,287

### Re: Formula to calculate forward coverage

Welcome to Mr Excel,

How is your data laid out? If in weekly buckets, you can just multiple the result of the formula by 7 to get days.

Cheers,

Matty
19. ## Thread: Web query error handling...

by Matty
Replies
0
Views
117

### Web query error handling...

Hi Team,

I have the following code that returns data from the web (via Power Query):

Application.ScreenUpdating = False
If CheckBox1.Value = True Then
...
20. ## Thread: IF Statement - Help

by Matty
Replies
7
Views
267

### Re: IF Statement - Help

Note that the curly brackets {} are superfluous in the above formula - they're only needed when passing an array, i.e. more than one value.

Matty
21. ## Thread: IF Statement - Help

by Matty
Replies
7
Views
267

### Re: IF Statement - Help

Sounds like:

=IF(F45=0,"",IF(D8="Company","321/783",IF(AND(D8="Partnership",F45>0),F14,IF(AND(D8="Partnership",F45<0),I14,IF(AND(OR(D8<>{"Company","Partnership"}),F45>0),"511/001","521/001")))))...
22. ## Thread: Counting unique values

by Matty
Replies
4
Views
317

### Re: Counting unique values

Hi,

I'd do something like this...

Sheet2 (A1:D10):

<tbody>
IDs
Description
23. ## Thread: IF Statement - Help

by Matty
Replies
7
Views
267

### Re: IF Statement - Help

Hi,

Your formula looks, syntactically, a little weird.

Could you share a short example to illustrate what you're trying to do?

Matty
24. ## Thread: Trim/Substitute but.. also, replace?

by Matty
Replies
4
Views
181

### Re: Trim/Substitute but.. also, replace?

Unless I'm missing something, isn't this just:

=SUBSTITUTE(A1,"Network Bridge","NetworkBridge")

Matty
25. ## Thread: Trim/Substitute but.. also, replace?

by Matty
Replies
4
Views
181

### Re: Trim/Substitute but.. also, replace?

Can you provide a couple of examples of the before and after (desired) result?

Matty
Results 1 to 25 of 150
Page 1 of 6 1