help excel formula please

  1. HeRoseInThree

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

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

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

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

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

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

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

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

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

    Is it possible to nest more than 64 in one command?

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

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

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

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

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

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

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

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

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

    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!
  20. N

    Index match with multiple criteria - please help!

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

Some videos you may like

This Week's Hot Topics