help excel formula please

1. search and display names

My company hires few people, yet many apply. That being said, I would like to sort through the list of applicants to determine if they have previously applied as to not waste time on someone that we have chosen not to hire. I'd like to search their name in a cell (k12) and have it display a...
2. Using "OR" statement with DATEDIF

Good morning! I need help with a DATEDIF formula. This is my original formula: =ROUND(IF(YEAR(AC93)=2018 & MONTH(AC93)=8,"0",DATEDIF(AC93,"8/1/2018","m")/12),0) It works perfectly when the date in cell AC93 is 8/1/2018, which is what most of the 1,000+ employees I'm calculating years of...
3. =large question

My formula =LARGE(AE\$2:AE\$999999,AK2) works great BUT if it locates a duplicate value, it reports the first of the two twice. Is there a way to correct this? Thanks in advance!
4. Count number of times each name is listed between certain dates

UGH. OK, I would love to be able to count the number of times a name is displayed in a particular date range. The names are listed in column B, all of the specific dates are in column H and the date range is AM1:AN26 (AM1 is 1/1/2018 and AN26 is 12/31/2019). I will appreciate any help!!!
5. Separating first and last names

I have a list of names (first and last) and I'd like to separate them into 2 columns. Wait, I know how to do that, I wouldn't waste the time of this forum for something that I can Google. The issue is that the column of names is a formula from another company that I have no access to. How would...
6. Need help pulling sums by month from data sheet

Hello, and thank you for any help! My existing data sheet columns are "DATE , PART# , GOOD PARTS , REWORK , SCRAP I am trying to make a new sheet that can pull sums of GOOD PARTS, REWORK, SCRAP by month and part # from my data sheet. So on my NEW excel file I would like to have multiple...
7. Need help with a EXCEL formula or Function to combine the headers names after trim based on specific the cell data

<tbody> A B C D E F G H I 1 TESTF1 TESTF2 TESTF3 TESTF4 TESTR1 TESTR2 TESTR3 TESTR4 RESULT 2 YES NO YES NO YES NO YES YES F1, F3, R1, R3, R4 3 NO NO NO NO NO RESULT 4 NO RESULT </tbody> Need help with a formula or function to get a result, if the cell has "YES" or any...
8. Formula to check the header name and return the cell data for a specific row

Excel formula for the following condition given in the table <tbody> F1 F2 F3 R1 R2 R3 Check Result 1 2 1 1 2 1 F1 1 1 2 2 1 2 2 R3 2 1 2 2 F2 2 1 1 1 R3 0 </tbody> "Check" column has the header name to be verified and return the cell value in row in the "Results" column If the...
9. Formula to compare various cells in a row and give result if it is common in multiple cells

Dear All, Need help with a excel formula to compare various cells in a row and give result if it is common data in multiple cells Condition: - if the cells have a common alphanumeric in a row, at least two or above, then print it as result else "No Result" - different alphanumeric can be...

11. Add number of people based off of hire/termination dates

I need to calculate the number of people employed at a certain time frame. How many hired before january 1, 2018 and still employed on January 31, 2018. The same for each month after... Hire date is in column H and term date is in column I. If they are still employed add them all up. If not...
12. Help with possible Index Match Match?

Hi All, This may be an impossible task so bear with me. I have the following raw data: <tbody> Owner Account ID Industry Industry# Account # Joe 1 Plumber Primary Industry Primary Account Joe 2 HVAC Secondary Industry Secondary Account Bob 3 Plumber Primary Industry Primary Account...
13. Merge duplicate data across different columns and return sum of its qty

I have data being entered into non-adjacent columns that I want to merge, sum then remove the duplicated name. I do not have a master floor type list to query as there are over 50k types. Example, Floor Tile. There are potentially 5 different floor tile types being entered per row (house) and I...
14. Need help with formula when data changes in column

I have a sheet with thousands of rows of data. I have one column with different 'stations'. For example, column D is where my stations are and the data is 1A, 1B, 1C, 2A, 2B, 2C, etc. Each station has approximately 1500 rows/incidents of data that pertains to it. One of the columns...
15. Nursery Calendar/DOB

Hi, Can anyone get their head round this please as I’m totally stuck!! I have a column with Date of Births and a row of dates above. The idea of the table is it provides me with a planning tool for the children in our nursery. What I would like it to do is calculate the age according to the...
16. Alphabetize column with formula, not filter

I am trying to sort column u (u1:u84) and My co-worker hooked me up with this formula: =INDEX(\$U\$2:\$U\$88,MATCH(ROWS(\$U\$2:U3),COUNTIF(\$U\$2:\$U\$88,"<="&\$U\$2:\$U\$88),0)) It works great, except it left out 2 names. I messed around with it and can't seem to get it. Any ideas?
17. Trying to create cell from duplicate values.

Hi all First time posting and hope we have an Excel guru. I am trying to use a running list of names (below is dummy data), and then count the times the name appears: Source Name John Sally John Dave Dave John Sally Mick Resulting in something like below in a new Spreadsheet page Result...
18. Count dates

I am looking to count the number of times the event took place in January (1) or December (12). I custom displayed the month to just 'mm' and used the formula =countif('Driver Data'!AO:AO,"01") for January or =countif('Driver Data'!AO:AO,"12") for December Any ideas?
19. HELP - conditional formatting???

I have data that totals values for me, however I do not want or need the total information. Is there a way to search if b:b has "*total" that it changes the color of the text (conditional formatting) to white for the rest of the row? Thanks in advance!