help excel formula

  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

    Exact matches when using COUNTIFS

    Hi there, I am trying to use the COUNTIFS funtion to highlight duplicate rows. Here is an example of my data: _____A _________B _____C_______D 1 UserID _____Name __Licence__Duplicate? 2 ABC1 ..............Joe ........1CL** ......=COUNTIFS(A:A,$A2,C:C,$C2)...
  3. D

    Logical formula for calculating until a number has been reached

    Hi Guys, I would like help with creating a measure for the following data. I would like to categorize the products as i did manually for Apples - I calculated the total volume for the product and divided it by 3. Then I would like to start summing from the lowest volume of Apples to the highest...
  4. S

    Count IFs Formula With Dates

    Hello, Currently i'm using the following formula below to identify how many shifts are scheduled by criteria by day. Currently i have to change the row letter for the column each time. is there a simpler way of doing this? =COUNTIF(B2:B4,A7) Example: <tbody> a b c d e f g h i j k l 1...
  5. HeRoseInThree

    Data refresh question

    I have a spreadsheet that has my driver's names (and other data) and another spreadsheet that I use that data for. When a driver is removed from the driver data spreadsheet, I receive an error on the other sheet... The formula works well until I remove a driver. The formula I use: ='[N&I...
  6. 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!
  7. 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!!!
  8. T

    Error on formula (compound percentage)

    Hi, new on the forum, would appreciate some help, I've spent 7 hours trying to figure this out :banghead: I'm trying to insert a formula in excel for Mac 2011& 2016 The formula is: =IF(I2="",IF(F3>0,F3,""),IF(F3>0,(F3+1)*(I2+1)-1,"")) Keeps giving me an error. I'm tryint to reconstruct the...
  9. S

    Index match question

    Hello! I am trying to make a sheet that pulls accrual values. I want to pull text based off of a cell that contains a company name. However, there are multiple lines with different accruals for the same company. I want to pull a specific result (not multiple result). i.e.- I have a carpet...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. R

    Help with a Formula that for SUM of count using three categories (two with single "text", and the third has variable text

    Hi, only a newbie to excel here. I've created a booking card for our small B&B. We offer FULL BOARD and B&B, to which I am trying to run a billing section at the bottom. (screen shot link in this thread) Col E7:E18 [Guest Type] Col F7:F18 [Catering Type] Col G7:G18 [Room Type] Col H7:H18 [Date...
  15. 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...
  16. C

    Help please

    Hey guys (and girls), this is my first post XD... first off sorry if it's in the wrong place and second thanks in advance if anyone can help. =IF($A2=Items!$A$2,Items!$B$2,0) This is the base of my formula, as you can see i'm trying to see if "sheet As" A2 matchs "Sheets Bs" A2 and returning...
  17. M

    How to pastes row of data into another sheet while removing blank lines?

    Hi, I've used conditional formatting on a large set of data to highlight a specific criteria. I have then got formula which gets the highlighted rows into a separate table but the gaps are still there. I was wondering if i was possible to use formula to paste in the rows into another sheet but...
  18. L

    Help with multiple formulas

    I am after some help please on the following if any of you kind people wouldn't mind. I have this formula in a cell working fine =IF(OR(Q27="",Q27="Yes",Q27="N/A",N27="Yes",J27="Gap",P27="Yes"),"",T27-TODAY()) but I want to add another function if possible which would be If V27=Fail...
  19. J

    Referencing a cell that references a table to provide result from the table.

    Hi All, Apologies for the dreadful title, I'm not sure how to explain this succinctly, part of the reason I can't find a solution online for what I'm sure is a simple problem I'm having. I'll explain the setup first: In Sheet 1 I have a basic layout in which Column A is the name of a business...
  20. S

    Index & Match Help.

    If someone could help me on the below scenario, that would be greatly appreciated! I have a list of locations that either pass or fail based on criteria. I have the pass/fail setup. Now I need a formula that will list me all of the locations which failed. I have a formula that will run through...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top