consultant

I have been sitting for hours trying to figure out the formula for one of the entries on my homework!! I NEED HELP BAD!!! What is the index-match formula to get the name of the consultant who knows all of the languages? Thanks in advance...

I have an excel file that when I select "consultant" under "To be processed by" I want the rows values from Date to Status to be copied to another sheet. Sheet 1 called "Requests" and Sheet 2 is called "Consultant". I only need this to be for the consultant selection. I may be excel challenged...

Dear Forum Members, I would like to build a formula that would count Consultant IDs (only once, as they repeat) of consultants with Start Month "04" and the kit "S" (so in my below example the result is 1). <tbody> Consultant ID Start month Kit <tbody> 100731 </tbody> 03 S 100732 04 F...

Hello all, I have an odd scenario that has just happened to me for the first time with an existing file and macro I have used for some time now. This code was compiled over some versions of the file, but I am not able to reason out this piece and what it is resulting as. Okay, here is my data...

Hi, I have column A that has a project ID and a column that has a role related to that project. There can be multiple rows per project: I am trying to concatenate the multiple roles per project into one cell per project. Example Project ID Field ID A Consultant A...