Hi
If I have a range of values on a sheet, eg A1:B4, how can I display these values on another sheet, exactly as they are on the first sheet?
Many thanks
Hello,
I have a little problem. I have a large statistic table in one WB and in a different WB references to the first one. When I open my second WB i see #ARG ! in every cell, but when I open both the values are displaying properly.
Can I somehow fix it so that values would be correct if...
In excel I have a formula displaying places
ie !st Place, 2nd Place 3rd Place etc
The formula is like this:
=D46&MID("thstndrdth",MIN(100,2*RIGHT(D46)*(MOD(D46-11,100)>2)+1),2)&" Place"
The problem I am encountering is that the "TH" places are not displaying like this:
45 Place
46 Place
47...
Hi,
I am looking for a way to scroll text only in a ticker bar style information
Ideally would like it to fire up when open the workbook displaying contents of A1, then a break, then A2, then A3, then A4
Thanks for any help
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.