Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Thread: Sheetoffset

    by slam
    Replies
    1
    Views
    94

    Sheetoffset

    My company has upgraded to Excel 2019, and I previously used a morefunc plugin which no longer seems to be compatible. Specifically, I'm getting errors with SHEETOFFSET, which I believe was part of...
  2. Re: Automatically Reorder 77 Columns based on row 1 contents

    Yeah, row 1 is the headers, and all header values are unique.
  3. Re: Automatically Reorder 77 Columns based on row 1 contents

    Since the columns are always in a different order when exported, I don't think I could use a macro recorder. I think I'd have to define the order of the columns in the VBA, based on the contents of...
  4. Automatically Reorder 77 Columns based on row 1 contents

    We have a system with an excel export, but the columns are not in the order we need, nor are they even in the same order each time we perform this export.

    Is it possible to redefine the columns in...
  5. Re: SUMIF with multiple range columns and multiple sumrange columns?

    Yes, my apologies for not specifying. I have access to both, which is why I was able to see it worked in Excel, but not googlesheets. I wouldn't have expected something like this would behave...
  6. Re: SUMIF with multiple range columns and multiple sumrange columns?

    Well, that does indeed work perfectly in Excel, and I assumed it would in googlesheets too, but that's not the case :(
  7. GOOGLE SHEETS: SUMIF with multiple range columns and multiple sumrange columns?

    I have a spreadsheet set out with 10 unique text entries in column A (row 2 through 11), and the same values in column C & E. In B, D, & F, I have a corresponding value that I am trying to sum. The...
  8. Re: Combine Sheet1 from Multiple Workbooks into Single Workbook/Sheet

    I just found some other code, and this seems to have done exactly what I was looking for!


    Sub mergeFiles() 'Merges all files in a folder to a main file.

    'Define variables:
    Dim...
  9. Combine Sheet1 from Multiple Workbooks into Single Workbook/Sheet

    Hi all,

    I've found some VBA online to fulfill my requirements, but I cannot get it to work. Let me explain what I have and what I'm looking for:

    I have ~150 .xlsx Workbooks, with the exact...
  10. Re: Weight Loss Spreadsheet: Tracking new Weight Loss Records

    Might have figured out something myself!


    From cell E5 and down, I can drag this formula down through the remainder of the column:

    ...
  11. Weight Loss Spreadsheet: Tracking new Weight Loss Records

    Hi wonderful people,


    I'm working on a spreadsheet for a weight loss program where a participant receives a financial reward for every full pound of weight they lose. Not sure if that title is...
  12. Player Ranking based on Strength of Opponent?

    Hi all,

    I am working on a sports spreadsheet for a league. It records daily games between players, and then I've got all time results per player, all time results per match up, and some league...
  13. Replies
    1
    Views
    136

    Re: Count all time results for unique matches

    Well, that table didn't work, and I can't edit the post now :(

    Here's an image of the two tables:

    https://i.imgur.com/29Vve0U.png
  14. Replies
    1
    Views
    136

    Count all time results for unique matches

    Hi all,


    I am trying to put together a solution to total the all time result between all unique player combinations. I have provided examples of my data in the first table below, and what I'm...
  15. Replies
    16
    Views
    350

    Re: Nested IF? Maybe AND? Both?

    Sorry, I'm back with one more wrinkle to this. I needed to invert the formula for a second calculation, and that's when I realized I still wasn't explaining the text part correctly.

    K3
    ...
  16. Replies
    16
    Views
    350

    Re: Nested IF? Maybe AND? Both?

    That looks like a whole lot of perfect either way. Thank you both!
  17. Replies
    16
    Views
    350

    Re: Nested IF? Maybe AND? Both?

    If I explained it badly, I apologize. Maybe I should have said if there's text, it should be ignored, and the other column with a numeric value should always be divided by 2. i.e.:


    G3 H3
    8 ...
  18. Replies
    16
    Views
    350

    Re: Nested IF? Maybe AND? Both?

    <h3,"",if(g3 2<g3-h3,g3="" 2,g3-h3)))[="" php][="" quote]
    jproffer: Thanks, but unfortunately, that's giving me 0 for a result for instances where I have text.</h3,"",if(g3>
  19. Replies
    16
    Views
    350

    Re: Nested IF? Maybe AND? Both?

    This works perfectly, but I see a small problem with my data which I didn't account for. I sometimes have text instead of a number in the columns, and this should be treated as a 0 (which I suppose...
  20. Replies
    16
    Views
    350

    Nested IF? Maybe AND? Both?

    Hi all,

    I know this is a breeze for some of you, but I'm struggling a little.

    I have values in G3 and H3. I'm trying to calculate the following

    If G3 is < H3, make the cell appear blank...
  21. Replies
    5
    Views
    269

    Re: Extract non blank rows and adjacent data

    Thanks to all who replied. I went with the formula option, and it works perfectly.
  22. Replies
    5
    Views
    269

    Extract non blank rows and adjacent data

    Hi all,

    Would greatly appreciate it if someone could lend a hand with a problem I have.

    I have a range, A9:G200. I'm looking for non-blank rows in column G. When a value exists (dollar...
  23. Re: Count if Blank when Adjacent column value is 5 through 10

    Perfect, thank you!
  24. Count if Blank when Adjacent column value is 5 through 10

    Struggling with this one a bit. I am trying to count the total blank instances in column H when there is an adjacent value in the 5 to 10 range in column D. Any help would be greatly appreciated.
    ...
  25. Replies
    1
    Views
    85

    Custom Scroll Range on One Worksheet

    Hi all,

    I've been googling this problem for a while, found several "solutions", but I'm not quite getting any of them to work the way I want.

    I'm looking to have the mouse wheel only scroll the...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4