Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Power Query - Multiple several columns with value obtained via Paramater

    Hi,

    I have a table containing budgeted foreign sales data by month and want to convert this to a home currency (the fx rate is obtained via a parameter). Is it possible to multiple several columns...
  2. Thread: Running count

    by jonh
    Replies
    5
    Views
    707

    Re: Running count

    Hi Sandy,

    Thank you very much.

    Regards,
    Jon
  3. Thread: Running count

    by jonh
    Replies
    5
    Views
    707

    Re: Running count

    Hi Sandy,

    Yes. Thank you. That's perfect for Col2, how would I get Col1 where I want All ANOther1 to have a value of 1, All ANOther2 to have value of 2 etc...

    Would it be possible to share the...
  4. Thread: Running count

    by jonh
    Replies
    5
    Views
    707

    Running count

    Hi All,

    New to power query in Excel. Is there a way I can get a running count based on a reoccuring value in a column, and start a new running count based on new values?

    Cannot find the...
  5. Replies
    0
    Views
    282

    Commissions based on Multiple Variables

    Hi, our payroll dept., has asked if we can help them to calculate the commissions payable to 200+ salespersons based on the tables below. I used SUMPRODUCT in the past but with everyone on the same...
  6. Replies
    0
    Views
    280

    Sum on Visible Sheets only

    Hi,

    Is there anyway to exclude hidden sheets in your calculations i.e. I want to sum sheets1...Sheets5, but exclude values in Sheet3 if it is hidden.

    Regards,
    Jon
  7. Replies
    4
    Views
    238

    Re: Excel does not calculate

    Thanks, I'll try that.

    Regards,
  8. Replies
    4
    Views
    238

    Re: Excel does not calculate

    Thanks for the response. Tried this previously but it doesn't work. My only method of forcing Excel to Calculate is to Edit the formula and return on it. Even closing Excel does not work as in...
  9. Replies
    4
    Views
    238

    Excel does not calculate

    Hi,

    I have quite a large spreadsheet which is used for stock calculations at the end of each month. Each location carries the same stock items, so the structure & layout of each sheet is...
  10. Replies
    10
    Views
    710

    Re: Testfile and pairs of numbers

    Thanks all for your assistance.
  11. Replies
    10
    Views
    710

    Re: Testfile and pairs of numbers

    Thanks for the above function. It works on about 75% of the data, however, when the dates in YY format are not in sequential order i.e.
    96~97~97~01~01~02~02~04, the function returns the following:...
  12. Replies
    10
    Views
    710

    Re: Testfile and pairs of numbers

    Thank you for the code below, it has saved it an enormous amount of time. Perhaps when you have time, you could explain the code in detail.

    All the best!
  13. Replies
    10
    Views
    710

    Re: Testfile and pairs of numbers

    Thanks for your help!
  14. Replies
    4
    Views
    435

    Re: Prevent linking to a workbook

    Glenn,

    Sorry I should have pointed out that the file is protected and that several users outside of the dept. access this file on occasions (via the password on the file). Those users outside of...
  15. Replies
    4
    Views
    435

    Re: Prevent linking to a workbook

    Gleen,

    Thanks for the reply. However, I was trying to prevent authorised users from linking to the file.

    The problem is that I & others in my dept. make changes to a certain file i.e....
  16. Replies
    10
    Views
    710

    Re: Testfile and pairs of numbers

    Hi Gleen,

    Unfortunately there can be multiple pairs, but the max is 5. If 5 then the string is as follows:

    81~87~87~88~88~89~93~93~95~96

    Otherwise, the pair(s) can appear anywhere in the...
  17. Replies
    10
    Views
    710

    Testfile and pairs of numbers

    Hi,

    I'm trying to convert data from an old to a new payroll system. One field contains multiple pairs of dates (start & finish, yy format) as follows:

    Col A
    Row1 89~92~95~97
    Row2 ...
  18. Replies
    0
    Views
    199

    Testfile and pairs of numbers

    Hi,

    I'm trying to convert data from an old to a new payroll system. One field contains multiple pairs of dates (start & finish, yy format) as follows:

    Col A
    Row1 89~92~95~97
    Row2 ...
  19. Replies
    4
    Views
    435

    Prevent linking to a workbook

    Hi,

    I know that it's possible to prevent automatic updating of links between files, but is it possible to prevent users from linking to a particular file in the first place?

    Thanks,
    Jonh
  20. Re: Textbox - Numeric format & character lenght - VBA

    Guys,

    Many thanks for your help.

    Jon
  21. Textbox - Numeric format & character lenght - VBA

    Hi,

    I want to create a textbox allowing users to enter a numeric value which is eight (8) characters in lenght.

    Is it possible to check for both input characteristics (numeric format and lenght...
  22. Replies
    1
    Views
    264

    Pivot Tables and column totals

    Hi,

    Is it possible to move the column totals from the right to the left hand side of the data (columns) being totalled?

    Likewise, I would like the grand total to appear next to the 'row area'...
  23. Many thanks for this. Jon

    Many thanks for this.

    Jon
  24. Run a marco on sheet3, then sheet4....sheet99

    Hi,

    Is it possible to create a macro that runs another macro in sheet3, then moves on to sheet4 and run the same macro, sheet5 etc. etc.

    This is further complicated by the fact that each tab is...
  25. Replies
    1
    Views
    286

    Pivot Table Charts - User Defined

    Hi,

    I've created a Line - Column chart (Custom Types) and added it to the User-Defined area. The reason for creating a user defined chart was due to the fact that every time I changed the chart...
Results 1 to 25 of 42
Page 1 of 2 1 2