missing

  1. J

    compain multiple files in one file

    Hi all, I have been compain 100 files in one master file using VBA, Sub GetSheets() Path = "C:\Users\dt\Desktop\dt kte" Filename = Dir(Path & "*.xls") Do While Filename <> "" Workbooks.Open Filename:=Path & Filename, ReadOnly:=True For Each Sheet In ActiveWorkbook.Sheets...
  2. W

    Tool to calculate stock movement

    So I have a table with multiple columns, each representing a store. The rows are individual products while the value is the discrepancy of stock ie we are missing 5 stock (-5). Now I want some sort of tool that can calculate that if I’m missing 5 in one store, I can move 5 from another branch to...
  3. CyrusTheVirus

    VBA To Create (But Not To Send) E-mail Drafts Based On Table

    Hi everyone, Looking for a code that will populate e-mail drafts within outlook, but not send them out, based on information within a table. The table name is Email_Table, and the sheet is Sheet1. Specifically, what I need to populate within the e-mail is: 1) The subject which is in cell B1...
  4. S

    Insert Columns For Missing Dates

    I have report that comes out of a legacy system with fiscal period end dates as column headings and budget values below: <tbody> 1/31/2018 3/31/201 4/30/2018 7/31/2018 9/30/2018 50000 25000 40000 30000 45000 55000 30000 45000 150000 30000 40000 45000 40000 25000 50000 </tbody> I need...
  5. H

    Look up missing number and apply to where #N/A

    <tbody> Table 1 Table 2 Table 3 </tbody> <tbody> DL DM DN DL DM DN DL DM DN 1 SHIFT SHIFT SHIFT 2 1 16 1 16 1 16 3 2 17 2 17 2 17 4 #N/A 16 18 #N/A 18 18 #N/A 16 18 5 3 19 3 19 3 19 6 #N/A 17 24 #N/A 24 24 #N/A 16 24 7 #N/A 18 27 #N/A 27...
  6. M

    Macros do not work when file name is changed

    Hello all this is Mike I want to use a "template" file named CALC_Letter_Matrix_TEMP.xlsm. The macros work fine is this file. An MS Access database is using this template file and changes the name to a permanent file name with a date stamp in the file name. When I open the saved file the...
  7. M

    If Formula Error

    Hi All, I am entering the below formula but it says missing parenthesis =IF(AND(C10>0%,C10<80%),0,IF(AND(C10>=80%,C10<=100%),C7*C10,IF(AND(C10>=100%,C10<=120%),(C5*0.5%+(C7-C5)*1.5%,IF(C10>120%,(C5*0.75%+C5*120%*1.5%+(C7-C5*120%)*2% Can any one help C5 is Domain Target C7 is Achievement...
  8. D

    Question on this formula

    What is it a about this formula on why t wont work? What ()"s missing? Any help will be appreciated. =IF($G$20=$S$22,(B32-(B32*0.3%+1.5,(IF(AND($G$20=$S$23),(B32-((B32*0.15%+0.3)
  9. Patcheen

    adding more to formula

    this formula works perfect until i add more to it =MAX(FREQUENCY(IF(ISNUMBER(MATCH('Match Database'!$H$2:$H$5000,{"Won","Drew"},0)),ROW('Match Database'!$H$2:$H$5000)),IF('Match Database'!$H$2:$H$5000="Lost",ROW('Match Database'!$H$2:$H$5000)))) (which is an array formula)...
  10. S

    Missing Digits.

    I'm looking for a formula starting in K7 that will return the missing digits.The total digits are 0,1,2,3 that’s all and in row F7:H7 are my initial digits. Thank you <a href="http://tinypic.com?ref=2uegrx1" target="_blank"><img src="http://i64.tinypic.com/2uegrx1.png" border="0" alt="Image...
  11. E

    VBA Converting time using TimeValue function

    Hi I am trying to convert a cell that has a time exported as text into a cell that will contain the numeric value of time. I am using the function TimeValue(cell) but I am getting a type mistmatch error. Can anyone tell me what I am missing? this is how I am doing it (in a loop)...
  12. J

    scatter plot and missing data

    I have several columns of data for which I want to plot x-y charts. The first column is the x, and the other columns will be y for different individual plots. There is missing data in the y columns. Excel treats the missing data as zeros, and plots the points along the x-axis. How to avoid this...
  13. Z

    If formula not working right

    Hi trying to get this to work, but returns nothing blank. What am I missing? If name is present return that number ,1 ,2 or ,3 =IF(R2="Yard",1,IF(R2="Yards",2,IF(R2="Tunnel",3,"")))
  14. J

    Missing Toolbar Button / Command

    I'm working on customizing my mac excel 2011 toolbar. Using View/Toolbars/Customize I can add and delete buttons. My problem is I want to add the "Edit Comment" command/button but it's missing from the list. It was there yesterday because I put it on my toolbar but then took it off. Ever since...
  15. G

    Auto email based on cell entry

    Hello all, I have what is hopefully a simple solution to solve. I have a sheet for staff to complete entries into columns A-G a single row at a time. In column H I have a check to make sure all entries are made and return a 1 if anything is missing. In column I u have the users email address. I...
  16. J

    missing Date Finder

    Hello is there a formula or a VBA code to find the missing Date. i have a column that i need to review every month to identify the dates that are missing. example is below. if the column was small as bellow i can identify that i am missing 12/3, 12,4--12/8 712,9. THANK YOU IN ADVANCE...
  17. detweiler

    Using VBA to compare for matched and missing data

    Not being a coder, I found what I would think to be a pretty simple example of code on the Microsoft support site that compares data in two columns to find duplicates but puts the matching data in the column to the immediate right of the selected column. Cool, but not quite what I need. I was...
  18. D

    For Next with Step Loop missing last value..sometimes

    Hi all...my name is Doug. I have been dabbling in VBA for a couple years and probably been a guest on here a bunch of times. I am new member today! I have some code to fill in a bunch of cells with number incremented by a specified value. It is pretty basic stuff but I have found that it...
  19. B

    Missing reference. Can you stop it happening?

    Hello. I have a workbook that I have developed for mycompany & included various marco's & userforms. Occasionally when a useropens the workbook they get an error message. It appears to happen after anOffice update. The error message is “compile error: Can’t find project library”.I know how to...
  20. P

    series help

    Display the missing number in number series. Ex : Colum 1 1 2 3 6 7 8 Missing number is 4 & 5 that will display in Column 2 like; 4 5

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