newb

  1. B

    help with dragging formulas across

    hello this seems so simple but I can't work it out I want columns A to Z to display values by multiplying the percentages in columns AA to AZ by the corresponding row values in fixed column BA. e.g. A1 = AA1*BA1 B1 = AB1*BA1 C1 = AC1*BA1 Z1 = AZ1*BA1 A2 = AA2*BA2 B2 = AB2*BA2 A500 =...
  2. E

    Looping through data validation list to incrementally update model

    Q: How can I loop through 3 cells that contain data validation lists, in order to update my model? In order for the model I am working with to update, there are three cells (C5, C6, C7 - that contain dynamic data validation lists linked to 3 different ranges in the sheet) that need to be cycled...
  3. M

    Importing and organizing my data into a database

    I hate to make my first post an "I can't do this, help me do this" post, but here I am; apologies in advance for being a newb, I'll do my best to repay karma with interest afterward. I have a data set from a series of tests that I've performed and I'm trying to analyze my results. I have been...

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