Get instant live Excel expert help with RAND Function

Problem using formula to calculate differences. I have a unique reference (order) and a number of options against the order. I have a quote reference which when reads 'New' are the options in the enquiry. I have a quote reference (some random generated characters) with the options chosen in the quote. I want to be able to say, if the option in quote is not included in the option in the enquiry then mark it so i can then count the orders which had different options in the quote to the enquiry.

I want to select a random question from a list then eliminate that question form being used again. Also, how to do excel random sort with my list?

I have two columns of data. The first column is random, multi-digit ID numbers and the second column are dates that are specific to those ID numbers (i.e. 2234 matches 3/3/95 only) I want to be able to go to another workbook or sheet and type in a random ID number from the first column and then have excel generate the corresponding date next to it. I want to be able to do this with a sheet that has 400+ ID numbers with dates, go to another workbook and start typing ID numbers down column A and then excel generate it's date in column B

how do i calculate the NPV across two columns A and B and 36 rows, where column A has a spend across every row and Column B has a spend only for 3 random rows

I am trying to generate random values between 0 to 1 with two decimal places in 31 rows such that my sum is a certain value. Need help to generate them.

Level A items Fruits Veggies Nuts Under each Level A item there are an inconsistent number of "Level B items" For example: Level B items Under fruits you have apples and Oranges (2 items) Under veggies you have corn potatoes and peas (3 items) Under nuts you have peanuts (1 items) I need to set something up so that I can type in a Level A Item (in random order) and have a row of data created for each Level B item. So if Sheet 1, Column A is: Fruits Veggies Nuts Then Sheet 2 Column A would look like: Row 1 = apples Row 2 = oranges Row 3 = Corn Row 4 = Potatoes Row 5 = Peas Row6 = Peanuts And so on and so on.

I need a formula to take the sum of last 4 entries of a row excluding blank cells. Some of the blank cells are in the middle of the rows and the blanks are in random spaces.

I need to select all the #1 I have in my sheet after I have sorted then assigned random number to each between 1-3

I sorted my list by name and then applied a random number using =RANDBETWEEN(1,3). I now want to select only those #1 so I can make that an email list. Then I will do the same for #2s and #3s. How can I select these?

I need a formula to get a random value from duplicates names