expected

  1. T

    Compile Error: Expected List Separator or ) when trying to get a range

    This is giving me an error Worksheets("Sheet1").Range("A" & i&":B" & i).Cut Compile Error: Expected List Separator or ) please help
  2. S

    Stability concerns SAP BO 4.0

    I am evaluating SAP BO 4.0 for our BI implementation.I have been exploring SAP BO web intelligence. Once of my concern is when creating reports, it often breaks. And the new functionality of bringing in data from excel spreadsheets and merging with existing universe doesn't work as expected...
  3. F

    Count between Two Cells

    Dear Experts, I require to check the count interval between the 1st OFF to the Last OFF. After the Last OFF, count should not happen. Expected result attached for your reference. <colgroup><col><col><col><col><col><col><col><col><col><col><col><col...
  4. C

    IF(AND function

    Im trying to use an IF(AND function for a set of data that ive attached a sample of below, basically what i need the function to reflect is: The expected revenue account codes (4 digits - highlighted top left) that agree with the predetermined acceptable journal entry numbers (5 digits -...
  5. S

    Converting USA date to EU date doesn't work

    While delimiting, I chose to import the date+time as text otherwise Excel does some kind of half converting. Therefor I format the cell as: m/d/jjjj u:mm:ss AM/PM But it does not get recognized as date. What am I doing wrong? :confused:
  6. N

    Visual Progress tolerance icon sets

    Hi, I think this is a tricky one, it certainly is for me.... I need to display visually how well a project is running based on some date and percentage values. <tbody> START DATE TODAY DATE DUE DATE PROJECT AGE PROJECT LENGTH % EXPECTED Actual Progress Visual 1/1/17 22/08/17 31/12/17 233...
  7. W

    Automate copying values between sheets

    At the moment I am trying to predict a league table, based on the results of all (n=306) the individual games. For each game, I have (in Sheet 1) an expected goals value for the home team (G2:G307) and away team (H2:H307). In Sheet 2, I have a 11x11 poisson distribution to calculate the odds for...

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
Back
Top