1. M

    Please help!! Need help with specialized formula.

    Hi everyone, Thank you in advance for your help! <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 142px"><col width="142"><col width="142"></colgroup><tbody> A B 1 10/24/19 =A1+10 2 #b7e1cd[/URL] , align...
  2. O

    error message

    i kept getting this message whenever i try to unprotect one of the sheets i was working in excel today. it said this "the password you supplied is not correct. verify that the caps lock key is off and be sure to use the correct capitalization"....but the password i encrypted on are NUMBERS! does...
  3. A

    Football prediction formula

    Hi I am trying to write a formula that will work out scores for me based on a set of predictions against foot ball scores - I have set out the table below. For each correct result, so for example you predict a 1-0 win and its a 2-1 win you get 1 point. For each correct result and score, so for...
  4. S


    I've discovered this thread from a little time, so if it's possible i post another doubt. I have this formula (really is longer but if a part is correct i suppose that all can be correct as well) =IF(D15<>0,5 +IF(E15<>0,5 +IF(F15>0,5))) I wanna have a total that give me a value if any,one,or...
  5. F

    Ensuring a cell doesn't show a negative number

    Hi, I have the following code in N2 =(E2*0.1)-35 And it is showing a negative number which is correct. The issue is, I want it to show 0 if the number is negative, how can I achieve this please? Thanks again.
  6. T

    Formula Help

    I have the follow formula in cell D26...
  7. L

    Quote Creation Document - Requiring double lookup

    Hi Would anyone be able to help me? I am trying to create a document that will auto populate from an excel sheet with product and pricing, sheet 1 is the quote template, with sheet 2 being the data behind. Sheet 1 - Quote template <tbody> D EFGH I J K 12 Product Desc Qty Unit Price total...
  8. A

    Need help! Lookup function

    Hello! I need help regarding my file. I am working on my cheque warehousing file. I have a sheet that contains all of my warehoused cheques.I need to create a file wherein it can give me same dated cheques in one sheet. Can you please give me tips on how to do it. I used vlookup but its tedious...
  9. M

    Excel - Countifs Formula help with Multiple criteria

    Hi Team, Need your help in understanding the countifs formula, when I give More Criteria in Array It gives different result. Below formula gives Correct result. =COUNTIFS($H:$H,"South",$I:$I,"NY",$J:$J,"Pending") =SUM(COUNTIFS($H:$H,{"South","North"},$I:$I,"NY",$J:$J,"Finished")) Here...
  10. J

    IF with more conditions

    So this is the issue: If Name (column A), Surname (column B) and Mark (column C) match with list of Name (Column E); Surname (Column F) and Place (Column G), then answer is YES, otherwise NO. I tried with =IF(COUNTIFS($E$2:$E$5;A2;$F$2:$F$5;B2;$G$2:$G$4;C2);"YES";"NO"), but didnt get correct...
  11. D

    VBA Scan Data in J and find Required numbers

    So, i have a lot of data in a table, this is from Surveys sent out. A lot of customers don't give the right ticket number, making the data useless, or dont give it in the format i need making it time consuming to correct by hand. I have no control over the survey itself, so cant put limits on...
  12. M

    DAX for checking quantities

    I scrape the wonderful data at Brickset for showing basic DAX concepts, but I'm a bit stumped on a seemingly simple question someone posed. If I have Lego kits A, B, and C, can I create just a measure to tell if I have enough of the correct bricks to build kit D? I can use a helper column in...
  13. I

    Show userform based on cell value

    Currently not at my pc but I would like a userform to only be shown if a specific cell is empty. Would this be correct ? Please advise. If Cell (“B1”) = “” Then Userform1.Show Else Exit sub
  14. K

    How to reduce betting blokes that can guarantee max 1 incorrect

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Here I have a question how to reduce betting blokes that can guarantee max 1 incorrect, what I mean this, for example "Euromillions" playing 8 numbers direct we are playing 56 lines it cost 140€ "Formula=COMBIN(8,5)" if out of 8 numbers 5...
  15. 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
  16. M

    COUNTIFS - Is this correct?

    Hi all, Hope you can help. Think i'm doing this correct but isn't working i think because of dates. My table is A2 to P5000. I was using =COUNTIFS(E:E,T3,P:P,1) Column E:E is dates during the year, Column P:P is number of days which is a calculation between order recieve and order due. T3 is...
  17. 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.
  18. L

    using control form checkbox in excel

    Hi I want to ask a question to the user and give 3 choices answers. Q) What is the color of the sky? [x] blue [] red [] green C1 = correct If user click on Blue then C1 will show correct. So I linked the first checkbox to B1 and I wrote in C1 the following =if(B1=true, "Correct", " wrong")...
  19. H

    Indirect function

    I have a workbook with over 20 worksheets, plus a summary sheet. The summary sheet needs to grab results from each of the worksheets and the results are in the exact same cell on each worksheet. I am using the INDIRECT function to do this. The INDIRECT function works for the first cell, but...
  20. H

    How to select correct range from the cells with formulas

    Im trying to fing efficient and correct logic to select available data on the worksheet(range), which is based on another set of data. Since Im unable to explain the logic required, im attaching the file which features 2 worksheets with 2 colors. 1st worksheet is base and 2nd worksheet is the...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back