Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Re: How to create a range from a cell value and repeat time in another cell ?

    Basically I mean I need to create a range of 100 cells each is the same "500"
    How to do this using cell value 500 and 100 ?
  2. How to generate a unique ID on a Excel for identification purpose

    Some dept will send me several version of Excel repeatedly whenever they have update.
    I need to identify which one is which version. So, is it possible once I receive it, Excel has some kind of ID...
  3. Re: How to create a range from a cell value and repeat time in another cell ?

    Thanks. I forget I cannot use VBA in the company.

    How to do it without VBA ? Will array work ?
    Those 500 are fixed and do not change.
  4. How to create a range from a cell value and repeat time in another cell ?

    Right now I have a data A1:A100 each cell is 500
    So my range called RangeA is A1:A100
    Can I do without need to have this list in this 100 rows



    Now I key in, B1=500, C1=100
    How can I create...
  5. Replies
    0
    Views
    86

    How to get data from Excel online

    I have copied the Excel online file link and paste and it says do not have Access.
    The first time it ask me to supply Organization Account password and I carelessly cancelled and now that prompt...
  6. How to combine two ranges vertically ?

    I have two ranges: R1 and R2. They have same header
    How to combine them so R1 is on top and R2 is at the bottom to form a new combined range called "R"?

    Thanks
  7. DAX, how to last value in the period total

    I have a table like this

    Country, headcount, Month
    ==================
    US, 23, May2019
    US, 24, Jun2019
    UK, 27, May 2019
    UK, 27, Jun 2019

    Now Excel pivot-table of Country as row and Month as...
  8. Pivot Table how to show latest value in the period instead of sum total

    I have a table like this

    Country, headcount, Month
    ==================
    US, 23, May2019
    US, 24, Jun2019
    UK, 27, May 2019
    UK, 27, Jun 2019

    Now pivot-table of Country as row and Month as...
  9. Replies
    1
    Views
    136

    Re: Get only data on PivotTable

    any one know the answer
  10. Replies
    1
    Views
    133

    How to get data from Excel online

    I have a datasource stored on an Excel on Onedrive Business (ie Excel online).
    In a local machine Excel, I goto Data > Get Data > From Web and enter the correct path of this Excel online file.
    At...
  11. Replies
    6
    Views
    418

    Re: Any chance mdb to get data from xlsx

    Yes I have tried Google and no luck.

    I tried in mdb link to xlsx it says this version of access cannot link to this newer xlsx. Seems mdb can link xls (older version of xlsx) only.
    Anyone can...
  12. How to use a field as "Not Something" to be condition of a query

    I have a table with one column storing the condition of a query, like "*" etc.
    * means all countries
    Now, apart from "*", there is a need to have a condition "Not US"

    So, can we join table has...
  13. Replies
    6
    Views
    418

    Any chance mdb to get data from xlsx

    I know accdb is better to be used to get linked data from xlsx.
    But for some reason my platform can only use mdb.

    Anyone got any experience mdb can also get linked table data from xlsx ?
    Help...
  14. Re: SQL to multiply value from previous record ? How ?

    Thanks. I will try to study this SQL and see if I can do it also on Access.
  15. Re: SQL to multiply value from previous record ? How ?

    Thanks. What is the SQL if it is in say MsSQL?
  16. SQL to multiply value from previous record ? How ?

    Pls help...
    I have a table like this

    ID , Rate
    ==========
    1, 0.2
    2, 0.5
    3, 0.3
  17. How to get data from another Excel not by PowerQuery

    In the past I recall I can easily link in File 1's range with data from File2's range.
    Now I found I can only import from File2 data using powerquery.

    Where can I use the old method to link from...
  18. Replies
    1
    Views
    136

    Get only data on PivotTable

    If I double click Grand total on PivotTable I get all columns of data including those not on the PivotTable.
    Is there way to get the data only for dimensions that appear in the PivotTable only ?
    ...
  19. How to hide the queries and connection in Excel

    I created several PowerQuery but I want to hide it.
    Now, everyone clicking Data > Query and connection can find it.
    How to make it "invisible" to others ?

    Thanks
  20. Re: How to hide sheet and can be unhide with password

    Thanks Protecting whole workbook may mean they have to key in password at early stage when open ?
    I need to ensure no password is needed in normal operation, until someone try to unhide.
    So Protect...
  21. How to hide sheet and can be unhide with password

    I have several tabs in Excel I need to hide.
    I know we can using Veryhidden but that can still be unhide without password.
    I know we can select VBAProject password but that works only if there is...
  22. How to modify SQL to make * = all in join query

    I have Table A like this

    Country, Product, Sales
    ==========
    US, A, 100
    UK, A, 200
    US, B, 150
    UK,B, 350

    In Table A it is like this
  23. Refresh query/powerquery of my Excel Online file

    I have an Excel data table and a separate Powerquery that result in an output table.
    Of course I can manually set refresh every 1 minute for the query and do the same to refresh the output table...
  24. Can PowerBI refresh the PowerQuery on my Excel data

    I have PowerBI connected to Excel data source (ie not imported but "linked").
    This Excel (either can be on OneDrive business or desktop) contains a powerquery to do data transformation.

    The data...
  25. Re: In Powerquery, How to filter a Table using criteria stored in another Table

    Thanks a lot.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4