answer

  1. P

    Scoring participants answers using an Excell script

    Hello, I have registered in this forum to ask a specific question about something that I was told it's possible and you can help me to find out how to do it. I am doing an experiement in which I ask participants to listen to 40 short phrases in German (e.g., Die Haeuser sind sehr schoen) and...
  2. R

    Fancy lookup formula!

    Hi, I need a formula that can look down entirety of Column B and identify all the blank cells that have a corresponding Ref number in column A. The answer I would be looking for is in column D. Apologies for not attaching any files (company restriction prevents me form doing so). If you can...
  3. M

    Another Newb question

    Column A, cells A1, A2 etc have values in it. i.e. 525000 675000 etc. In cell B1, B2 etc I need to know how to get 7% of the first 100,000 and 2.5% of the remaining amount I.E 525,000, 7% of 100,000 plus 2.5% of 425,000 675,000, 7% of the first 100,000 plus 2.5% of 575,000 I can do it in two...
  4. H

    Returning column header of furthest right example of specific text string.

    Hi, Forum newbie here, this site has helped me many times as I've always found that my query has been asked and answered before but not this time hence my first time post. So hello! and I hope someone can help on a puzzle that is beyond my Excel knowledge, hopefully I can explain it correctly...
  5. P

    AVERAGEIFS not giving expected value

    Hi, I am trying to do an AVERAGEIFS formula but the provided answer is not correct. Current formula I have is =AVERAGEIFS(D:D, B:B, ">="&A2, C:C, "<="&A2) I have a long list of sequential dates in Column A, column B is the date a device was sent (or today if not sent), column C the date it was...
  6. M

    Wrong result when using <>

    Hi all I have a raw data table and using sum and countifs to calculate answers. The 2 following formula should in theory return the same answer however the first formula gives the correct answer, but the second formula using not equal to (<>) for 'point won by' is giving the wrong answer...
  7. T

    Excel prompt clicker vba

    Anyone know's any vba code that can automatically select answer from which an excel workbook prompts? Thank you xx
  8. A

    Populate cell value based on a lookup & match from two other tabs

    Hello, I am fairly novice to using excel, and have searched for my answer but am running low on time to find an answer, so figured I would just post to see if I can get a speedier answer. Below is an explanation of what I am trying to do. I have two tabs in a workbook with some of the same...
  9. L

    adding date using date() function

    Hi I have in cell A1=1/1/2019 and I want to add 1 year to that date. So I did this B1 = A1+date(1,0,0) but I got wrong answer <tbody> 01/01/2019 02/12/2019 </tbody> Any idea why? I thought I should get 1/1/2020. Thank you very much.
  10. HomeTek

    Finding the highest total value

    Hi, I have a spreadsheet in which I want to find out which sport has accumulated the most playing time (example below). The answer is of course cricket, but I am having trouble with what formula I need to enter into cell J2 to provide this answer, if anyone can help at all please? I have...
  11. I

    Upon opening worksheet check value is present in userform

    Afternoon, When i open my worksheet i see a msgbox asking if the userform should be opened. Clicking on Yes should only open the form if NameForDateEntryBox.Text has a value in it. Below is my code attemp but returns variable not defined thus i dont see this msgbox question Private Sub...
  12. J

    Creating Random number generator but ignoring numbers given

    Hi I have the following formula in A1 =VLOOKUP(Sheet1!$F$1,Sheet1!$B$2:$C$45,2,FALSE) I want to add to the formula to check if the answer I get is the same as in E2,F2 If the answer of A1 is the same I need it to automatically change until the value is not the same as in E2,F2 Please help...
  13. L

    segrigation of data in 2 cell

    <colgroup><col><col></colgroup><tbody> Agaram 0 55712 63218 64023 65680 77505 87426 Agrahara Dasarahalli 0 33781 41899 43793 47209 52903 55021 77701 78606 86772 88212 88880 Anjanapura 0 39902 42271 44409 44411 53203...
  14. R

    Sumproduct Question

    I have been working on this formula for a couple of days. I don't think countifs can do it and after searching this forum I found this: =SUMPRODUCT(I:N<>0)*(E:E=Q3)*(F:F=55). The prodblem is that it returns 0 when the correct answer should 5. What am I doing wrong? Thanks for the help. Rufus
  15. C

    Average formula combined with IF formula

    Hi, What formula would I use for the following. I have 4 or 5 percentages which I need to average. If any of these 4 or 5 values are 0% then the average would need to be zero. For example if I have 100% 0% 75% 100% - I need the average top show as 0% and not 68.75% Can anyone please help, I...
  16. G

    Help with explaining this formula, Please

    With this formula, why can’t I use the cell example (F7), instead of (65%), when F7 = 10% is where it is? It gives me the correct answer written this way. =ROUND((A2+10%*A2)/65%,2) Thanks in advance.
  17. tsroque

    Creating a Compound Table for a Variable Term

    Hi! This is NOT an compound interest question. I need to create a compound formula or table to reach a desired answer. EXAMPLE: So if I need to decrease 50 by 20%, 3 times (variable) ------------------------ 1) 50 x .8 = 40 2) 40 x .8 = 32 3) 32 x .8 = 25.6 ------------------------ Answer...
  18. VBE313

    UDF involving Split function or Formula Text?

    I created a UDF that calculates how many minutes it takes to complete a certain task. (ex: =MinutesToComplete(1,0.18,10,50,20) ) Is there a way to extract each argument/parameter? (ex: =RightParameter() ) and the answer would be 20
  19. A

    formula to find sum or 2 numbers that could be plus or minus

    I need to find the sum of 2 numbers and those numbers could either be plus or minus. How would a formula be written for that? Not sure if I'm asking the question well, so I'm after this: Example: A1 = .0695 A2 = -.0010 Answer = .0685 A1= -.0695 A2 = -.0010 Answer = -.0750 So, A1 and A2 can...
  20. P

    More than, less than, equal to, cell checking formula question

    I’m trying to query a value in a row/column and depending on the value provide an answer in another row/column. The data I’m checking against is a number sequence which needs to be queried to see if it’s between a series of more than/less than/equal to statements. Ive done these before for...

Some videos you may like

This Week's Hot Topics

Top