wrong

Hi, Good Day to All of you :) I am using 4 conditions to the same set of data which the range of is D62:D1550 Condition 1 : Cell Value > Less than > 01/10/2018 Condition 2 : Format only Cells with > Blanks Condition 3 : Format values where this formula is TRUE > =istext(D62:D1550) Until this...

=SUM(COUNTIFS(D5:D15,"Mountain Blue",A5:A15,"*"&{1,2,3,4,5,6,7,8,9}&"xWindow*")*{1,2,3,4,5,6,7,8,9}) Counting window colours from Accessories Colour column. this works fine if its 1-9 in the Extras … but when its 10+ the result is wrong. What is the best way to make {1,2,3,4,5,6,7,8,9} …...

Hi All My data has all dashes displaying as "~". When doing a VLOOKUP, any parts with the "~" (example here A~2405~4) will not register, or comes up as an error. If I try to do a find / replace it will not find the "~" I know it's something simple I'm doing wrong, and appreciate the help Mark :)

Hello, i have some data as below and i need to Multiply Completion% in status Report by Measure 1 but i found error as in measure 2 & measure 3 in measure 2 i have wrong grand total in measure 3 i have errors as in first 2 rows whats is the solution ?

I've been working with a lot of data, many tabs, and macros in my excel worksheets, and I've recently lost all of the tabs that were in the sheet except for the first/original tab. This has happened twice on two different worksheets - I save it, close it, and when I reopen it, all the tabs have...

Hi guys ! Who can help? I need to visualize data in several coordinate systems - cylindrical and spherical. This is necessary for more accurate results. Is there a tool that will allow you to do this ? Please move the topic in the right section if I'm wrong.

Trying to make this autofill dynamic by adding 2 cell variables - any ideas what I am doing wrong? Thanks. With Sheets("Data") .Range("A" & .Range("AD8") & ":" & "A" & .Range("AD10")).AutoFill.End(xlUp).Row End With

I have an existing workbook done by a previous employee...I am having several formula issues so in an attempt to teach myself whats needed and do refresh the workbook I am recreating it from scratch. I have already hit a roadblock though. Firstly this file basically acts as a "to do list". The...

Ok I'm trying to get a lookup function within another sheet & I'm completely lost :confused: hoping someone can direct me.. current formula reads: =IF(ISNUMBER(VLOOKUP(A2,Expenses!$A$2:$E$21,5,100)),"YES","NO") where if the amount in E2:E21 has an output of 100, the answer would be yes. The...

Private Sub Inputtest() Dim intResponse As Integer intResponse = MsgBox("Do you want to do work?", vbYesNo) If intResponse = 1 Then MsgBox ("Good Choice") Else MsgBox ("Wrong Choice. Try Again") End If End Sub The code doesn't run as i expect. When i answer yes i get wrong...

Hello, I can't figure out what's not working with this formula, For example this is the formula below. When I try and look into the WaxMan sheet it is returning 'FALSE' but when I do the mid-summer one it returns the value i'm looking for, both mid-summer and waxman sheets are identical, so...

I have in column B the following formula IF(F2>8997543,(LEFT(H2,(FIND("/",H2)-1))),(LEFT(H2,(FIND("-",H2)-1)))) This returns a unique reference which I then want to run a vlookup off in column C =VLOOKUP(B2,lookup!J:K,2,FALSE) I was going to nest the lookup but even separate I'm getting #NA...

I have tried to block just a few cells with formulas in a sheet leaving free the rest of the cells to be filled by variables if needed, I followed the Microsoft title "Lock or unlock specific areas of a protected worksheet" with NO success I wonder what I did wrong this is what I did: I...

Hi there, I am having some trouble getting my code to work. I would like commandbutton1 in sheet1 to hide so it is not visible when the form is printed by the user. Could someone please help me to identify where I am going wrong with my code? I have posted it below. Private Sub...

<a href="https://ibb.co/iG32we"><img src="https://preview.ibb.co/m6oD2K/Capture.png" alt="Capture" border="0"></a> What am I doing wrong?

I am using vlookup and the lookup up value does not match because of spacing. how can I fix the issue? This is my formula I used. i tried True and it came up with the wrong number. =VLOOKUP(B67,Data_Sheet!C:F,4,FALSE)

Hi, This is my formula: =IF(O4="","",SMALL(IF($C:$C=O4,ROW($C:$C)),COUNTIF(O$4:O4,O4))) I want to add if($b:$b=n2,ROW($b:$b). I tried putting it in the middle but it says theres an error in the formula, what am i doing wrong? Rgs Steve

Hi all I have code = sheets("sheet1").cells(j,1) 1. Now i written = sheets("sheet1").cells(j,"A") 2. Or = sheets("sheet1").cells(j,x) with x = sheets("MAIN").range("D1").value then I type A on D1 sheets("MAIN") Please tell me 1. and 2. wrong code? If its can run so have any diffriend between...

Hi group, I am working on a piece of code that seemed to work in the past and now I am getting a weird error? "Error 450: Wrong number of arguments or invalid property assignment". I have marked the line with the error below. I have tried several variations of the line to see if I could...

I have been trying to get my combo box (cboARNumber) to update fields in the form "Plan Details" which include: ARNumber AdviserName AdviserSurname AdviserPractice DealerGroup Mobile Email It should be straight forward and worked when I did it on my first record but won't work on new records...