consultant

  1. L

    index and match

    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...
  2. K

    Drop down list selection causes row to be copied and pasted to another sheet

    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...
  3. T

    Counting unique values with multiple criteria

    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...
  4. M

    Macro Summary and Renaming

    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...
  5. A

    If statement help please

    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...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top