Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    6
    Views
    102

    Could you post the Excel workbook? What's the...

    Could you post the Excel workbook? What's the format for the O column?
  2. What a GREAT idea! I just ran it for 79K rows...

    What a GREAT idea! I just ran it for 79K rows and it was 2-3 seconds!

    I have to do this latest date with three different breakdowns, so will just modify this based on the columns and run three...
  3. When the Bn text matches the B col range AND the...

    When the Bn text matches the B col range AND the On text matches the O column range, grab the dates from H and find the largest date.

    The B col contains concert performance names, the O column...
  4. Recalc nightmare...hope there's a better way

    I have a client file that's very large (92,129 rows). There are (only) a double handful of calculations being performed, but recalc takes forever.
    I suspect it might be mainly due to two columns...
  5. Replies
    14
    Views
    468

    While not a VBA expert, I'm sure someone will...

    While not a VBA expert, I'm sure someone will come up with a solution.
    They data representation is not the same as mine was where the VBA solution worked.

    [PS, I've done your situation using an...
  6. Replies
    17
    Views
    1,320

    [SOLVED] Revised here.

    Revised here.
  7. Replies
    17
    Views
    1,320

    [SOLVED] Assuming row 1 is a header row, I put these two...

    Assuming row 1 is a header row, I put these two formulas in C2 and C3, respectively, then filled down C3

    =IF("U"=B2,A2,0)...
  8. Replies
    17
    Views
    1,320

    [SOLVED] What will you do if Item 1 and item 2 are SOLD?

    What will you do if Item 1 and item 2 are SOLD?
  9. Replies
    8
    Views
    395

    Maud: slick. Thanks. P.S. How's the snow...

    Maud: slick. Thanks.

    P.S. How's the snow there?
  10. Replies
    8
    Views
    395

    The data is confidential so I can't post a real...

    The data is confidential so I can't post a real file.

    I did what I needed to do by grabbing ALL of the data from the 26 sheets into one matrix.
    Moved the array to APL (programming language for...
  11. Replies
    8
    Views
    395

    Zeddy: I have a list of them all, and could put...

    Zeddy: I have a list of them all, and could put that in the new or old workbook in a separate sheet so that the new workbook could have the tabs named that way (with, of course, the size...
  12. Replies
    8
    Views
    395

    Extract data from multiple sheets

    I have a workbook with 30 sheets. 26 of them are labeled AA, BB, CC, etc.

    Row 1 in each of the sheets is a column heading.
    In column B of each of those 26 sheets I have a "specialty" that is...
  13. Does this do it?

    Does this do it?
  14. Replies
    3
    Views
    332

    41009

    41009
  15. Word files with Excel links going to the cloud.

    (I don't have any files to upload as an example, but probably can get one).

    Someone I met at a meeting said the following -- so, was wondering if someone has been through this exercise and has a...
  16. Replies
    3
    Views
    332

    Exponent complication

    I saw this problem which was supposed to be simplified so that there were NO NEGATIVE EXPONENTS and NO FRACTIONAL EXPONENTS IN THE DENOMINATOR.

    I'm not sure that's possible, but I'm still...
  17. Replies
    3
    Views
    153

    Thanks, Maudibe...I guess there's not formula...

    Thanks, Maudibe...I guess there's not formula equivalent to the UDF, so that's my only option?!?!

    Scott: Thanks; I know about HYPERLINK but in this case the cell isn't an email address nor a web...
  18. Replies
    3
    Views
    153

    Copy text and hyperlink

    I have copied cells using INDIRECT(formula) and only the text appears in the target cell.
    The original cells are hyperlinked to URLs. I'd like the new cell to have the original text AND also be...
  19. Replies
    15
    Views
    655

    Unless I'm missing something (again), I think my...

    Unless I'm missing something (again), I think my original approach provided different colors for today's date for max and min.
  20. Replies
    15
    Views
    655

    For the max, I think this might work as the...

    For the max, I think this might work as the conditional format for all rows in the range:

    =and(b2=today(),A2=MAX((dates=TODAY())*changes))

    I did this for the MIN:
    ...
  21. Replies
    4
    Views
    258

    He had lung cancer.

    He had lung cancer.
  22. Replies
    4
    Views
    258

    One of the best routines was Belushi doing Cocker...

    One of the best routines was Belushi doing Cocker WITH Cocker doing himself. A classic.
  23. Replies
    4
    Views
    258

    Joe Cocker -- one of the BEST

    Joe Cocker
  24. Thanks, dg1261. I pointed out to the client that...

    Thanks, dg1261. I pointed out to the client that what they were trying to accomplish was probably not legit, as you pointed out.
    What they're planning to do is reduce the employee compensation by...
  25. [SOLVED] Adjust salary cell to reflect employee absorbing all of the FICA

    I'm drawing a blank on the math I need for this.

    Normally in the U.S., FICA is shared equally between the employee and employer.
    I have a situation where the real compensation is, say, $30,000. ...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4