correct

  1. C

    Keeping a Public variable always available

    I have this Public colnum As Long Sub Callcolnum() colnum = Round((Date - DateValue("12/20/2017")) / 7, 0) MsgBox colnum End Sub in a modole renamed to COLNUMDECLARATIONCODE and this Private Sub Workbook_Open() Callcolnum at the beginning of ThisWorkbook code. Everything works fine - until...
  2. R

    percentage and numbers

    When i calculate =(c6*e6)/100) = .001, is answer i don't want. C6 is number and E6 is percentage, are from another cell, different sheet. If i calculate manually, and input numbers myself, the answer is correct =(2.8*35.71)/100 result 0.99988 which is format i want not .001 Thank You Rob...
  3. S

    Multi variable optimization through solver

    Hello everyone I am new to this group as well as working on excel marcos. I have made spread sheet where there are two equations (Q1=m1*c*dT and Q2=m2*c*dT) that needs to be balanced (Q1 =Q2) to get such a value of m1 (that utlimately L coming from m1 is same for both m1 and m2). I have made...
  4. G

    >> Daily Schedule

    https://templates.office.com/en-us/Daily-work-schedule-TM02780252hi Hi all, Happy Anniversary to Mr. Excel. I've downloaded the Daily Schedule (Re link above). It's really great tool however the EVENTS doesn't appear in the schedule and I don't know why. It downloads as an excel template...
  5. I

    AverageifS on a range containing Div/Value/Error...

    Hi all, <tbody> 10 Correct Yes 5 Correct Yes #Div/0! Correct 15 #Value! Correct </tbody> I simplified my problem in the above table. I want to use the averageifS formula on the first column using criteria: Correct and Yes. I know I can use a simple criteria: ">0". Is there a way...
  6. E

    Using multiple FIND with TRIM & SUBSTITUTE

    Hi everyone, I'm using Excel version 2016. I have a spreadsheet with 7,517 rows of data in column B. I currently have this formula for finding "EMP" in the text: =TRIM(IF(ISNUMBER(FIND("-",MID(B2,FIND("EMP",B2),10))),SUBSTITUTE(MID(B2,FIND("EMP",B2),10),"-",""),MID(B2,FIND("EMP",B2),10))) I...
  7. S

    Simple - Vlookup_If_Left_with muliple categories

    Hello, I'm trying to categorize a number in a cell for example 4557808818 the formula I'm tying to write is =if(left(a1,1=4),"airbill",if(left(a1,1=5),"online" etc. what is the correct format o write this so it reads the first digit f a string and categorize it? thanks
  8. L

    Data Changes when pulled into Power Query

    I have a data set that I import into Power Query, and it changes the data. Example, a number that should be 162.50 (and reads the correct amount in my data table) pull into PQ as 162. My formatting on my original sheet is correct. Anyone have any recommendations on how to stop this?
  9. I

    I need to test if a formula returns the correct result if given the correct input values.

    I am a college professor who has students complete applied exams in Excel. I have created a "scorecard" that compares the output of formula in a cell to what I know to be the correct output, and if they're equal, assigns them points. For example, imagine the following simplified example...
  10. B

    Auto Colour based on answer key

    Hello All, I have this table below. As you can see in the KEY column, is has the correct answer. In this case it is C. Is there a was to make "WHAT" the correct answer highlight in GREEN? And for the next row it would be D (They're) I would really appreciate it. I have over 100...
  11. K

    How to eliminate a #VALUE! error

    I have this formula that I'm working with and cannot find a way to correct the error. =IF((AND($C$7=T12:T45,$C$13=W11:W32)),"YES","NO") Thanks for any help
  12. J

    autofill formula giving incorrect result

    Afternoon All, i have an excel doc with a Vlookup formula that has worked fine for a long time, now it isn't working and i can figure out while. the formula works great until i autofill but dragging down the the little square in the corner, then the values all mirror the first value instead of...
  13. D

    Excel 365 VBA code to open Excel file from folder and copy data

    Hi all, I need help building a code. The open to the correct folder from input boxes works fine. I end up in the folder holding the data. But I also need it to take the correct file selected and copy that data to the next empty row in a worksheet Any ideas. I want to make it simpler than a...
  14. E

    Compare data in table with Exchange data

    Hi all, Apologies for just dropping in to ask a question but I'm not a programmer by trade and my knowledge of the fundamentals clearly isn't good enough! So I've got a table with the correct line manager for each person but the data that sits on the Exchange server is incorrect. I'm...
  15. P

    How to Add Correct Grand Total for Rows

    <tbody> Col1 Col2 Col3 Col4 GrandTotal Row1 xx xx xx xx MeasureTotal Row2 xx MeasureTotal Row3 xx xx MeasureTotal </tbody> I know how to create measures and the Row/Col entries on my PivotTable are correct. But the Grand Total is not - I assume...
  16. 9tanstaafl9

    Correct password will not work to right-click unprotect sheet, but DOES work in VBA

    Right clicking and choosing to unprotect a sheet, and entering the correct password (correct capitalization too) DOES NOT WORK. My macro that I have used for years to unlock this workbook DOES WORK. Using the same password. I have been using this workbook for 10 years and have never had this...
  17. A

    Alternative to "=indirect" to correct ext data table column change behaviour

    Hi, For reasons better known to Microsoft, references to a specific table column name change when my table order changes because of a change in the underlying external data fields. This doesn't happen in SQL, and I don't like it! I am loathed to embed a sequence of =indirect statements into...
  18. E

    VLOOKUP problem

    I'm using VBA to paste a VLOOKUP formula in one worksheet based on a table array found in another workbook's worksheet. I created a macro in Excel to try to get the correct syntax: =VLOOKUP(G2,[Book2]Sheet1!$B$2:$AH$100000,33,TRUE) but when I try to paste it from Access VBA...
  19. Z

    refer variable name by value from string

    Hi, I have some defined variables where have added some values: temp_1 = "red" temp_2 = "black" temp_3 = "blue" etc. how can I refer to the correct one by text string? msgbox = "temp_" & selection.row
  20. J

    what is the correct excel formula if dividing the whole number using the specific range

    pls. anyone can help me what is the correct excel formula of the below topic? the total qty is 74 i want to divide it using the range 15-20 the result is 19,19,18,18.

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