help excel please

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

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

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

Hello! I found a partial answer on a locked thread here but need just a little more help to make it right for my situation. I have a massive sheet showing data points like the below. The solution in the link above (and showing below) will change one of the * or # but not both - and not...