Remember Me?

#1
October 28th 04, 03:20 AM
 jrwheels Posts: n/a
Changing number in same cell

Lets say I have a cell D1, and in column A, I am going to list different
numbers in each cell daily.

Can I get the amount in D1 to change everytime I enter a new number in the
cells in column A?

Thanks for the help, Jim

#2
October 28th 04, 03:27 AM
 Myrna Larson Posts: n/a

In D1

=INDEX(A:A,RAND()*COUNT(A:A)+1)

However, that will recalculate whenever the worksheet recalculates, not just
when you enter something in column A.

On Thu, 28 Oct 2004 02:20:01 GMT, "jrwheels" wrote:

Lets say I have a cell D1, and in column A, I am going to list different
numbers in each cell daily.

Can I get the amount in D1 to change everytime I enter a new number in the
cells in column A?

Thanks for the help, Jim

#3
October 28th 04, 01:58 PM
 jrwheels Posts: n/a

I forgot to add that I would like the formula to disregard the entry in the
previous cell.

Thanks again, Jim
"jrwheels" wrote in message
...
Lets say I have a cell D1, and in column A, I am going to list different
numbers in each cell daily.

Can I get the amount in D1 to change everytime I enter a new number in the
cells in column A?

Thanks for the help, Jim

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Steve New Users to Excel 1 January 14th 05 01:07 PM [email protected] New Users to Excel 2 January 6th 05 08:18 AM Ted Dalton Excel Discussion (Misc queries) 1 December 14th 04 04:15 PM Nick Excel Discussion (Misc queries) 4 December 6th 04 11:05 PM JOHN MORREY Excel Discussion (Misc queries) 2 December 2nd 04 03:50 AM

All times are GMT +1. The time now is 02:16 PM.