array data selection

  1. jinxz72

    Find Row with 2 columns matched value on one worksheet from Range of 3 columns & 2 combination different worksheet

    Yikes! It sounds horrible but here goes... Using Excel 2010: Worksheet 1 - Need to find C (Status) from Worksheet 2 <TBODY> A B C 1 Business Name Address Status 2 Joe's Bar & Grill 1111 Main St ? 3 Ace Shop 4186 Power Inn Rd ? 4 Thomas Train 1717 Rail way ...
    • jinxz72
    • Thread
    • array data selection excel 10 index match match multiple criteria multi worksheet
    • Replies: 0
    • Forum: Excel Questions
  2. S

    Array Formula?

    I think I'm close to finally figuring out my issue and I think I need to use an array formula. The trouble is, I'm not too great at array formulas. Here's a simplified version of what I'm working on. I have a sheet that has a list of programs down column A. Across row 1 I have the check...
  3. P

    Array to pull out only visible worksheets

    Hi, I have to recognize that every time I work with arrays in the code drive me crazy at some point...and this is not the exception...basically I modified a code I found to create an email and attach an specific set to worksheets...and it worked, now I took the same and added a part in order to...
    • PVA0724
    • Thread
    • array data selection attachment email email visible worksheets
    • Replies: 2
    • Forum: Excel Questions
  4. K

    Using an array that contains a subset of data in a formula

    I am trying to reference an array that represents a subset of data in a formula. For example, lets say I have a spreadsheet with the following 3 named ranges: <COLGROUP><COL style="WIDTH: 54pt" span=3 width=72><TBODY> MyRng1 MyRng2 MyRng3 A 2.58 Z A 3.16 Z B 1.19 Y A 2.45 Y D 3.1 Z...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top