good

  1. J

    SUMIF formula for Criteria that is a range

    Is there a good sumif formula or a different formula that would be good to use for a range of criteria and the criteria is all different but specific to what totals I what pulled out of a larger listing? Thanks!
  2. G

    vlookup 3 sheets

    This is the first sheet <tbody> Student ID Course ID Fall M82922929 A&S 001 M68669689 A&S 012 M78666687 A&S 035 M28262728 A&S 055 </tbody> i got help creating a formula that would identify a mismatch happening. <tbody> Student ID Course ID Spring Status M82922929 A&S 001 Good...
  3. B

    Best Java Script Help Forum

    Does anyone know of a good Java Script forum thats as good as Mr.Excel? Ive got to start learning how to add some script to some pdfs and need help.
  4. gheyman

    Access: Design view problem - only showing SQL

    I am trying to see my query in Design View, but its only coming up in SQL (I am clicking Design View not SQL View). I'm not that good at SQL so I need to see it in Design view. Anyone know how to fix this? Thanks
  5. S

    Compounded If Or Statement

    Good morning all! I need a formula that does the following: If one cell is negative and the other is positive return NA, but if both are positive or both are negative D4 (for example) I know it should be something along the below, but not sure how to write it to function properly. Thank you...
  6. L

    VBA vs Python vs Matlab

    Hi Someone told me learning Python and Matlab is a must these days. Many job ads are asking for to be good in one of the following: VBA, Python and Matlab!! Which one you think it better to learn? Thank you very much.
  7. G

    Perform different calculations based on cell content

    I've looked around and could not come up with a good idea of how to accomplish what I would like to happen. Basically, I have about half a dozen different simple calculations that need to be done in the same cell, and what the calculations are depend on certain partial text that needs to be...
  8. U

    Holiday/annual leave tracker

    Hi my fellow excel warriors, I am looking for an excel template to track holidays. I have found trumpexcel. com/excel-leave-tracker which looks pretty good but I need it in hours and not days. Can anyone help? Many Thanks
  9. B

    IF formula comparing to numbers, and allowing for rounding

    I have three cells. A20: 38.2 B20: 39.3 C20: contains IF formula to tell me if A1=B1, then "Good", if not, then "Check" To clarify, columns A & B contain numbers with decimals, row 20 would be the sum of all those numbers for each respective column. However, due to decimals, the totals won't...
  10. handri

    combining formula

    Good day Here is my code =IF(ISNUMBER(SEARCH(substring,text)), "Yes", "No") The result is in C6 (empty cell). When I put a number in A6 (empty cell). Then the empty cell C6 show the result. The substring is in B3. How to combine formula with my code above thank you
  11. B

    Displaying a chart using a User Form

    Good afternoon all, Is it possible to display a chart/pie chart in a User form?
  12. Y

    Hello Excel gods Please how can I convert a PDF file to Excel is there a good way to do ?

    I always have to do it manually and honestly it sucks, Thanks you guys
  13. L

    Home Service

    Hello, Does anyone know of a good way to keep track of a Home Services business? Thanks
  14. B

    Help! Countif codes..

    Good Day Mam/Sir. In this project , i have to register for an appointment. Sample picture below. as of now, i am managing to save the inputs from userform to worksheet. to finish my project, i just want to add a code that limit the applicant to register for a specific time in a specific...
  15. J

    Countif

    Good Morning how do I count my range is the same but my result is H or T? =COUNTIF(Q38:Q48,"H") Thank you
  16. Joesif

    Vba

    Hi I just wanted some advice really. I'm pretty confident with excel formulas and working but never use VBA so just wondering where I best to start to learn myself. What have other people find works best for them. Are there any good guides knocking about to look at Cheers Joe
  17. P

    wrap text

    Hello good morning, please can you help me, I have the code below but I would like to add a wrap text I have tried .wrap text but it didn't work, can you help please? [CODE]Private Sub CheckBox68_Click() If CheckBox68 =False Then Exit Sub EnRange("F8").Value = Range("F8").Value+ 1...
  18. M

    Google sheets - trying to convert formula to a script

    Good afternoon Demigods, I have the following formula in google sheets: What i am after is the formula converting to a google script. Any ideas please? Best regards manc
  19. S

    if with 2 condition

    I have many account numbers in column A but if account 501000 & 511000 comes then text required in Cell B1 is "Good" else blank. I only know formula as follows, how to add 511000 also in the formula ? =If($A$1:$A$1000="501000","Good","")
  20. Deladier

    QR Code without blank frame

    Hello experts. I need to generate QR Code with Excel,and I already done it using a vba code that I saw in Youtube, it works very good, but I need to get rid off the frame around the QR code. How can I do this?. Here is the vba code:

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top