Need Excel formula

Reply #11

hotshot4 — Wed, 11 Aug 2010 12:47:10 GMT

That formula states #Value (A function in the formula causes the result to change each time the

spreadsheet is calculated. The final evacuation step will make the result in the cell but intern steps may not).

Your close but not there yet, please see if you can help, and thanks for trying.

Reply #10

Guest — Wed, 11 Aug 2010 03:37:01 GMT

use the 'indirect' in the formula.

=min(indirect($e$4:$e221))

try it and let me know .

Reply #9

aspire — Tue, 03 Aug 2010 16:11:08 GMT

leave cell E4 blank for the purpose of entering your predicted number for the next draw, always insert a new row after row 4 for the new data, then your formula will not change.

Reply #8

hotshot4 — Mon, 02 Aug 2010 12:22:38 GMT

Thanks, I've already got one like that, but added it to my Excel files, but I still would like for someone to give me the information I request

for my work sheet. Thanks

Reply #7

winsumloosesum — Sun, 01 Aug 2010 19:42:27 GMT

hotshot,

Try this:

Download link to PowerBall Excel file:

http://www.box.net/shared/os80gb4kdq

Reply #6

hotshot4 — Wed, 28 Jul 2010 18:03:06 GMT

Be glad to try it, but please explain how to do it, sorry to be so dumb but I've never heard of it, know how to do it.

Thanks

Reply #5

Raven62 — Wed, 28 Jul 2010 15:35:34 GMT

Have you tried doing: Shift Cells Down :to Make Room for new data...

Reply #4

hotshot4 — Wed, 28 Jul 2010 12:25:17 GMT

Celll E5 has last weeks first digit number in it, E4 becomes E5 after I insert a new row.

Cell D Cell E Cell F

Row 4 Wed July-28-10 2 has second digit of Pwer Ball so on so forth

Row 5 Wed July-21-10 3

Row 6 Wed July -14-10 1

Row 222 Min =Min($E$4;$E221)

Row 223 Max =Max($E$4:$E221)

Row 224 different formula

When I insert a new row in row 4 the above formula changes from $E$4 to $E$5 automatic and I need for it to stay $E$4

HELP and Thanks

Reply #3

jwhou — Wed, 28 Jul 2010 02:04:15 GMT

First Copy E4 to E5, then be on E5 when you insert a new row.

Reply #2

phileight — Wed, 28 Jul 2010 01:15:29 GMT

put your formulas at the top of the page. when you insert a new line( below the formulas) they won't be affected.

Reply #1

hotshot4 — Tue, 27 Jul 2010 23:15:36 GMT

That is when I insert a new row, the formula at the end of the column chanes for $E4$4 to $E$5, as I insert a new row the number changes each time.

Need Excel formula

hotshot4 — Tue, 27 Jul 2010 17:13:26 GMT

I have an Excel worksheet where I enter the Power Ball winning number by day of week

I input Wednesday winning number then over a few columns I enter Saturday s numbers

At the bottom of each column I have several formulas to find the Min Max number, and the number of times each number has been hit, each week I insert a new row to enter that week s numbers and

My formula at the bottom changes but I don t want it to change. Here is my problem

I use cell E4 to enter the first digit on t... [ More ]