correctly

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

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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.