Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    487

    Re: CUBEMEMBER / CUBEVALUE dates query

    It's in this format 2019-07-27T00:00:00 but I've used TEXT to convert K1 to the same format. When I use OLAP Tools to convert a power pivot to formulas the date format matches but I'm struggling to...
  2. Replies
    2
    Views
    487

    CUBEMEMBER / CUBEVALUE dates query

    Hi, I am trying to lookup a Power Pivot dates table in native Excel with a formula to lookup the date to return financial week.

    I have the date in cell K1 in the correct format.

    Is there a cube...
  3. Replies
    5
    Views
    829

    Re: Equivalent to GETPIVOTDATA in PP?

    Thanks Rory - works and much more succinct than the big IF statement I had put in place.

    Thanks again for your help!
  4. Replies
    5
    Views
    829

    Re: Equivalent to GETPIVOTDATA in PP?

    Hi guys,

    The above solution works fine for text, I'm just trying to get my head round it for numbers. Ideally I just want it to lookup a number in the cell but it looks like GETPIVOTDATA reads PP...
  5. Replies
    5
    Views
    829

    Re: Equivalent to GETPIVOTDATA in PP?

    Great stuff, thanks Rory!
  6. Replies
    5
    Views
    829

    Equivalent to GETPIVOTDATA in PP?

    Hi all

    Done a bit of Googling and looked at things like CUBEVALUE etc but haven't quite worked out how to get GETPIVOTDATA working when some of the values come from cell references.

    I've had to...
  7. Replies
    2
    Views
    104

    Re: Formula to sum times saved as text

    Perfect!!!

    Thank you.
  8. Replies
    2
    Views
    104

    Formula to sum times saved as text

    I have an Excel report which indicates times in hh:mm:ss but formatted as text, and I'm looking for a formula that can sum the full range of them and display total hours.

    TIMEVALUE seems to work...
  9. Replies
    2
    Views
    213

    Re: VBA to export a table to CSV/TXT

    Thanks for the response. It's direct to a network so it's not due to connectivity or network speed issues.
  10. Replies
    2
    Views
    213

    VBA to export a table to CSV/TXT

    Hi guys

    I'm after some VB to simply select a table within an Excel worksheet (not the full worksheet, just the table including it's headers) and output it as either a txt file or a csv.

    I did...
  11. Replies
    3
    Views
    141

    Re: RefreshAll in a particular order

    Thanks to both of you, that's a massive help!
  12. Replies
    3
    Views
    141

    RefreshAll in a particular order

    Hi all

    I have some jobs to run in VB which include tables (updating from external sources) and pivot tables (which link to those tables).

    I started with ActiveWorkbook.RefreshAll and it wasn't...
  13. Replies
    3
    Views
    604

    Re: Importing Survey Monkey data into Excel

    *Do not post questions about Excel or Access in this forum* This forum is for Excel-related discussion and questions concerning programs other than Excel or Access. This is also the place to ask...
  14. Replies
    3
    Views
    604

    Importing Survey Monkey data into Excel

    Hi,

    As anyone got any advice on the best way of exporting multiple surveys and merging them into one Excel table for analysis? I have 40 identical surveys to combine the results from.

    I'm OK...
  15. Replies
    0
    Views
    391

    Using Power Maps with slicers

    Hi,

    I have tried to answer this question myself on Google, but can't find a definitive answer anywhere, so can anyone help...

    Is there a way Power Maps can be integrated into an Excel...
  16. Replies
    1
    Views
    4,577

    Power Query - Reformat a number to text

    Hi,

    In Power Query I'm trying to convert a numeric field into the format e.g. REF00026.

    In Access it'd be "REF" & format([field],"00000").

    I can find how to add a Prefix from the format...
  17. Re: Highlight specific text based on a range

    Brilliant, that's done the trick. Thanks.
  18. Highlight specific text based on a range

    Hi,

    I'm hoping this is possible (and relatively easy) but couldn't find any examples on Google.

    I want to use the format cells containing specific text conditional formatting rule, but instead...
  19. Replies
    1
    Views
    91

    Table refresh causing formula errors

    I have some formulas looking up specific row numbers in an Excel table. When the table refreshes if the number of rows in it adjusts then the formula returns an error.

    Is there a way of fixing...
  20. Re: Protecting an Excel file on a shared drive

    Thanks Eric, I really appreciate this!
  21. Protecting an Excel file on a shared drive

    Hi,

    There might be an easier way to do this and I'm open to suggestions. But basically I want to leave a file on a network drive for users to access but ensure no-one can make any changes.

    Can...
  22. Excel compatibility with Google Drive & iPads

    Hello all

    I have built an interactive xlsm file for someone with lots of vba included - in short user forms (not the in built ones, built with vba) which submit new entries to listing sheets and...
  23. Replies
    0
    Views
    212

    Sorting slicers based on volume

    Hi,

    Is it possible to sort descending your slicers so the most common values show up first?

    E.g.
    North 500
    East 600
    South 800
    West 200
  24. Re: ComboBox drop-down not clearing out old values

    Found this workaround which will do for me: Daily Dose of Excel Blog Archive Looping through PivotItems that Don’t Exist

    Taking the Record Count >0 will do the job for me here. Thanks for your...
  25. Re: ComboBox drop-down not clearing out old values

    Fair point, I've just done that and stepping through I can see that these old values are still PivotItems in my PivotField but I don't know what to do to prevent it? When I go to the pivot table...
Results 1 to 25 of 28
Page 1 of 2 1 2