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).
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...
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.
Project ID Field ID