vendredi 19 décembre 2014

Trying to return value in excel sheet if a=x and b = y in a separate sheet

I have an excel sheet where I need to enter code to query a separate excel document. It will search column A in the second sheet for each of 7 names. When searching for name 1, each time it finds name 1 in col A, if col B equals E, increment in A1 of the first sheet. So basically, every time my name shows up (which is listed randomly in col 1 of the second excel doc), if E is listed in col 2 next to my name, mark that in the first sheet. I need to find the total number of times my name and E match up. Hope that makes sense.


Aucun commentaire:

Enregistrer un commentaire