list criteria multiple

Hi again - So I am trying to compare lists. I have 3 workbooks that I am using. #1 - Has Mandated Classes with staff names #2 - Has training records for all staff (current and retired) #3 - Is a master reference workbook What I'm trying to do is In #1 - create a formula that will look...

After a solution to a problem I'm having with generating a list that is populated with entries that are defined from a separate table. So I need to generate a list that looks like this <tbody> North East South South South South South West West From a table that is...

Hi, I'm trying to reference a specific list and find a match in an array that has the most commonalities with that list. The goal in the table below would be to return the name "Larry" as he has the most matches to the target list. <colgroup><col width="88" span="6" style="width:66pt">...

I have a form one of my departments uses. I want the list to populate according to the previous entry. For example, if FRMCOMBO3= MyArray(25) = "ND-NEGLIGENCE DEFENSE", then in FRMCOMBO9 only list Insurance or slip and fall. Right now FRMCOMBO9 just lists all the case types. I would like...

Hi All, 2 quickies (I hope): 1. Want to turn 201607 into a Month format "Jul" - whats best formula? 2. Once I have identified a start month ex. Jan (in that format) in cell A1 and end month Sep (in that format) in cell A2 I want to create a list with all the months that fall between cell A1...

Hi all! I have the following code which MickG has helped me with on this forum. Dim Rng As Range, Dn As Range, p As Variant, c As Long, Ac As IntegerWith Sheets("Candidates") Set Rng = .Range(.Range("I1"), .Range("I" & Rows.Count).End(xlUp)) End With ReDim ray(1 To Rng.Count, 1 To 5)...

Hi, I have a really long list of data that I'd like to summarize into a Master file. The long list of data I have is like this: <tbody> Project Number Project Name Project Type Project Status Staff Name Week Ending Date Hrs Base Cost Rate TS Code 1 Alpha Absence On Going Adam 01/11/2015...

Hello all, this is for Excel 2010. Column A - list of staff Column B, C, D, E - day of the week they can work (Mon, Tue, Thurs, Sat only) <colgroup><col><col span="6"></colgroup><tbody> <colgroup><col><col span="6"></colgroup><tbody> A B C D E F 1 staff A Mon Mon 2 staff B Mon...

Hi there, I have a question I am trying to solve. I have used INDEX/MATCH/ROW/SEARCH functions, in different permutations, but I am unable to get the result. I am hoping one of the Excel experts can help me out: The data set is something similar to the below: <tbody> Car Region Own Use Color...