looked

  1. P

    How did they do this? A Zoom-out-only Graphic overlay

    Hi, My first post here and it's got us scratching our heads. I even have an Excel guru in the office and this is one we have not seen. On a worksheet, when zoomed out further than 40%, there is a text-based graphics overlay on the worksheet. At 39% zoom or lower, it's there, at 40% or above...
  2. C

    Getting error code (-7711) not sure why...

    This error is happening when I link Salesforce to Access, I had it working and now I keep getting this error -7711 which I looked it up and it is saying there is a data issue? Anyone have experience with this?
  3. K

    Get all Combinations based on N

    Hello, I need to create a macro that will give me all combinations of the listed data in sets of N. So lets say N is 2 i want 1*2 then 1*3 and and so on. I have seen a lot of looked and have seen macros similar to what i need but cant figure out how to adjust them to work for me. <tbody> A B...
  4. E

    Nested If and less than or equal to

    I am trying to put together a nested if statement that contains a number of less than or greater than calculations. i.e if (A2 <60,A,(if A2>60<70,B,if(A2>70>80,C,if(A2>80,D)))) I can get a result if A2 is less than 60 or greater than 80 but the middle ones don't work. I have looked at adding...
  5. A

    Need to add bulk rows and text moved into new rows

    Hi Excel Experts, I have a excel sheet with about 8000 Rows. It has 5 Columns. Screenshot below: What I want them to be looked like: And I have this "was" price in some of columns. I want to have only the New price. For Example: <tbody> "Was £387.25 £375.42" I just want...
  6. V

    Reformatting data

    Hi all, I need to transpose my horizontal data to a vertical format: i.e. <tbody> B1 45 B2 66 B3 60 B3 25 B4 45 B7 10 </tbody> into <colgroup><col><col></colgroup><tbody> B1 45 B2 66 B3 60 B3 25 B4 45 B7 10 </tbody> Normal transpose function won't...

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