Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    4
    Views
    109

    Re: Date Formula Support Needed

    there are more function like:


    Date.IsInPreviousDay
    Date.IsInPreviousMonth
    Date.IsInPreviousNDays
    Date.IsInPreviousNMonths
    Date.IsInPreviousNQuarters
    Date.IsInPreviousNWeeks
    ...
  2. Re: Transpose every 2 columns into new row, moving to new row after last column

    I don't know, maybe someone else will give you formula(s) solution

    Have a nice day
  3. Re: Weight Break calculations - A method question

    No problem

    Have a nice day
  4. Re: Weight Break calculations - A method question

    right :)
  5. Re: Weight Break calculations - A method question

    your service should have this option, if not try googledrive, onedrive, dropbox or any similar
  6. Re: Weight Break calculations - A method question

    Shared means : no emails, no logging, no registration just download, that's all
  7. Re: Weight Break calculations - A method question

    Your file is NOT shared!
  8. Re: Transpose every 2 columns into new row, moving to new row after last column

    With PowerQuery (Get&Transform) try UnPivot Selected Columns for Keys then the same for Attr
  9. Replies
    9
    Views
    188

    Re: Change Data Structure

    You are welcome

    Have a nice day
  10. Replies
    4
    Views
    109

    Re: Date Formula Support Needed

    what does that mean: Last Week -1? Last Week - one day? - one week?

    anyway try:


    = if Date.IsInPreviousNWeeks(Date.AddDays([Date],0),1) = true then 1 else if...
  11. Replies
    24
    Views
    177

    Re: Filter values in a pivot table

    M-code from the post create group and sum total for channels by country so if you pivot this table it will give you wrong result

    Query Table is the EndResult
  12. Replies
    24
    Views
    177

    Re: Filter values in a pivot table

    Could you explain what are you doing with the result table after add M-code?
  13. Replies
    24
    Views
    177

    Re: Filter values in a pivot table

    Power Query == Get&Transform
  14. Replies
    24
    Views
    177

    Re: Filter values in a pivot table

    so maybe this layout will be better


    Channel NameDelivered & NetCountry

    Comedy Central UK
    926.12Poland, Brazil, Switzerland, Austria, Mexico, Chile

    Nickelodeon PT
    761.67Mexico, Chile,...
  15. Replies
    24
    Views
    177

    Re: Filter values in a pivot table

    sure

    have a nice day
  16. Replies
    24
    Views
    177

    Re: Filter values in a pivot table

    NO!

    as I said this is PowerQuery (Get&Transform) not any vba

    what is your Excel version?
  17. Replies
    24
    Views
    177

    Re: Filter values in a pivot table

    with PowerQuery aka Get&Transform

    M-code:


    // Table1
    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Type = Table.TransformColumnTypes(Source,{{"Channel Name", type...
  18. Replies
    24
    Views
    177

    Re: Filter values in a pivot table

    but which one? ;)
  19. Replies
    24
    Views
    177

    Re: Filter values in a pivot table

    or with PivotTable and filter less than 100


    Channel NameCountrySum of DELIVERED $ NET

    BET OfficielFrance
    7.22

    United Kingdom
    0.32
  20. Replies
    24
    Views
    177

    Re: Filter values in a pivot table

    to be sure: greater than 100 or less than 100? (post#1)

    for greater than 100


    CountryChannel NameDelivered & Net

    AustraliaNickelodeon PT
    761.67
  21. Replies
    24
    Views
    177

    Re: Filter values in a pivot table

    you didn't show what you want to achieve but maybe:


    CountryChannel NameSum of DELIVERED $ NET

    AustraliaBig Brother UK
    6.72

    Channel 5
    1.83
  22. Replies
    4
    Views
    84

    Re: Help with company name list

    You are welcome

    Have a nice day
  23. Re: Looking for a tutorial to learn making this ?

    You are welcome
  24. Re: Looking for a tutorial to learn making this ?

    Google is your friend :) eg. Check this
  25. Re: Looking for a tutorial to learn making this ?

    with Excel go to the File - New and find any Template for your needs
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4