randomised

Hi everyone, I have a rather tricky problem to solve. For each row in my table (for each person) - refer to screenshot named "My Table", I would like excel to randomly generate a 9 digit number (in Column N) but based on a certain set of rules. Here is how I currently generate them 1 by 1...

Hi Folks.. I have a spreadsheet with 121 Pupil Names (in format Surname, Forename) (Column A - sorted alphabetically) and Previous School (Column B). I have another couple of columns that assist in generating a randomised list of the 121 names and put it in Column E. All works so far up to...

Hi Guys, Firstly, apologies for the total lack of a snappy title... I have a job interview next week in which i will have to show how i would handle receiving responses to certain questions on a questionnaire. My idea is to Randbetween and Choose(Randbetween) to give myself a real working...

Hey guys, I wanted to know how to find out if the value in one cell equals any one of an item in a list, without using a tedious OR formula for everything or VBA code. If there's any way to do this, I'd be greatly appreciative for you to let me know. :). Just to clarify, or give an example...