Page 1 of 3 1 2 3 LastLast
Results 1 to 10 of 23

Thread: INTERSECT in Excel

  1. #1

    INTERSECT in Excel



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Like a multiplication table, I need to find a value based on both the top row and left column. Excel doesn't have the INTERSECT formula anymore? Or maybe I just lost my head? Thanks for your help, guys.

  2. #2
    It doesn't work off of just the headers, you specify the whole row and column, like

    =A2:C2 B1:B10

    or

    =2:2 B:B

  3. #3
    Okay, so that doesn't appear to be my problem after all. I'm not sure how to design this...

    We want a workbook where each user has their own worksheet.
    The admin creates a specific workout regimen, such as 15 pushups, situps and squats.
    That's for medium intensity. There is also Light and Heavy intensities.
    Then, there is up to 100 different exercises.
    He wants to, for instance, create a week's worth of cycles in advance. The user opens the workbook and chooses their intensity, and it's populated for the cycle for that day that he created. I can't work it out how I'm gonna get:
    Name
    Intensity
    Exercise
    Reps
    Any suggests?

  4. #4
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    356
    Articles
    0
    Anne: If you post a sample spreadsheet with some examples of what you want to achieve, then I'm sure someone can help you out.

  5. #5
    Okay, I posted, but the file was incomplete. I'll fix it up and upload. Thanks!

  6. #6
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Location
    Oregon, United States
    Posts
    106
    Articles
    0
    Was it deleted again? I dont' see it now.. ?
    Regards,
    Zack Barresse

  7. #7
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    356
    Articles
    0
    Something like this? Range retrieval.xlsx
    Or do you want the user to be able to select a different intensity each day?

  8. #8
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Location
    Oregon, United States
    Posts
    106
    Articles
    0
    This sounds like it should be in Access...
    Regards,
    Zack Barresse

  9. #9
    LOL That's what I told him. The thing is, he doesn't even have Excel. He originally wanted Googledocs (again), but it barely doesn't a data validation.

    Thanks, guys. Sorry. I'm suggesting a web-based app with MySQL, which I may actually learn.

  10. #10
    And I heard you laugh just then, Zack.

Page 1 of 3 1 2 3 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •