Question about Microsoft Computers & Internet

1 Answer

Random selection formaula

To select randomly from 5000 list , I want the formula on excel

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 45 Answers

Enumerate your list from 1 to 5000
=RANDBETWEEN(1,5000)

Posted on Nov 27, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

What is formula to use 5 point drop down list to prompt entry of cell value into specific location


You can use cell validation.
Select the cells you want to have the dropdown list.
Press the following keys "alt" "d" "l" and you get a message box.
select List from the drop down.
Now you can type in your list in the blank box separated by commas

Nov 29, 2009 | Microsoft Excel for PC

1 Answer

My nokia e51 only plays one song


Have create a track list containing all the songs? If you haven't done so, create a new tracklist in Tracks,
  1. Select New Track list
  2. Select memory location to save the List
  3. Name the Track List
  4. Then select the songs like like put in the list by Marking each song
If you want to add new songs in the list, you can edit the Track List and repeat pint 4 above.
Then you play the songs in the List randomly, etc.

Jul 31, 2009 | Nokia E51 Smartphone

1 Answer

Excel radom selection formula not working


What are the values of cells C4 and C5? Should the function above be "...RANDBETWEEN(A$4,A$5)" ?

Jun 29, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

I want the all excel formulas


You will never find a fully comprehensive list anywhere because there are literally hundreds in the basic Excel application and thousands that can be added in as you go via macros. More are being added every time a new version of Office comes out.

But, the easiest way however to get a basic list of functions if your not printing is to hit the function button and simply scroll down the list. The syntax (an example of the method by which you should be formatting the formula) and a definition will list in the bottom of the dialog as you select each function.

That said, you are better solving individual problems as you learn Excel then trying to memorize all the functions themselves. Many, such as mathematical operations are common sense anyway.

Jun 19, 2009 | Microsoft Computers & Internet

4 Answers

Using excel to solve problem by trial and error method


In A1, put a random value of d as 0.1. Then in B1, put your equation 5*d^4 - 10.29*d^(-1.333), wherein refer d as A1. Then use goal seek function on Tools Menu. First "Set cell" as B1, "To value" as 0.124 and "By Changing Cell" as A1. Excel will do the Trial & Error and will give you the answer in Cell A1.

Nilesh

Mar 31, 2009 | Microsoft EXCEL 2004 for Mac

1 Answer

Can i ask example of vasual basic 6.0?


Do you need a random example?
If you're looking for a specific case please let us know.

Please find below your random example:

Dim mark As Single

Private Sub Compute_Click()

'Examination Marks
mark = mrk.Text

Select Case mark
Case 0 to 49

comment.Caption = "Need to work harder"

Case 50 to 59

comment.Caption = "Average"

Case 60 to 69
comment.Caption = "Above Average"

Case 70 to 84
comment.Caption = "Good"

Case Else
comment.Caption = "Excellence"

End Select

End Sub




Mar 19, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

I want verify the data drop town list and its formulas


Hi Manjee,

There is no formula used in data dropdown list, so it can not be verified as a formula using evaluate formula, trace errors, trace dependents, trace precedents etc.

If you want to create such lists simply:-
  • Select input range then goto
    data --> validation --> allow, list --> select the list range
  • To veryfy you can follow the same process
    data --> validation --> allow, list ,
    now you can see the exact range from where the data is picked.
Thanks

Zulfikar Ali
ali_zulfikar@yahoo.com
09899780221

Jan 19, 2009 | Microsoft Office Excel 2003 for PC

2 Answers

Circular reference working how to open excel file


Clicking cancel will invalidate the formulae, circular references refer to the dependant and precedent cells using each other.

Track/ Audit depending on your Excel version to show which formulae is incorrect - or options view, tick show formaulae and remove them.

Nov 20, 2008 | Microsoft Excel for PC

1 Answer

Need a formula for excel


select CONDITIONAL FORMATING in Format

select FORMULA IS , CELL VALUE = > < (condition)

after this select Format

font style , COLOR

SEE IT WILL WORK CHANGE OF COLOURS ........

Oct 10, 2008 | Microsoft Excel for PC

1 Answer

Random number generation.


you can use the Round function as below - it rounds out the decimal to 0 places, which gives you 5 digits with no commas

=ROUND(RAND()*100000,0)

Jul 10, 2008 | Microsoft Excel for PC

Not finding what you are looking for?

Open Questions:

Computers & Internet Logo

Related Topics:

30 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...