wrong

Hi im looking for a way where i can get a total number of units by a specific date, but not by using a Pivot table. I then want to be able to manually change the date and the new information will appear. The data i have is below, Case N. is column A Etc <colgroup><col><col><col...

Hi Guys, I am slowly beginning to understand the logic for excel, ( I took a basic class in college, but for work I need to be way more advanced). Here is where I am hung up. I need a formula to produce this <colgroup><col width="151" style="width: 113pt; mso-width-source: userset...

HI I am having issues doing an if statement , i seem to get the wrong end result, below is the data i have <tbody> A 1 0.48 2 - 3 0 4 1 </tbody> now when i do this formula below i should get 175 but for some reason i get 75...

I've pulled an excerpt of coding from my workbook_Open coding. When the wrong password is input into the inputbox, the input box disappears and nothing happens. I have to hit the keyboard (or mouse) to have the "wrong password" msgbox popup. Further, if I click cancel, it doesn't close the...

hi trying to set up a job sheet template to keep track of hours and materials on the job can get the material side of things sorted ok item cost quantity and total all add up fine . but when i try sum to add up the hours worked on the job it comes up with the wrong answer ? is there a way to...

Good Morning, I have the following code that's been working well as a "password box" to unlock a few sheets. However, I'd like to tweak it so that the if the password is wrong, it will display an "wrong password" message and then ask for the password again. this is all mounted on userform5 as...

Hi I want to improve the code below so if a user entered a wrong name, then vba will give error message. I tried with IfError() as below but got error message. Thank you so much. Sub mylookup() Dim xname As String Dim xnumber As Integer xname = InputBox("name") xnumber =...

Hi All, try to replicate the below but my both date and previous date can only slicer the sales amount not the previous sales (Previous sales does not change at all). Any ideas what went wrong and is there any other better way to do it...

I am trying this formula =IF(OR($K7="2",$K7="3"),OR($<wbr style="color: rgb(31, 73, 125); font-family: Arial, Helvetica, sans-serif; font-size: small;">M7="LIL",$M7="BEG",$M7="GWY",$<wbr style="color: rgb(31, 73, 125); font-family: Arial, Helvetica, sans-serif; font-size...

I have a pretty complicated sheet that is calculating the average for the last 3 days, 6, 12 and 24 days. I have noticed that the answers fro 3 & 6 days are correct, but the 12 & 24 days are not correct. =AVERAGE(OFFSET(C1,0,COUNT(C2:ZY2)-3,16,3)) is correct answer...

I am trying to multiply 0:35:15*1000 and I keep getting the result of 11:30:00. What am I doing wrong?

I am looking for a formula that will allow me to count text less than 2 and exclude blank spacing. So if it is one letter it would be wrong and if its one letter with a space it will still be counted as wrong. 2 Characters is the min. Please help

What am I doing wrong here? =IF((AND(X3<4,X3>2)),if(AND(y3<4,y3>2)),"YES","NO")

This are the original codes. Module 1 'Sub Test()'' '' Test Macro '' '' Keyboard Shortcut: Ctrl+f '' ' Sheets("Engagement Log").Range("Table1[#All]").AdvancedFilter Action:= _ ' xlFilterCopy, CriteriaRange:=Range("Sheet1!Criteria"), CopyToRange:=Range( _ ' "A6:H7")...

Hello, I would like some sort of data validation, or vba code to stop people entering the wrong information. I have a list of words which gets coloured in conditional formatting. Sometimes people put in the wrong words. For instance i have the word "Holiday" in conditional formatting turn red...

Hi, First time using this. What am I doing wrong that brings about the errors in attached image? https://www.dropbox.com/s/mo6gk6kigrts0me/asas.png?dl=0 Thks,

Good Afternoon, I'm having an issue- I think I've coded "AND" wrong. Right now, with today's date and time, the sheet is kicking a "No" when it should be "Yes" and changing the computer date to December (to see if it says "Yes") doesn't change away from "No" so I figure my use of "AND" was...

What is wrong here? IF(VLOOKUP(C2,Overrides!$A$1:$F$70,6,false)),="",VLOOKUP(C2,'Pricing & Availability'!$A$1:$F$700,6,FALSE),0) I want to test if the first lookup is getting no results (#n/a"), then I want to use another vlookup

Hi guys, Can you help me on my project. I wanted to search the exact product and if does not match a message box error will appear. I have a script wherein when i search a product and when it was empty a message box will appear saying "Insert Product" then when i search a product with a wrong...

I think I'm getting confused with LIKE and Regular Expressions. MyString contains a backslash followed by any 4 digits. if MyString LIKE "\" & "[0-9]" then... is failing. I can think of many ways to resolve this but keen to know where I'm going wrong. Thanks.