expected

Hi all, In my worksheet there are two cells D8 and E8 where I have to input data and the outcome of the formula will be visible on M8 cell. Below is the tabular representation of data input in cells, and their expected output <tbody> Value in D8 Value in E8 Outcome E E 10 NA E 10...

Hi Team, please assist for breaking the lengthy formula line by using line Continuation When I tried getting error message, compile error expected list seperator or) its working formula Range("m2").FormulaR1C1 = _ "=SUMPRODUCT(ISNUMBER(MATCH(R2C8:R239C8," & cr1 &...

Hi, I wonder if anyone could help as I have been wracking my brains. I have set up a fomula to lookup against data on a different tab on the SAME workbook. Example below - this lookups the tab number noted on cell D21 of the current sheet, finds the 2nd column (column B) against the lookup...

Hi, I'm looking for some help in building a dynamic list from a range with multiple constraints without using the Excel standard filters (I'm trying to improve my hockey pool performance by drafting faster and more efficiently!). So basically, I have a list of 800+ players with different...

I am using 2 embedded IF statements in the attempt to produce either a string (cell&cell...) or a string with -SPARE are the end. I know the inner IF statement works as expected. The result is setup to work on the FALSE, not TRUE for desired output. My outer IF works when I do not include the...

Hi to all of you, kindly require to provide me a VBA code so that to run through col "H" and should clear any numbers or symbols and adjusting the remaining text on left align. An example is below by which i present the original data and expected result. Thank you all in advance Original data...

I hope this is not too trite for the forum.:confused: I have 16 numbers in a vertical list, which I want to convert to horizontal. I am using Control+C, selecting an empty cell then using Paste Special, ticking Transpose, then OK. instead of the expected horizontal list of numbers, all that...

How can i get the relationship among this 4 variables a = no of days = 30 b = rates/number of holes/ma = 315.81 c = expected monthly target (number of holes) = 240 d = expected production amount = 75,795.36 (Naira) regards

Hi all, Kindly advice me for a VBA code so that to move the duplicate numbers from credit side which is col. "J" to col "I". Note that the code should move the second number. I present below an extract of original data and expected result. Thank you all in advance Original data <colgroup><col...

Hello I have some code that is on paper( I think ), should run fine. When i use debug, I can see that all is going well and as expected. But when i do it outside the debugger, and on my sheet, it doesnt run as expected. I have quiet a large code snap, and would rather attach the excel...

I'm getting an error 'Expected =' and I'm not sure why. This is the line it didn't like. Sheets(1).copy(after:=Workbooks("Report").Worksheets(Workbooks("Report").Worksheets.Count)) I'm trying to copy a sheet to a different wordbook. Any help with the error would be appreciated. Thanks

Hi I've got two columns of data (A and B) and I'd like to sum the data in column B that is either "Checked" or "Partially Checked" in column A - please see the small sample below. The sum should be 40, in this case. I've used this formula, but it's not returning the expected result. Can...

I am using this formula which works fine: =IF(ROWS(K$62:K62)>SUM(COUNTIFS(accounts_table[§],{"P","B"})),"",INDEX(accounts_table[Account Name],SMALL(IF(ISNUMBER(MATCH(accounts_table[§],{"P","B"},0)),ROW(accounts_table[§])-ROW(INDEX(accounts_table[§],1,1))+1),ROWS($K$62:K62)))) However, I need...

Hi all, kindly require to provide me a VBA code so that to run through col. "A" and should replace the number from left side which "2" into "1". I present below original data and expected result. Thank you all in advance original data 1205000 1206500 1207700 Expected result 1105000 1106500...

Given the following with expected results: <tbody> Point Pm10 Rank 1 .12 2 2 .13 1 3 .12 3 4 .12 4 1 .12 3 2 .15 1 3 .13 2 4 .11 4 </tbody>

I have been trying to figure out how to apply my expected result using a separate tab lookup. The section to the left is what I am trying to populate the expected result from the section on the right. I need to match the agent columns together then plug the tax treatment in the expected result...

Hi to all of you, kindly require to provide me support for a VBA code so that where is the text “Grand Total “in col. “A” should prepare the formula with in col. “J” =SUM( H-I + J12) Therefore that, the row which contains the text “Grand Total” is not stably but cell “J12” is fixed, same cell...

I amtrying to get the value of the difference between two times with the code below. tdiff = ((CDate(Me.uf9a_tb_cend.Value)) - (CDate(Me.uf9a_tb_cstart.Value))) - 0.5 .Cells(drow, 5) = Format(tdiff * 24, "0.0") Me.uf9a_tb_cend.Value = "3:00 pm"...

Hi All I am applying a filter to a column where sometimes no data will be found (as expected). Can someone help with code to step past the 'Runtime 1004' error so the macro carries on? Thanks Selection.AutoFilter ActiveSheet.Range("$A$1:$Q$2000").AutoFilter Field:=13, Criteria1:=RGB(204 _...

Hi to all of you, I would like use a vba code so that to run through col. “A” and where the find the text “Grand Total” then to clear any contents in adjacent cells’ range “B”: “J”. I present below an extract of original and expected result. Many thank in advance to all Original data...