Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    0
    Views
    70

    Query Refresh - Why does it duplicate

    Hi,

    I have - Query1 = Excel.CurrentWorkbook()

    Below pic shows query properties. How do I refresh this so that only new rows are added. If I manually refresh, the 15,970 rows duplicates giving...
  2. Replies
    2
    Views
    163

    Re: Clear history from macro VBA Worksheet

    This is the Add code below.

    Private Sub CommandButton1_Click()
    Dim Owner As String
    Dim Coordinator As String
    Dim Description As String
    Dim RiskType As String
    Dim...
  3. Replies
    2
    Views
    163

    Clear history from macro VBA Worksheet

    Hi,

    I have a worksheet I use that lets me add records by clicking an add button. Worksheet uses macros/VBA. Each new entry id is auto incremented by 1.
    GG1, GG2 etc

    I want to start from...
  4. Replies
    3
    Views
    196

    Re: Dynamically populate dropdown list

    Thank you.
  5. Replies
    3
    Views
    196

    Dynamically populate dropdown list

    Hi,

    I have a 2 dropdown lists.
    The second dropdown is (dynamically) populated depending on what is selected in the first (using =INDIRECT).


    The second dropdown list gets it's source data...
  6. Replies
    1
    Views
    475

    Refreshing Blank Query - Duplicates

    Hi,

    I have combined all tables in an excel files using the blank query -> =Excel.CurrentWorkbook()

    If I click the refresh icon it will duplicate all the loaded rows. How do i avoid this & only...
  7. Populate cell dropdown list based on what is selected in other cells

    Hi,

    Bit lost with this.

    I have a column L whose cells contain the dropdown options

    Almost Certain (5)
    Likely (4)
    Possible (3)
    Unlikely (2)
  8. Power Query - Excel.CurrentWorkbook() - Error

    Hi,

    First time using this. What am I doing wrong that brings about the errors in attached image?

    https://www.dropbox.com/s/mo6gk6kigrts0me/asas.png?dl=0

    Thks,
  9. Replies
    3
    Views
    209

    COUNTIF range is blank

    Hi,

    Looking to count all the numbers in range H:H but only if A:A contains the value in cell V28 & G: is blank.

    COUNTIFS but struggling with correct syntax.
  10. Replies
    2
    Views
    188

    Conditional formatting using IF And

    Need to apply conditional formatting to a cell containing a date

    e.g L6 = (08/06/2019)



    Criteria are:
  11. Re: Remove all characters before & including a dash

    That works too. Thank you.
  12. Re: Remove all characters before & including a dash

    That works perfectly. Thank a lot.
  13. Remove all characters before & including a dash

    Hi,


    My cell A4 contains the text 103-6807-2016-11-25 -CL- Joesep Byrne Senior -ST- Grace Jones.html


    I want to remove everything before & including the first -


    Also, other cells will...
  14. Replies
    5
    Views
    1,487

    Re: Fill down cells referencing every nth cell

    Perfect. Thank you Eric.
    Gerry
  15. Replies
    5
    Views
    1,487

    Re: Fill down cells referencing every nth cell

    Thanks for the reply. Not doing what I need. Cells don't reference any of the values in column A. Thanks anyway.
    Erics formula works.

    Gerry
  16. Replies
    4
    Views
    170

    Re: Refrencing a cell in a Pivot Table

    Yes, that works a treat. Thank you.

    Gerry
  17. Replies
    5
    Views
    1,487

    Fill down cells referencing every nth cell

    Hi,

    I want to reference the cell A6 in cell W6. So I use =A6. I want to reference every 3rd cell so the next cell I want to reference is A9.
    W7 = A9
    W8 = A12 etc

    How do I fill down W6 to...
  18. Replies
    4
    Views
    170

    Refrencing a cell in a Pivot Table

    Hi,

    I would like to reference a cell in a pivot table. In a different worksheet in cell H5 I'd like to simply say =(U5).
    U5 is the cell in Pivot table and contains the number 128.
    I then want...
  19. Replies
    1
    Views
    149

    Lock down formatting only

    Hi,

    I need to lock the format of cells. I am going to be copying & pasting values from a different sheet
    into the cells in the linked file. I will have to do this 100 + times so will be using...
  20. Replies
    1
    Views
    141

    Substitute to replace value

    Hi,

    Using =SUBSTITUTE(A:A, "/", "-") to replace all / with a dash.

    Not getting what I expected. For e.g, 02/02/6451 converts to 1662253
  21. Re: Fill down non consecutive formula from one sheet to another

    Thank you very much Eric. Yeah, I did list an extra value. Thanks a million for this.
  22. Re: Fill down non consecutive formula from one sheet to another

    To explain this better. I need the values in Sheet2 in Sheet1 without having to copy this -> A1=Sheet2!A1 each time.
  23. Fill down non consecutive formula from one sheet to another

    Hi,

    I need to fill down the formula in cells A1, A5, A9, A13, A17, A21, A25 from Sheet 2 into cells A1:A6 in Sheet1. Attached Workbook should hopefully explain exactly what i need....
  24. Replies
    1
    Views
    1,292

    JSON to Date\Time format

    Hi,

    I am trying to convert the following 13 digit json number -> 1452002465000 to date/time.

    I am using this formula ->=D7/1000/86400. This is giving me 03/01/1946/ 12:28 PM.

    The time is...
  25. Replies
    3
    Views
    6,067

    Re: Converting json date time format

    Thanks a million dave. Any idea why I'd be getting my years as 1984 instead of 2016?
Results 1 to 25 of 62
Page 1 of 3 1 2 3