multiple fields

  1. LxQ

    find unmatched when comparing multiple fields

    I have tables that have similar data and I'd like to find unmatched records based on combinations of fields. For start, let's say I have two tables, each of them having a class_id and a mod_id field as in the following example: table1 class_id mod_id class001 mod001 class001 mod002...
  2. K

    Dynamic Pie Graph - based on two dynamic fields

    Any help is much appreciated. I apologize if it's hard to follow. I initially wrote it up in an excel attachment, but it looks like I can't attach workbooks to the thread. :( Please let me know if I can clarify. Thank you! Data Collection: Three separate teachers each surveyed their 12...
  3. T

    Creating a multiple field search function in excel VBA

    Hi there! I need to build a linked search function in VBA that also auto-updates after you enter data into the given search fields. I have been able to do this successfully with the following sections of code: Autofilter search - in a standard module Sub FilterTo1Criteria() With Sheet3 If...
  4. K

    Remove rows based on multiple fields

    I am looking to exclude a specific item from my query that is based on multiple fields. For example if I have a database of cars, greatly larger than shown below: Make | Color Ford | Red Toyota | Blue Chevy | Green Ford | Black I can't get Access to exclude only red and blue Fords. My...
  5. W

    SUMIF of multiple occasions

    Hi All, Im trying to find a formula that will allow me to return a sum from one column every time a match is found in multiple other columns... The book is detailing work done on different projects during the week and reporting the total time for each project for that week <tbody> Mins Time...
  6. J

    Looling up the value using multiple columns

    I have two tables. <table style="border-collapse: collapse; width: 108pt;" width="144" border="0" cellpadding="0" cellspacing="0"><col style="width: 35pt;" width="47"> <col style="width: 40pt;" width="53"> <col style="width: 33pt;" width="44"> <tbody><tr style="height: 15pt;" height="20">...

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