Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.25 seconds.

  1. Re: Pivot count to exclude certain entry in grand total

    Looks achievable - maybe by a few approaches. Specific solution depends on your set up & which way you'd want to go. Best to provide details of set up.
  2. Re: how to Changes in the calculation and display of the Grand Total in the pivot table?

    to me, it is not clear what is required

    a simple & clear explanation with some sample data - that can be copied into Excel - will increase your chances of getting a solution
  3. Re: Best way to show data that can be drilled down?

    may be of interest - https://jkp-ads.com/Articles/treeview.asp
  4. Re: Combine data in columns (A-Current portfolio, B-buys, C-sells, Result-resulting portfolio)

    Being unfamiliar with pivot tables, MS Access might be a good tool.

    Though VBA within Excel might be even better - cause you don't need two different softwares. It probably is simple enough in VBA...
  5. Re: Combine data in columns (A-Current portfolio, B-buys, C-sells, Result-resulting portfolio)

    hi, Tim

    Maybe use a pivot table. It can combine data from multiple tables and not show data that nets to zero quantity.
    Or very similar using a query table. Neither needs code but you could have...
  6. Replies
    4
    Views
    132

    Re: Speed it up if you can

    tweaking that a bit, to remove looping cell-by-cell


    Sub addresscapital()

    Dim rngCells As Excel.Range

    Application.ScreenUpdating = False
    Application.Calculation =...
  7. Re: VBA Excel SQL Error "No Value Given for One or More Required Parameters"

    Maximum. That is done like this,


    SELECT MAX(some field), other fields you want
    FROM table
    GROUP BY other fields you want

    Order of fields in SQL doesn't matter, btw.

    If you want to filter,
  8. Replies
    1
    Views
    712

    Re: Best PC for calculating huge data?

    Hello

    I assume these are Excel files, and suggest the biggest difference in calculation time will be the way the calculations are done. The set up of the Excel file.

    There are old threads here...
  9. Re: Value not equaling what it should -- can't figure out why

    please see the highlighted note in https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/round-function

    in case that link has an error, I'll copy it here,


    Please...
  10. Re: VBA Excel SQL Error "No Value Given for One or More Required Parameters"

    Hi, Sam

    IIRC, that error is when a field name in the query is not found in the data.

    Suggest you carefully check field headers "First Last", "Age", and, "Salary" match between the worksheets &...
  11. Re: Maintain partial bolding of original cell when doing an INDEX/MATCH lookup

    You could use VBA instead. Issue might be speed if you have many.
    Being code, specifics would really help for anyone to assist further.
  12. Re: Value not equaling what it should -- can't figure out why

    Double gets you lots of digits in numbers. https://docs.microsoft.com/en-us/dotnet/visual-basic/language-reference/data-types/double-data-type
    The sort of subtraction being done often has small...
  13. Re: Moving Axis Cross Points automatically within Excel 2010

    the macro recorder is great for this sort of thing. ALT-T-M-R to start it.

    ActiveChart.Axes(xlCategory).CrossesAt = Range("YourCell").Value2

    Please set activechart or change first reference....
  14. Re: VBA SQL Query w/WHERE Clause Condition = GetUserName() From MS ACCESS DB

    actually, it was a different thread I was thinking of. it includes some timing of different approaches

    https://www.mrexcel.com/forum/excel-questions/332472-excel-acess-via-dao.html
  15. Re: VBA SQL Query w/WHERE Clause Condition = GetUserName() From MS ACCESS DB

    PS

    If you have a bit of data, IIRC a faster & more robust approach is to load the data into an array and load from there instead of from the worksheet.

    Of course, by using an array you again...
  16. Re: VBA SQL Query w/WHERE Clause Condition = GetUserName() From MS ACCESS DB

    again, REALLY specific info is needed (on what you want & the set up you have. based on the description given, what follows is really just rough, general advice. What might work best for you might be...
  17. Re: VBA SQL Query w/WHERE Clause Condition = GetUserName() From MS ACCESS DB

    it is inserting everything because that what the code says to do. near the end of the code, the line is "SELECT *"

    there are many, many options & I don't know what you want - so can't advise...
  18. Re: VBA SQL Query w/WHERE Clause Condition = GetUserName() From MS ACCESS DB

    I guess the user name function is in Excel

    right now, the SQL has the function name hard-coded in it. instead the SQL (which is just text) needs to be created (concatenated) - so put the value...
  19. Re: Help: Raffle Name Picker 250 Prizes, 0 Duplicates with Multiple Entries per Person

    That doesn't answer my question. Maybe I didn't explain it well enough. I don't know what you want so I can't help you.

    What about?
    Formula =A2 in the top prize winner 1 cell, then drag/fill down...
  20. Re: How do you manage volatile functions, array formulas in workbook with large data set

    How I manage it is by using a different approach. This was addressed in a separate recent thread. Basically working like a database - without volatile functions & especially without array formulas....
  21. Re: VBA Code simplification - Creating folder with month/year

    :-)
  22. Re: Comparing column to column in multiple sheets, delete row of match found

    ERROR in what I typed: should be if result is greater than zero.

    (so maybe just a simple filter on the column with the offered formula, for values > 0, then select all & delete rows. for small...
  23. Re: Comparing column to column in multiple sheets, delete row of match found

    It would be good to better understand the set up, and the volumes of data as perhaps there are better ways to do the task.

    Maybe this helps you?
    put this formula on sheetA
    ...
  24. Re: Help: Raffle Name Picker 250 Prizes, 0 Duplicates with Multiple Entries per Person

    Surely you must give some rules on how to pick the unique winners?

    How is it done? for example where i'm from, some little bits of paper each with an ID on them are put in a bucket and someone...
  25. Re: Phantom Links in Workbook that cannot be found to be deleted

    Be sure to check HIDDEN names, the name manager doesn't show these IIRC.
    In case you haven't already checked, also check for any very hidden worksheets.
    And check objects on worksheets: these...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4