Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    3
    Views
    61

    Welcome to the lounge. In column B on Sheet...

    Welcome to the lounge.


    In column B on Sheet 1, try: =SUMPRODUCT((A1=Sheet2!$A$1:$A$20)*Sheet2!$C$1:$C$20)

    Change the range (currently row 20) to however many rows you have in sheet2.

    Fill...
  2. Replies
    6
    Views
    500

    Are you trying to take the data in 3 columns and...

    Are you trying to take the data in 3 columns and concatenate all three and place the result in another cell?

    If so, and your data is in A1, B1, and C1, and you want the result in D1: =A1&B1&C1 ...
  3. Replies
    2
    Views
    60

    Welcome. I'm not a strong VB person, but I...

    Welcome.

    I'm not a strong VB person, but I recorded this macro with your original "value" in H2.

    Sub Increment()
    '
    ' Increment Macro
    '
    Range("H4").Select
    ActiveCell.FormulaR1C1 = _
  4. Replies
    8
    Views
    157

    Are you referring to VLOOKUP and/or HLOOKUP? If...

    Are you referring to VLOOKUP and/or HLOOKUP? If so, you can use either with a "block" of data or a more formal table.

    VLOOKUP, for example, needs a value you're trying to find (first argument of...
  5. Replies
    6
    Views
    340

    When I fill up at the gas pump in southern CA, I...

    When I fill up at the gas pump in southern CA, I usually think this is the most expensive LIQUID.
    But, alas, I remember reading some time ago that liquids like King Cobra Venom (by the gallon) was...
  6. Replies
    6
    Views
    340

    It's the sum of the powers of 2 from 0 through...

    It's the sum of the powers of 2 from 0 through and including 63.

    In a related or slightly unrelated question, who is/was the richest individual in history?

    This is quite debatable based on...
  7. How about this: =ROW()&". "&"This is the text...

    How about this:

    =ROW()&". "&"This is the text item wrapped."

    with the column width adjusted so that wrapping will cause the lines to be under the numbered item.
  8. Correct me if I'm wrong, but if I use form...

    Correct me if I'm wrong, but if I use form controls and a set of radio buttons, don't they ALL interact with each other?
    I need, for example, 3 sets of 4 radio buttons where the 1st row of 4 can...
  9. See the sample here.

    See the sample here.
  10. That would be if I could get that dialog box for...

    That would be if I could get that dialog box for ActiveX check boxes and radio buttons. Am I missing something for ActiveX? Obviously.
  11. Border (square) around ActiveX radio button and check box

    I have an Excel sheet that has both ActiveX radio buttons and check boxes.

    In some cases, two of these might lie on top of one cell, so I can put a border on the cell.

    How can I put a square...
  12. Is this what you want? This won't be correct if...

    Is this what you want? This won't be correct if there are multiple matches, however.

    =SUMPRODUCT((A3=Match2!$B$2:$B$177)*(B3=Match2!$A$2:$A$177)*Match2!$C$2:$C$177)
  13. Thread: Geometry only

    by kweaver
    Replies
    5
    Views
    458

    I drew the attachment. I found x = 30. ...

    I drew the attachment.

    I found x = 30.

    Then, rethinking I found a conflict that x could also be 20.

    I can't see where I boofed.
  14. Thread: Geometry only

    by kweaver
    Replies
    5
    Views
    458

    I spent a fair amount of time working it out. It...

    I spent a fair amount of time working it out.
    It required constructing a parallelogram that incorporated the original triangle, parallel to the base and one side...
    I didn't do it the way you...
  15. Thread: Geometry only

    by kweaver
    Replies
    5
    Views
    458

    I suspect it's 30 degrees

    I suspect it's 30 degrees
  16. Thread: Logic Question

    by kweaver
    Replies
    3
    Views
    194

    Well, Maud, you must be a Munchkin since your...

    Well, Maud, you must be a Munchkin since your logic is pretty good. :-)
  17. Thread: Logic Question

    by kweaver
    Replies
    3
    Views
    194

    Logic Question

    1. If all Quarks are Quirks and some Quirks are Quorks, which of the following is necessarily true?

    (A) All Quirks are Quarks
    (B) Some Quorks are Quirks
    (C) Some Quorks are Quarks
    (D) No...
  18. Replies
    8
    Views
    278

    Steve, The original macro had this as part of...

    Steve,
    The original macro had this as part of the formula: RC[-4]:R[398]C[-4]&RC[-3]:R[398]C[-3]

    When you rewrote it, you wrote: R2C5:R1000C5&R2C6:R1000C6

    which led me to think that without...
  19. Replies
    8
    Views
    278

    One of the VB heavies should be able to answer...

    One of the VB heavies should be able to answer this. I'm not! I suspect there's a different approach when using RC references (as Steve pointed out! -- don't use the brackets).

    Why not just keep...
  20. Replies
    8
    Views
    278

    I think it'll work if you make the large ranges...

    I think it'll work if you make the large ranges absolute cell references:

    =ISNA(IF(ISBLANK(F2),MATCH(E2&G2,$E$2:$E$400&$F$2:$F$400,0 ),MATCH(E2&F2,$E$2:$E$400&$G$2:$G$400,0)))
  21. Looking for a formula for max price given an average price

    I saw this question somewhere and wonder if there's an Excel solution.

    I don't know a formula that might solve this, but thought someone might. Here's the post I saw:

    I need help designing a...
  22. You're trying to use a < comparison with cells...

    You're trying to use a < comparison with cells that contain text and that doesn't compute.
    Put the text in separate columns and then use the < comparison.
  23. Replies
    2
    Views
    199

    Would you use SUMPRODUCT of SUMIF?

    Both give the same results.
    Other than a preference for someone understanding the logic of one versus the other, is there any efficiency reason to use one over the other?
    ...
  24. Replies
    12
    Views
    500

    FANTASTIC. And, even better...I'm learning!! ...

    FANTASTIC.

    And, even better...I'm learning!! Thanks, Zeddy.
  25. Replies
    12
    Views
    500

    Maud, I was counting on that working... But it...

    Maud, I was counting on that working...

    But it appears to have filtered on the A column when it should have been the B column. Then, the target sheet where the paste was done ended up starting at...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4