subsetting data

  1. L

    Subset rows and columns of excel table using structured reference, extract data into another table

    Suppose I have two excel tables, where TableSmall is a subset of TableBig (TableBig has rows R1-R1) and columns C1-C5. They share some ID column. TableSmall has an arbitrary subset of rows and columns, e.g., rows R5, R6, and R10, columns C3 and C5). I would like to extract data from TableBig...
  2. K

    Create a table from a subset of a range of columns

    I'm new to MrExcel.com, first post. I'm a VBA newbie. I'm tasked with creating a report of Client's with certain project statuses. I want to create this report on a separate sheet that already has some other data. The Advanced Filter almost does what I want, but it has two issues. I don't...
  3. V

    Detecting first occurence and marking others as repeat

    hi I am trying to find the first occurrence of a value within a set of values within bigger series and mark others as repeat values. The table below might help understand better. ID Unique/Repeat Supervisor Remark Count Expected Output A 1 MO NC 7 MO NC A 0 MO NC REPEAT REPEAT A 0...
  4. J

    creating filtered views

    I have about 500 records belonging to the 50 states and about 20 or so regions. A state can below to more than one region. I need to make it easy for the regions to see the data for their states. I could create separate worksheets for each region, but that would be very inefficient to update...

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