# Search:

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

Page 1 of 5 1

1. ## Thread: Cannot see individual dates in Pivot Table (gets grouped to months automatically)

by danhendo888
Replies
1
Views
10

### Cannot see individual dates in Pivot Table (gets grouped to months automatically)

https://1drv.ms/x/s!AvjBsEPEq12ngUXYnGLP8pykEIRq?e=f3gY9X

How do I make this pivot table show the dates instead of grouping automatically to year and months?

I tried the Alt + D + P option, but...
2. ## Thread: Cannot filter by months in Pivot Table

by danhendo888
Replies
1
Views
39

### Cannot filter by months in Pivot Table

https://1drv.ms/x/s!AvjBsEPEq12ngURD4J_Yxbfrn7OV?e=ln2Olm

I have a sheet of data.
I converted it to a table. Loaded it into Power Query, unpivoted the dates columns, and then created a pivot...
3. ## Thread: How to change "dates" to clean data

by danhendo888
Replies
1
Views
53

### How to change "dates" to clean data

https://1drv.ms/x/s!AvjBsEPEq12ngUI4aV0PG-l-4gVM?e=pByejI

How do I convert the data in A1:B7 to the output in rows 12 and below (happy to use any method, pivot tables, power query etc)

(Purpose...
4. ## Thread: SUMIFS and IF formula for this problem?

by danhendo888
Replies
1
Views
44

### Re: SUMIFS and IF formula for this problem?

So that, for example, I can use formulas to then sum totals for, say, Jan to Mar or Jan to May..
5. ## Thread: SUMIFS and IF formula for this problem?

by danhendo888
Replies
1
Views
44

### SUMIFS and IF formula for this problem?

https://1drv.ms/x/s!AvjBsEPEq12ngUHobzEXQ8yvas2e?e=Otrz6s

I wish to unpivot the data but how would you convert the row of 2019.01, 2019.02 etc into dates?

(Using Power Query)
6. ## Thread: Copy paste formulas to new sheet (absolute references)

by danhendo888
Replies
5
Views
86

### Re: Copy paste formulas to new sheet (absolute references)

Ah I see, okay that's a good idea.
Thank you Trebor
7. ## Thread: Copy paste formulas to new sheet (absolute references)

by danhendo888
Replies
5
Views
86

### Re: Copy paste formulas to new sheet (absolute references)

My cell references are already absolute references.
So when I copy and paste them to a different sheet, it references the new sheet and not the original sheet.

Is there a way around this so that...
8. ## Thread: Copy paste formulas to new sheet (absolute references)

by danhendo888
Replies
5
Views
86

### Copy paste formulas to new sheet (absolute references)

https://1drv.ms/x/s!AvjBsEPEq12ngUDMrgxRZFuYzsgm?e=ghaRAa

Hi guys,

I need to copy/paste cells M1:V14 to Sheet2 but have the absolute references point to the cells from the original sheet

Is...
9. ## Thread: SUMIFS multiple criteria cannot reference to a cell?

by danhendo888
Replies
5
Views
60

### Re: SUMIFS multiple criteria cannot reference to a cell?

Thank you Nishant and Steve
Exactly what I was looking for :)
10. ## Thread: SUMIFS multiple criteria cannot reference to a cell?

by danhendo888
Replies
5
Views
60

### SUMIFS multiple criteria cannot reference to a cell?

https://1drv.ms/x/s!AvjBsEPEq12ngTWjooUrD2AsRCFa?e=BpSibC

I am trying to do a SUMIFS formula calculating the sales column if the country equals australia, india and china (actual data has more...

by danhendo888
Replies
1
Views
67

### Re: Help with dynamic (?) formula for adding values

Actually, I figured it out
I just used <= in the criteria

:)

by danhendo888
Replies
1
Views
67

### Help with dynamic (?) formula for adding values

https://1drv.ms/x/s!AvjBsEPEq12ngT4paIVYB5-Ol3Y2?e=XitD7z

Hi guys,

I have monthly revenue data that I want to add (YTD figure)

Need a formula whose output updates based on say if I choose...
13. ## Thread: SUMIFS formula picking up all values instead of criteria

by danhendo888
Replies
1
Views
107

### SUMIFS formula picking up all values instead of criteria

https://1drv.ms/x/s!AvjBsEPEq12ngT3R9p-e8rqgVZkN?e=k7e4yd

