Search:

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

Page 1 of 5 1

1. Thread: Sum column using NOT equal to criteria

by danhendo888
Replies
4
Views
122

Sum column using NOT equal to criteria

https://1drv.ms/x/s!AvjBsEPEq12ngUm0YmMHEk1HGIPY?e=npLKjO

My data has account numbers and their corresponding \$ value
Trying to add the \$ value for those accounts which are not in the list in...
2. Thread: Text Formula to show commas only when > 999

by danhendo888
Replies
2
Views
69

Re: Text Formula to show commas only when > 999

That's perfect, thank you very much :)
3. Thread: Help with making two DATE cells equal

by danhendo888
Replies
3
Views
65

Re: Help with making two DATE cells equal

Ah yes, I understand now
That was the issue, thank you.

I was using the TEXT function to tidy up the final result but I also confused myself in the process :(
4. Thread: Text Formula to show commas only when > 999

by danhendo888
Replies
2
Views
69

Text Formula to show commas only when > 999

Suppose I have two numbers
8170.5999
618.111

Is there a formula that shows them as:
8,170
618

That is, show a comma when over 999
I used TEXT with "\$0,000" but this shows the comma even...
5. Thread: Help with making two DATE cells equal

by danhendo888
Replies
3
Views
65

Help with making two DATE cells equal

https://1drv.ms/x/s!AvjBsEPEq12ngUhA_FQ2c4n1ukg6?e=cF7u0s

Need help with making two date cells equal.
First cell is the date
Second cell is a formula

How do I make the formula to be equal to...

by danhendo888
Replies
4
Views
216

Re: SUMIFS formula picking up all values instead of criteria

Works beautifully, thank you very much Michael :)

by danhendo888
Replies
4
Views
216

Re: SUMIFS formula picking up all values instead of criteria

https://1drv.ms/x/s!AvjBsEPEq12ngUe3UvSuAukaSiqO?e=SlIJFL

Ok, I made my example clearer

If I filter by Not Due, 4 to 5 days etc, it calculates the correct total

But when I choose >365 days,...
8. Thread: Cannot see individual dates in Pivot Table (gets grouped to months automatically)

by danhendo888
Replies
1
Views
108

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...
9. Thread: Cannot filter by months in Pivot Table

by danhendo888
Replies
1
Views
90

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...
10. Thread: How to change "dates" to clean data

by danhendo888
Replies
1
Views
75

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...
11. Thread: SUMIFS and IF formula for this problem?

by danhendo888
Replies
1
Views
68

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..
12. Thread: SUMIFS and IF formula for this problem?

by danhendo888
Replies
1
Views
68

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)
13. Thread: Copy paste formulas to new sheet (absolute references)

by danhendo888
Replies
5
Views
134

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

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

by danhendo888
Replies
5
Views
134

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...
15. Thread: Copy paste formulas to new sheet (absolute references)

by danhendo888
Replies
5
Views
134

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...
16. Thread: SUMIFS multiple criteria cannot reference to a cell?

by danhendo888
Replies
5
Views
89

Re: SUMIFS multiple criteria cannot reference to a cell?

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

by danhendo888
Replies
5
Views
89

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
88

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

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

:)

by danhendo888
Replies
1
Views
88

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

by danhendo888
Replies
4
Views
216

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...
21. Thread: How to get my formula to produce a cell reference

by danhendo888
Replies
2
Views
141

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...
22. Thread: How to get my formula to produce a cell reference

by danhendo888
Replies
2
Views
141

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...
23. Thread: Power Query - Filter Table Based on Distinct Conditions from List

by danhendo888
Replies
1
Views
697

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...
24. Thread: How to fix these dates?

by danhendo888
Replies
2
Views
120

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...
25. Thread: How to group this in Pivot Tables

by danhendo888
Replies
3
Views
152

Re: How to group this in Pivot Tables

Beautiful. Thank you Sandy, I appreciate it :)
Results 1 to 25 of 113
Page 1 of 5 1