two dimensional range

  1. B

    SUMIFS or SUMPRODUCT with 2D data table and vector criteria

    Long-time lurker, first time poster. I've read FAQs, and searched, but suspect I'm using the wrong search terms. I've got a table with two dimensional data. Dates, monthly, along the top by column. Projects, including start date, along the left, by row. I'm trying to SUMIFS the data, such...
  2. E

    VBA for 2-D Lookup with Multiple Returned Values

    Hey there! Have a table with headers of specific locations and a column of dates going back several years. I need a person to be able to search by location and value and return the corresponding date(s) in a pop up box (msgbox). I could probably write a formula but I'm guessing there is a...
  3. S

    Returning Unique Values in Two Dimensional Range

    I have a worksheet that currently has over 25,000 rows (it should double in the next year or two) and 70 columns. I need to compare the results in 60 of the columns and find the unique answers. Using conditional formatting to hilight the unique values is not sufficient for my needs. I...

Watch MrExcel Video

This Week's Hot Topics

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
Top