I have two columns.
First column =age of invoice
Second column = \$

I want to do SUMIFS for invoices > 365 days

E6 works fine for...
14. ## Thread: How to get my formula to produce a cell reference

by danhendo888
Replies
2
Views
108

### Re: How to get my formula to produce a cell reference

Ok I think I did it but I need to be able to link it to a cell in another sheet. My formula:

=(INDIRECT("A"&(MATCH('Summary by region'!A62,'PV Vol'!A:A,0)-1),1))

The above formula finds A7 in...
15. ## Thread: How to get my formula to produce a cell reference

by danhendo888
Replies
2
Views
108

### How to get my formula to produce a cell reference

Cell B1 in Sheet 3

=A(MATCH('Sheet1'!A55,'Sheet2'!A1:A28,0))

Suppose the MATCH formula produces the number 8
How do I make it so that the whole formula points to cell A8

Want to be able to...
16. ## Thread: Power Query - Filter Table Based on Distinct Conditions from List

by danhendo888
Replies
1
Views
627

### Power Query - Filter Table Based on Distinct Conditions from List

In this video, Mike uses a list to extract rows from the Start table that DO NOT include anything from the list.

Is the opposite possible?
If it's...
17. ## Thread: How to fix these dates?

by danhendo888
Replies
2
Views
105

### Re: How to fix these dates?

A2:A6 shows dates in MM/DD/YYYY format
A7:A9 is in DD/MM/YYYY format but Excel doesn't recognize them as dates.

When I sort, this is the output.
Looking for...
18. ## Thread: How to group this in Pivot Tables

by danhendo888
Replies
3
Views
132

### Re: How to group this in Pivot Tables

Beautiful. Thank you Sandy, I appreciate it :)
19. ## Thread: How to fix these dates?

by danhendo888
Replies
2
Views
105

### How to fix these dates?

https://1drv.ms/x/s!AvjBsEPEq12ngTwwKMwIFJo5_Tk7?e=J87rl6

How best could I go about fixing this column so that it shows dates.
The bottom half is in text format.
Thanks all.

by danhendo888
Replies
0
Views
49

### Adding cells in Pivot Table

https://1drv.ms/x/s!AvjBsEPEq12ngTsi8XTPb5NMJ1_h?e=YIGtSL

I wish to add the total for B and C in the Pivot Table like in cell D6.

Suppose I update my PV and more data is added.

How do I make...
21. ## Thread: How to group this in Pivot Tables

by danhendo888
Replies
3
Views
132

### How to group this in Pivot Tables

https://1drv.ms/x/s!AvjBsEPEq12ngTpjIV0Ri5AcMKZa?e=0sU8cn

I have a table of data.
First column = company names.
Other columns = invoice amount aging by days
E.g. column B = 1 - 010 means...
22. ## Thread: Is this merge possible in PQ?

by danhendo888
Replies
1
Views
526

### Is this merge possible in PQ?

Hey folks,
Suppose I create two queries for the two tables in my spreadsheet
https://1drv.ms/x/s!AvjBsEPEq12ngTmYWfZW_bAjU4w7?e=9d2PBI

Is it possible to somehow merge them as per my example?
23. ## Thread: Merging two queries in Power Query: find "M00123" using lookup value of "123"

by danhendo888
Replies
5
Views
861

### Re: Merging two queries in Power Query: find "M00123" using lookup value of "123"

It is what I want but I'm trying to understand the functions. You combined several functions into one applied step. That's great, but as a beginner, kinda hard to learn from it and apply it/practise...
24. ## Thread: How to organise this data (Year, Vendor, expenses)

by danhendo888
Replies
8
Views
260

### Re: How to organise this data (Year, Vendor, expenses)

No, I mean how did you get your output in your post 4 .
What you described is for post 5 , which shows top/bottom 10 vendors filtered by grand total.

Your output in post 4 shows top/bottom 10...
25. ## Thread: Merging two queries in Power Query: find "M00123" using lookup value of "123"

by danhendo888
Replies
5
Views
861

### Re: Merging two queries in Power Query: find "M00123" using lookup value of "123"

Have updated workbook in the link with Sandy's code

In the Merge query, the last Applied Step has the below code:

=...
Results 1 to 25 of 106
Page 1 of 5 1