how to

  1. R

    Random select one line of data for each person in a list

    I would like to know how I can get excel to randomly select one line of data for each of the people listed below (so one for bob, one for jenny, one for Trish etc.). I have been trying a mixture of vlookup and rand but to no avail, below is just a sample list but i would like to try it on a...
  2. M

    VLookup, IF Function or both?

    I'm having a heck of a time trying to format a sheet because I don't have a lot of experience with VLookups and IF Functions and was wondering if someone could help me. I have a sheet with a list of customers that does not include their market segment. Some of thee customers appear once on the...
  3. A

    Networking linked spreadsheets - best practice

    Hi I have a number - about 25 - of manufacturing log spreadsheets that need to exist on a networked workstation - let's call it WKSTN 02. These contain multiple sheets. These logs contain cell references which are linked to several other sheets on a Master Stock List spreadsheet - a separate...

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