correctly

  1. T

    linked table error

    Hello, I am running into an issue where when I tried to enter data in access database, it keeps showing up the pop-ups "name of the data.accdb" is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides". I have...
  2. B

    pivot table refresh data issues

    I don't even know if I know how to ask this question correctly because I've never seen this happen before. I have a spreadsheet with AR data as of 6/30/19 lumped in a pivot table. I changed the AR data to reflect balances as of 9/30/19 and then right clicked on the pivot table and refresh...
  3. R

    Formula problem counting blank cell.

    Hi All, I am running a football tournament and want to automate the data as much as possible. I have created a spread sheet to show the table, but I am struggling to get the Win/Lose/draw to work correctly. I am using the following formula in K3, where J3 is the home score and J4 is the away...
  4. R

    Help with totaling up currency for a game

    I'm trying to make a spreadsheet as a shopping list within a game I'm playing in my spare time but for the life of me, I'm not able to figure out how to add up the values such that it correctly matches the game's values. 100 copper = 1 silver 100 silver = 1 gold An example can be found below...
  5. S

    Spaces causing error

    Hi guys, Would appreciate any advice on the following please. The formula below is functioning reasonably well except for spaces occurring a the end of each returned result. =VLOOKUP([@Column2],'list of part numbers'!A:C,3,FALSE) I have to "Find and Replace" the spaces for the data to show...
  6. E

    Formulas not calculating correctly

    Help! I have spreadsheet in excel, and a few of the cells are not calculating correctly. My worksheet has 4,000+ rows, and one column has the following formula: =IF(AL4051="D",IF(+T4051=1,COUNTIFS(AL$2:AL4051,"D",U$2:U4051,"<3",A$2:A4051,A4051,T$2:T4051,1),0),0) The formula calculated...
  7. G

    macro stops and ends program and restarts Excel

    I have a macro which works perfectly for one search and will display the information correctly. This macro is then cycled by another macro to view other matches for the same sort information which works correctly. Problem is after (about 20 or more) cycles, the total program goes belly up and...
  8. S

    Cannot use advanced sorting after .cvs import

    I have tried over an hour and cannot figure out why it won't sort correctly. I have imported a .cvs file and delimited. I am trying to sort with 2 levels on 2 columns. It sorts fine when I only sort 1 level. When I sort with 2 levels, the 1st level sorts correctly, but the second level I create...
  9. A

    will excel 2002 work correctly in windows 10?

    we are used to to and it does all we want, so are reluctant to update. tried it. didnt like it. so if we update to win 10 from 7/64, will excel 2002 work correctly? thanks all
  10. M

    Help needed with Excel formula using "IF" "AND"

    I am trying to create a formula that will do the following; IF H2 is greater than 50% of I2+JK+K2 then return "***" I am using the following formula but it is not working correctly =IF(AND(H2>+I2+J2+K2/2),"***") Any ideas on what I am doing wrong or how to make this work correctly? Thanks for...
  11. D

    e-mail macro

    hi i have set a distribution list on a sheet... garg, dwight maloney, tony when i run the macro my PC...its fine...but when my colleague runs it, it doesn't pick up the names correctly even if he manually clicks "check names." any idea why?
  12. E

    Excel VBA sheet to word autofit

    Hello With the below code I can export used ranged as table into Microsoft word. When it goes to word the table isn't autofitted, so half of it is not appearing correctly. Is there a way for it to be formatted correctly in the word document Thanks in advance Sub annex() With...
  13. R

    help with if formula

    Hi i have 2 dates and using the below formula due to different months this is not calculating correctly <tbody> 30/11/2018 21:10 03/12/2018 08:00 Late </tbody> =IF(I3< l3,"ok","late") <l3,"ok","late") <l3,"ok","late")[code]<l3,"ok","late")[ Can Anyone Help...
  14. Dan Wilson

    Close function not working right

    Good day. I am running Excel out of Office 365 on Windows10. I have two workbooks that are basically the same. One is for 2018 and the other is a copy getting ready for 2019. After doing some editing, the older version is now closing without asking me if I want to save it or not. The other...
  15. G

    Help With Formula Please

    I am trying to combine this formula =IFERROR(1/1*(IF(D32=1,'Hours Of Service'!E4,IF(D32=2,'Hours Of Service'!N4,"")*1)),"") With this Formula =INDEX(E11:E18454,MATCH(TRUE,(D10:D18454>='Pre Trip Bid Summary'!I24),0))*60 This is one of the several ways I have tried. I have gotten two...
  16. A

    Help formatting a IF AND Does not equal expression

    Can someone help me format this expression correctly? If the state is NJ and the credit card is Amazon then No tax but if the state is NJ and the credit card is anything other than Amazon then tax. =IF(AND(oknshipstate="NJ",okncreditcard="Amazon"),"No Tax", if...
  17. N

    VBA Array problems

    Hi there, I have been having problems with my arrays in several of my sheets. The array doesn't seem to hold all the information, and sometimes it also doesn't show the full text I want it to. I am adding new columns into the sheets, and then changing the vba to match the correct column but it...
  18. A

    If and Weekday

    I am working on a chart that gives the user the option to include or exclude weekends in the forecasting of a project. Have not been able to write the formula correctly for the option to include the weekends. The design is simple: User places a "x" in a cell on worksheet #1 , if they want...
  19. W

    COUNTIF - Formula Not Calculating Correctly...

    I have no idea why the below formula is not working. Numbers in column A are formatted correctly as numbers. This formula is in cell B2 and copied down to cell B6: =COUNTIF(A$2:A$6,"<"&A2) An incorrect result is given in cell B5. I manually typed the results I would expect in column C. Any...
  20. G

    Clear contents

    Hello, expect a silly question, but does VBA code Selection.clearcontents Do the same as if you highlight all the sheet contents and press delete? I have just noticed that some of my code is not working correctly, however after using delete all is correct.

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