Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. 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. Re: Text Formula to show commas only when > 999

    That's perfect, thank you very much :)
  3. 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. 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. 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...
  6. Re: SUMIFS formula picking up all values instead of criteria

    Works beautifully, thank you very much Michael :)
  7. 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. 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. 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. 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. 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. 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. Re: Copy paste formulas to new sheet (absolute references)

    Ah I see, okay that's a good idea.
    Thank you Trebor
  14. 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. 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. Re: SUMIFS multiple criteria cannot reference to a cell?

    Thank you Nishant and Steve
    Exactly what I was looking for :)
  17. 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...
  18. Re: Help with dynamic (?) formula for adding values

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

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

    https://www.youtube.com/watch?v=fRd6wYkfDUQ

    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. Replies
    2
    Views
    121

    Re: How to fix these dates?

    I uploaded the spreadsheet again.

    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. Replies
    3
    Views
    159

    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 2 3 4