Good Afternoon all,
I am in need of assistance. I am trying to create a dynamic drop-down list based on another drop-down list.
I have hundreds of rows of distributors in Column B and the markets they belong to in Column A. I can put the list of distributors into the drop-down, but what i...
<tbody>
Location
#
Month
Year
NYC
5
July
2019
Florida
3
August
2019
Mass
1
October
2019
</tbody>
I have a workbook with the above information:
I would want it to look at column B, (#) and then insert 5 rows where the #= 1, so 1,1,1,1, instead of the 5:
<colgroup><col...
Hello Excel Pros,
I've somewhat unique excel problem and it's taking a lot of my time because I do it pretty much manually. I'm asking all the pros to help me figure out a quicker way to get this done. Below is how I get data in excel sheet:
<colgroup><col...
Hello,
I cannot get my head to figure out the right formula to find a total for "Sum of Yes" in Table 1 in the example below. The sum of yes for DC (row 2) should be 4500.00 since column Bob and Column Ted for DC are yes, Florida is 5702.00, etc.
Thanks for any suggestions!
Table 1
State...
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.