excel data list

  1. H

    Type Name to automatically appear from validation data list

    Hello Excel expert: I would like to create several sheets and each will have a column for Client Name on it. To minimize the typing error, I have a sheet that contains only the client names as validation data list so I can just type the name on the new sheet as drop down list. I am able to set...
  2. R

    updating drop down based on previous cell

    Here is my problem.. I have 2 sheets.. 1st sheet looks as.. Locale OS Version Size US win7 10 30 US mac 10.7 10.1.4 45 ***an win7 10 78 ***an mac 10.7 10.1.4 90 ***an...
  3. P

    Data and using Pivot table

    You have a list of 65000 rows of data. In the data you have things like dates that you do not necessarily need, but it's in the data. If you create a pivot table to get rid of the dates and roll up the information you do need, it may only then be 20,000 rows of data. But the pivot does not...

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