help excel formula please

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

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

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!

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

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

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

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

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

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

I have a LARGE nested formula. it works great, except I need it to be bigger. =IF(AA4=AD16,AB4,IF(AA5=AD16,AB5,IF(AA6=AD16,AB6,IF(AA7=AD16,AB7,IF(AA8=AD16,AB8,IF(AA9=AD16,AB9,IF(AA10=AD16,AB10,IF(AA11=AD16,AB11,IF(AA12=AD16,AB12,0))))))))))))) I need it to be up to 99. Is there a way...

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

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

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

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

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

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?

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

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?

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!

Hi Please can anyone help me with the formula for INDEX MATCH with two lots of criteria. Data: <tbody> Site Code Supplier A A0001 Company X B A0001 Company Y C A0001 Company C D A0001 Company Y B A0002 Company X B A0003 Company A D A0002 Company B...