expected

  1. E

    Formula Audit

    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...
  2. M

    vba Lengthy formula split help

    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 &...
  3. D

    Excel Lookup and SUMIF to data on Different Workbook **Help Please**

    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...
  4. G

    Extract dynamic list from a range without filters

    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...
  5. L

    IF formula output not expected

    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...
  6. P

    Clear numbers and symbols

    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...
  7. V

    Transpose problem: produces zero results

    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...
  8. O

    relationship among four variables

    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
  9. P

    Move Numbers in adjacent cells

    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...
  10. 8

    Not running as hoped

    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...
  11. J

    Error Expected =

    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
  12. M

    sumifs formula not working as expected

    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...
  13. N

    Array formula with multiple Countifs

    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...
  14. P

    Change numbers in column "A"

    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...
  15. cyrilbrd

    Rank If 1 condition unique rank

    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>
  16. M

    multiple date look up from different rows from two tabs

    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...
  17. P

    Prepare formula by VBA

    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...
  18. A

    Time Difference Not Being Calculated Properly

    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"...
  19. H

    Runtime 1004 - expected no data error

    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 _...
  20. P

    Clear data by creiteria

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top