<tbody>
Animal
Phobic
Rat
Yes
Snake
No
Spider
Unknown
Scorpion
Rat
?
Snake
Rat
?
Spider
</tbody>
Hello, how do I get all instances in Col A of 'Rat' to show in Col B as "yes"? This needs to be dynamic as the Col B could also be "no". I...
Does anybody know if there is any way to make a spider chart to look like a target i.e. with the centre rings of the chart shaded red, next set of rings amber and outer rings green? The lines and plots will then be shown to fall within these regions indicating whether they are Red Amber or Green.
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.