Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Powerpivot, similar formula to Countif ?

    Hi , i have a Datatable imported into Powerpivot, where i need for 6 columns a conditional count for each row, my formula in Excel is similar to


    =COUNTIF([Q1]:[Q6]),"")

    I have big issues...
  2. Replies
    1
    Views
    120

    Dynamic Line chart - empty values

    Hi, i have made a very simple linechart, with Months on the horisontal axis, but as data for the months august-december has not materialized, the line chart makes this annoying break at the last...
  3. Append function for multiple files only possible for 2 files in Power Query/Excel 2016/64 bit?

    Hi i have worked before with Excel 2013/64 bit and used Power Query and the function Append, in order to consolidate data from multiple Excel files into one file.

    Now when i use the built-in...
  4. Re: Large Excel files in Powerpivot - best practice?

    Hi Fazza
    I need Powerpivot to relate to other Tabels and to create a Pivot from there.
    The Excel files are exported from SAP and are each a dataset for one year.
    Its not usually a problem, but...
  5. Large Excel files in Powerpivot - best practice?

    Hi, i have 3 xlsx. files in exactly same format each numbering about 750.000 rows, i can export either as xlsx, csv or txt.
    I have tried in vain to create a single Excel file by copying data in one...
  6. Replies
    9
    Views
    320

    Re: DATEVALUE in Excel, handy tips?

    Thank you all for your tries, i really appreciate it, however it is too complicated to work with weeks missing one day, so i have told the finance dep. to include the whole week.
  7. Average in Power Pivot versus calculated field in Excel

    Hi, i am a very happy user of Powerpivot, but i have one question:

    I use the Calculated field in Excel to for example calculate the price per unit, by dividing the total costs with the number of...
  8. Replies
    9
    Views
    320

    Re: DATEVALUE in Excel, handy tips?

    Im afraid its not that simple

    First of all, the shown date values is only an extract from the data, the data includes all dates from 01-01-2016 to yesterday, so i need an automated solution.

    I...
  9. Replies
    9
    Views
    320

    Re: DATEVALUE in Excel, handy tips?

    Hi, the data is a total data table intended for lookup
  10. Replies
    8
    Views
    973

    Re: combine SUMIF with SMALL

    Hi AhoyNC, thanks for your tries, however i need the calculation for the Overview sheet, unfortunately.
  11. Replies
    9
    Views
    320

    Re: DATEVALUE in Excel, handy tips?

    Hi Jon, the challenge is that it is not a whole week, its only 6 days, Friday is excluded, so i cant use the Weeknum function.
  12. Replies
    9
    Views
    320

    DATEVALUE in Excel, handy tips?

    Hi i need to group dates in Excel based on a unnatural selection, namely Saturday to Thursday, so i need an alternative for WEEKNR, could you please help? - i need an unique value like WEEKNR for the...
  13. Replies
    8
    Views
    973

    Re: combine SUMIF with SMALL

    Thanks a lot for your tries, however i am afraid i did not make myself clear, if you should have the time and patience, i have a dropbox link:
    ...
  14. Replies
    8
    Views
    973

    Re: combine SUMIF with SMALL

    Hi AhoyNC, you helped me a lot last time, one last request.

    If i want to keep your formula but change the output from the SMALL from the Tabel1[Percentage], but instead return the value from the...
  15. Replies
    8
    Views
    973

    Re: combine SUMIF with SMALL

    Thanks a lot AhoyNC, just what i needed!
  16. Replies
    8
    Views
    973

    combine SUMIF with SMALL

    ​Hi, i would like to combine SUMIF with SMALL but has some problems doing so:

    I have a table where Week/Year is stored and now i need to create a Top 10 of the worst results for each week.

    I...
  17. Replies
    14
    Views
    287

    Re: Filter for Weeks when week is incomplete

    Hi Peter, sure , one thing that might make it easier is that is only the last week where weekdays can be missing.
  18. Replies
    14
    Views
    287

    Re: Filter for Weeks when week is incomplete

    Hi Peter, i understand.

    What i want as the optimal solution is that Excel counts unique number of recurrences of days in every week and validate for every row, whether all 7 days is present in...
  19. Replies
    14
    Views
    287

    Re: Filter for Weeks when week is incomplete

    Hi Peter, i can give a link to the file via dropbox, im using 2013

    https://www.dropbox.com/s/0wnpsh1b70p30zs/Test_whole%20week.xlsb?dl=0
  20. Replies
    14
    Views
    287

    Re: Filter for Weeks when week is incomplete

    http://i63.tinypic.com/ngzzax.jpg
  21. Replies
    14
    Views
    287

    Re: Filter for Weeks when week is incomplete

    http://i63.tinypic.com/ngzzax.jpgThanks a lot Peter, much better!
    I have another request, if the same date occurs multiple times in the same sheet, is it possible to create a formula on that basis?
  22. Replies
    14
    Views
    287

    Re: Filter for Weeks when week is incomplete

    Thanks a lot, a little CPU heavy but worked like a charm!
  23. Replies
    14
    Views
    287

    Re: Filter for Weeks when week is incomplete

    Yes
  24. Replies
    14
    Views
    287

    Filter for Weeks when week is incomplete

    Hi, I want to create a formula which i can apply as a filter so i can limit my dataset to only show date where full weeeks are shown, could anybody help? :)

    An example of the data sheet and how i...
  25. Re: Auto-generate date and time for a large period.

    Hi Dan, thanks for tries, i ended up solving it with a combination your advice and of INT,CEILING and MOD
    =INT(A1)+CEILING(MOD($A1;1);1/24)
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4