requirements

  1. trishcollins

    vlookup on table column with cells containing multiple entries separated by commas

    I have a table that has a list of requirements from various documents. The table is called "Combined_Req". Each requirement is assigned a unique identifier "ID", that is in the form of "CR-1", "CR-2", etc." I have another table called "Req_by_Category" where I have consolidated like...
  2. N

    Update query is not working - stumped

    I have a table called Score which has records of individuals scores for a certain requirement presented by a vendor. The list of requirements is in another Table called Requirements. In the Score table we have entered a Requirement ID that corresponds to the requirement in the Requirements...
  3. D

    One more return in cell

    I have a spreadsheet when has several different maintenance requirements. The row may have requirements based on weekly, monthly quarterly and annually. My cell returns the "next date due"or a blank if nothing is input and it works PERFECTLY. I'd like to add one more "level"...IF one of the...
  4. Z

    looking up data in a table that has duplicates with different values that are both being reported

    I have a spreadsheet with classes that fulfill certain requirements and all of the classes are listed in a column with their requirements beside them, however their are duplicates as some classes fulfill 2 requirements. I have a table on a separate sheet that has the classes with the duplicates...
  5. B

    Size of Excel file getting unmanagable...

    I've just tried to rebuild from scratch my Master File that I use for sales reporting.. The original was getting over 6MB and is so slow to process even the simplest of changes, and can crash my excel if I have other files open. I haven't even started adding all the required formulas yet and...
  6. C

    If Statement >2 Criteria Delete Row

    If Worksheet.(Sheet1).Cells(i,"AA").Value = "False" And _ Worksheet.(Sheet1).Cells(i,"AB").Value = "False" And _ Worksheet.(Sheet1).Cells(i, "AC").Value = "False" Then _ Then how to I say delete that row if it meets all those requirements. This is what I have now. Dim Lastrow As Long...
  7. J

    Attempting to Perform a Query with Multiple Outputs based on Lookup of Inputs

    Hello, I currently have a large amount of information in a sheet named "Code Requirements Database". In column A I have a code reference, in column B I have a section of the code, in column C I have the code requirement, and then in column D I have the required frequency. In column E I have...
  8. R

    Data Validation based on cell value

    Hi, Can anyone help me on the Data validation based on the cell value. Actual data table as follows; <tbody> 325XX Apple Orange Mango 326XX Black White Blue 327XX Car Bike Bus 328XX Laptop Wifi Mouse 329XX India America England </tbody> Data validation...

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