Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Code Particular Strings As Numbers, Then Sum Numbers

    Thank you for the replies.

    I wound up using =SUM(LOOKUP(A2,{"Category A";"Category B";"Category C"},{1;2;3}),LOOKUP(B2,{...et cetera with the dropdown list. It's not pretty but I was more...
  2. Code Particular Strings As Numbers, Then Sum Numbers

    Hello,

    I'm trying to assign numerical values to a set of particular strings; and then add the numbers.

    It would work something like this --

    Category A = 0
    Category B = 1
    Category C = 2...
  3. Replies
    2
    Views
    671

    Re: Equivalent of DATESBETWEEN(LASTDATE... ?

    Thank you, Matt.

    I've got a client table:

    ClientIDClient Name1Client A2Client B&c.&c.

    and a contract table:

    ContractIDClientIDContract NameContract AmountStart DateEnd Date11Client A...
  4. Replies
    2
    Views
    671

    Equivalent of DATESBETWEEN(LASTDATE... ?

    This query pertains to Power Pivot in Excel 2016.

    I have a table containing every annual contract, past and present, which includes contract end dates and amounts. (I also have two separate...
  5. Replies
    2
    Views
    1,012

    Re: Power Query: >90 Queries?

    HIGH FIVE

    Sincerest thanks, gazpage! That very much works!
  6. Replies
    2
    Views
    1,012

    Power Query: >90 Queries?

    Good day, Excelsiors,

    I am using Power Query to run an API call to our service provider, in order to pull through our platform users and their attendant data. The idea is that we would like to...
  7. Re: PowerPivot: "COUNTIF" for same row, same table?

    Yep! Works like a charm!

    Thank you most kindly, VBA Geek!
  8. Re: PowerPivot: "COUNTIF" for same row, same table?

    Something more like this (I managed to get this one through a more difficult, roundabout way but I literally have dozens of these to do, so a simpler way would be very much appreciated):
    ...
  9. Re: PowerPivot: "COUNTIF" for same row, same table?

    Thank you for your reply, VBA Geek.

    That would, indeed, give me the figures I need but, ultimately, I want to have a chart whose axis label would be something like this:


    =C1 & " (" &...
  10. PowerPivot: "COUNTIF" for same row, same table?

    Good day,

    I thought this would be easy but I'm having a devil of a time, I hope someone can please help!

    I've tried writing this in a table; within PowerPivot; and as a measure but nothing...
  11. Percentage of Condition, Less One Element (PivotTable, SQL?)

    Good day,

    I am trying to find out what percentage of individuals did not hit a particular condition on the same dates, particularly when one individual is removed from the equation. This sounds so...
  12. Re: 'Text to Columns' with destination in different workbook?

    WHOOPS! Slight error. This works:


    Sub Macro1()
    '
    ' Macro1 Macro
    '

    '
  13. Re: 'Text to Columns' with destination in different workbook?

    Thank you very much for the reply, Russell.

    I'm afraid I can't make the destination in the same sheet because I wouldn't know where any available blank cells will be relative to the cell which...
  14. 'Text to Columns' with destination in different workbook?

    Good day,

    I've been trying for hours to figure this out (yes, including myriad Google search criteria permutations), I hope you can help!

    I simply want to 'Text to Columns' with the cell which...
  15. Re: Function (or VBA) to calculate just the above section?

    Sorry, this would make more sense if I explained that I don't know how many random numbers there will be and I continually have to adjust the number of random numbers summed, by moving the formula...
  16. Function (or VBA) to calculate just the above section?

    Good day, Excelsiors,

    I have a sheet that has multiple "sections," and I need a formula which will calculate only the section above it. I have a formula that works but I have to continually update...
  17. Re: Remove Duplicates In Column B For Each Value In Column A? (VBA Or Formula)

    I tried bewsh1987's version, it worked just fine.

    Many thanks to both of you!
  18. Re: Remove Duplicates In Column B For Each Value In Column A? (VBA Or Formula)

    Sorry to belabor this but I tried that and it still doesn't work...

    To use bewsh1987's example, it should look like this-

    Old
    Bill Paris
    Bill Paris
    Bill Paris
    Bill Spain
    Bill Spain
  19. Re: Remove Duplicates In Column B For Each Value In Column A? (VBA Or Formula)

    Thank you for your reply.

    Just to clarify, I don't want to remove all duplicates under column B. Using the example in my original post, I just want to remove duplicates for each city; so, for...
  20. Remove Duplicates In Column B For Each Value In Column A? (VBA Or Formula)

    Good day,

    I need to remove the duplicates under column B for each item under column A and I can't seem to figure out how to do it.

    I'm using Excel 2007; I would prefer a VBA solution, as I have...
  21. 'Mode' Text Across Workbooks? (3-D Reference Across Workbooks?)

    I have a series of workbooks that all have alphanumeric data (i.e., the normal MODE function won't work) under column F. I need to find the top 5 by the number of occurences across all workbooks.
    ...
  22. Replies
    5
    Views
    2,922

    Re: Return Pivot Data Grand Total In VBA

    Does anyone know how to return data within a Pivot Table, without referencing a specific range or cell in the VBA code?

    The reason I ask is, the pivot table may change (i.e., additional rows,...
  23. Replies
    0
    Views
    284

    Locking Module/Userform?

    Dear codesters,

    Is it possible to lock or password protect access to just an individual module or userform in the project explorer, rather than the entire VBA project?

    If so, how?

    Thanks,
  24. Re: Does 'CurrentRegion' Include Cells With Formulas?

    Kiitos, jollaisia sir

    I wound up substituting "End(xlUp)" in the code and it worked perfectly!
  25. Does 'CurrentRegion' Include Cells With Formulas?

    I'm testing out some VBA on a sheet with only two rows: one row for headings, one row for data.

    My VBA includes a For Each statment with a CurrentRegion property but the code seems to search the...
Results 1 to 25 of 84
Page 1 of 4 1 2 3 4