result

Hello everybody. I've a cell assuming different values. For example: 105,32 euro Now, with regex I've removed the non numeric value in order to have 105,32 My code: Dim replacement As Object, trunc As String Set replacement = CreateObject("vbscript.regexp")...

Hello, i would like to know what equation to use if i want to use the below condition if the result is 0% or in negative % then score is 0% and if result between 1% to 25% then score is 25% and so on till i reach score 76% till 100% then score is 100%

I have a array with 500 records and another array with 25 numbers. These 25 numbers are between 1-500. I want too clear all the records in 500 record array which are not in the 25 records array. Array1 10, 20, 31, 32, 45, 50 Array2 20, 45 After matching the result for array1 is 0, 20, 0, 0...

Hi, I'm new to VBA / Macro and need your help on how to prevent the Excel workbook from saving if any cell(s) in a column has a FALSE result from the formula executed in those cells. The workbook can only be saved if all the cells in this column have TRUE result. Thank you for your assistance.

I can't find the 2nd or 3rd Shape I'm want to edit. It locates the 1st one, but not the 2nd or 3rd. I used "record macro" to select the shapes and get the name. Sub PleaseFind() ActiveSheet.Shapes("Rectangle 9").Select ActiveSheet.Shapes("Rectangle 5").Select ActiveSheet.Shapes("Rectangle...

Hello forum friends, Can someone please tell me why this formula is giving me the #VALUE ! error? "&TEXT(D36/(tax_tables!C39),"0%")&" The value in D36 is $1227.32 and the value in tax_tables!C39 is $1154.58. I want to display the result as a percentage. The formula is a smaller part of a...

Hello, I wonder if anybody can help me out. I am trying to get employees names based on their skills columns and return their names as a result in two different tables as a distinct unique values. I was able to do this so far with Index, Match and Countif array formula but it only works for...

I am using a logical 'IF' statement to distribute work to service providers. I have edited this to make it more specific however in certain circumstances the result is FALSE. The formula is below =IF(W2="","",IF(W2="Close Even","U/W Process",IF(AND(F2=1,(LEFT(E2,7))=LEFT(E1,7)),X1,IF(T2="GC -...

Hi, How should I change the 6th line in below code If I want the result D is 8 ? Sub nulltest() A = 4 B = 8 C = 20 If A < 10 Then A = Null End If D = Application.Min(A, B, C) End Sub

<colgroup><col><col></colgroup><tbody> Hi - need help on "Search" formula. Below is the example. When I put the search formula in B1 and B2 it shows the same result as the text continues what I am looking is in B2 it should return error as "Term1" is not there in A2. could you please help how...

Hi all, I am trying to extract out various details from a text string. The fields I am trying to extract are as follows: Field 1 = volume information eg. 10 Field 2 = volume measurement eg. Oz or ML Field 3 = perfume type eg. EDT, Eau De Toilette. On this field specifically, several equivalent...

Hi Team Need two help here, First Help, I am pasting Below excel formula into vba, its not working. it works in excel. '=SUMPRODUCT(ISNUMBER(MATCH($A$2:$A$18,{"A","B"},0))*ISNUMBER(MATCH($B$2:$B$18,{"X","Y","Z"},0)))...

I think I might be going mad. I'm sure that in my previous version in Excel for Mac (2008) I could view the value of an active cell in the status bar. Since upgrading to Excel 365 I can no longer see this info in the status bar. For the sake of my sanity, will someone please help me?:confused...

Hi to all of you, kindly require to provide me support so that a VBA code which should run through col. "H" and where in description doesn't exist number should delete entire row. Therefore that the "1" is heading and the code should run from row. "2" Please see below original data and expected...

hi I have some code I use to transfer huge chunks of data from a sheet in one file to another. Here is the code:- =IF(ISERROR(MATCH(1,INDEX((INT('/Users/SOS/Documents/My Documents/Horse/Football Advisor/Research/Master Data File/2017/Additional/New...

So I'm trying to add a row of cells that contain both letters and numbers. I'm using the following macros: Function add_num(cell1, ParamArray Arr() As Variant) Dim temp As Double For i = LBound(Arr) To UBound(Arr) temp = temp + GetNumber(Arr(i)) Next add_num =...

Hello, Does anyone know on how to combine SUMIF with INDEX MATCH. I have an issue whereby my lookup only identify first result that is in Sample C2. My intention that my formula will sum all the figure in column C i.e 700,000. My lookup value need to be maintain on Account number & Item no...

Hi Team, Need your help in understanding the countifs formula, when I give More Criteria in Array It gives different result. Below formula gives Correct result. =COUNTIFS($H:$H,"South",$I:$I,"NY",$J:$J,"Pending") =SUM(COUNTIFS($H:$H,{"South","North"},$I:$I,"NY",$J:$J,"Finished")) Here...

Hi All, I'm trying to out a condition whereby if my sub produces a "Positive result" then that row gets locked. I'm working with Column B in range of ("B8:B66"): x = ActiveSheet.Range("B8:B66") found = True For Each cell In Range("B8:B66").Cells If cell.Value = "X" Then found...

Hi All, I am having a real hard time trying to explain what am actually trying to do as result so I have tried to demo it below. I need to change this <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Ref Result a123 1 b123 2 c123 3...