Hi Team,
I'm in need of an excel formula or VBA Code that can assist me reference column of unique values (Column A) and have each of them duplicated in 11 rows of another column (Column B). For example:
<TBODY>
Column A
Column B
Apple
Apple
Orange
Apple
Mango
Apple
Apple
Apple...
I'm sorry, but I know nothing about Excel. I know very little about anything when it comes to computers, but I'm here to ask for your kind help. Google just told me that Excel can compute info into statistics, and statistics is what I need.
Me and my friends have ran a test on how colors affect...
I have a table of data with one column of ID numbers and another column of contingency numbers. Some contingencies can be comprised of one ID number or multiple ID numbers (multiple contingencies). The contingencies that are only one ID number are simple to identify duplicates however I am...
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.