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

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

    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


    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


    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:

Some videos you may like

This Week's Hot Topics