candidate

Hi I'm trying to write a VB script that states from row 2 to last row; if the sales number (Column C) is greater than 10 then create a new row at the bottom of the data set with the same candidate ID, a date that isn't currently tied to that employee number and the sales number minus 10. The...

As follows: If cells J56 and N56 are not blank then return the value posted in cell E72 only if cell E11 on the worksheet identified as "Candidate Selection" equals the alpha character "C" and cell G11 is not blank, otherwise return a blank cell Tanks in advance for the assistance

Hello, I have many workbooks, each with only one worksheet, containing a wide range of data related to one candidate for a work position. I need to copy specific data from each candidate into a new workbook that will contain all the candidates so i can look in one place for all the relevent...

Hello! Excel semi-newbie here. I need help with a problem I've been tasked to help solve in Excel and it involves figuring out what functions to use to create a formula to pull out the information I need. Sheet 1 = Candidate Information This table has 3 columns: Candidate ID, Zip Code and...

I need the recipient cell to equal the value posted to cell I165 only if cell E10 on the worksheet titled "Candidate Selection" equals "C" ... otherwise the recipient cell is to remain blank

I have a complex set of circumstances that I want to calculate averages from. The array on the left has data of 3 different candidates that were assessed on 5 different metrics by 4 different assessors. For each candidate, the same assessor that scores for M1 also gives a score for a different...

Hi, I really hope someone is able to help me out. I have been looking for ways to resolve this excel challenge :) I have an excel file with 3 worksheets (Overview, Input Data and Current Candidates on Project) Overview is simple. It shows dates for the year, and start date on the left side...

Hi all, I'm having problems with a vlookup formula, I am trying to return a grade in column J using the value in column J. My formula keeps returning the last line from my lookup table (H20 = z), it should be pulling an F as the value is 31. I have tried a Vlookup and an IF function. Both...

Looking for some help, think I need to use a multiple criteria Index & Match. I've done it before but can't get it to work this time. Below is some dummy data <tbody> A B C D E Req ID Job Title Region Candidate Name Start Date 1234 Jobby Job NE AC Slater 1/2/2018 1234 Jobby Job SW Zach...