incorrect

I know the formula that you enter if you to show retail shrinkage. Example: Col. A is how much of one product is supposed to be there. Col. B is how much is actually there. So Col. C would be C1=(A1-B1)/A1. The problem is I have paperwork that has to be filled out with each item that is removed...

I am using a sumif array formula: =SUM(SUMIFS($T$6:$T$3000,$D$6:$D$3000,$B3,$B$6:$B$3000,"Y",$BJ$6:$BJ$3000,{"1,2,3","1,3","2,3",3})) this adds items that have = {"1,2,3","1,3","2,3",3} these different combinations. I realized there is also another option I must consider "2*,3" however when I...

Good day Please assist with the below I did a lot of research and found the below code that works , I only need all the cells with formulas protected and everything else to work Sub Lock_Formulas() ActiveSheet.Protect "pass", True, True With ActiveSheet .Protect EnableOutlining =...

Evening all Unsure why the following is resulting in an incorrect value. Cells(1,7).value = application.WorksheetFunction.CountA(Range("B:B")

Hello all, I have an odd scenario that has just happened to me for the first time with an existing file and macro I have used for some time now. This code was compiled over some versions of the file, but I am not able to reason out this piece and what it is resulting as. Okay, here is my data...

Hello, I am trying to make a formula that looks through a range of cells and returns any cell that does not contain the word ''FALSE". The range is 1 row and 10 columns. Right now the formula works as planned except the problem is that it only iterates through the first 4 cell columns and...

Hi, can anyone tell me the correct way to use dates in a Excel Spreadsheet - I have been entering dates like this : 27/01/2018 which I am told is incorrect. Many thanks

Hi, This is a two part question: 1) I want to be able to calculate a cumulative (running) percentage of growth/loss between the current date and the first date. The formula I'm using (=D85*(365/A86-A2, where D85=39.48, A86=Today(), and A2=1.1.17) is yielding an incorrect response of 3958.85%...

I am currently using the code below. I want to stop the "vbCritical" error if I CANCEL the password input box. I would like it to just exit and do nothing. What am I missing? Sub UnProtectAll() 'Use Ctl+Shift+U To Unlock All Sheets Dim ws As Worksheet Dim strPwd As String...

Friends... I query some data from a URL via Excel, and observed incorrect values being returned on occasion... Correct: On an instance browser shows 872,1830.8,1832.95,1829,1832.35,3711 at the target url And excel retrieves 872,1830.8,1832.95,1829,1832.35,3711 Incorrect: Another...

Hi, Up until a week ago my company used Excel 2013 but we have now been upgraded to Office 365 with Excel 2016. Yay! A year ago I built an analysis template with accumulated weekly sales data with the power pivot addin, and had to upgrade the model to be able to use the report with the new...

I have a macro where I select files to open then my macro runs on each file. It checks cells within a range for the correct data I have everything working except a small part of the code. If Range("D1").Formula <> "=Latest!C5" Then ElseIf Range("D1").Formula <> "=Latest!B5" Then MsgBox "Cell...

Hi, I have a macro that imports a text file, cleans it up, and transfers the information to a printable data sheet for processing. It works great for %99.9 of my users. I have one guy who just transferred from excel '14 to '07 (which is the format my software is formatted for). When he runs...

I have been tasked with creating a pivot table that illustrates what percent of employees in each department have completed Lesson A, which was assigned to them via our Learning Management System (LMS). The LMS spits out a report that lists each assigned person on a separate row. The last 2...

Hi, I have numbers in my excel column showing as follows: <colgroup><col></colgroup><tbody> 27.457 41.051 39.951 27.824 </tbody> I know they are not correct and shows a 1000 separator instead of being a double digit number "27,45" with 2 decimals. I am not able to change that...

Hello, Suddenly, whenever I type a number into excel (for instance "5"), excel then displays one tenth of that number (ie, "0.5"). I can temporarily get around this by typing "5.0" into excel, because it then displays "5". Whenever I paste a number, it displays the correct number as well...