Function to change the rest of row ,if the first number is changed?

[bugmenot]

I have a table
št. meritev 10x10 [ms] 20x20 [ms] 40x40 [ms] 80x80 [ms]
1 1002 4003 16100 32102
2 1010 4013 16080 32160
3 989 3989 15980 31940

and another like this:

št. meritev 10x10 [ms] 20x20 [ms] 40x40 [ms] 80x80 [ms]
1 da da ne da
2 ne ne da ne
3 ne ne da ne

the second table i use "IF" to get results if the number in the first table is larger of smaller than a specified value.
The first column of the second table has randomly changing numbers.
Now my question is how to make the "da","ne" change depending on what number of the row it is, so if the row changes the anwsers change too.

I hope it makes sense, and that this is in the right part of the forum.

[NBVC]

Can you tell us the current formula you are using?

And give an example of what you mean by changed numbers in first column with expected results...

[bugmenot]

The formula im using to get "da""ne" is =IF(ABS(meritve!D7-meritve!D$15)< $D$17*meritve!D$16;"da";"ne")
These are the full tables:

št. meritev 10x10 [ms] 20x20 [ms] 40x40 [ms] 80x80 [ms]
1 1002 4003 16100 32102
2 1010 4013 16080 32160
3 989 3989 15980 31940
4 999 3997 15987 31982
5 1001 4001 16021 32128
6 994 3991 15993 31983
7 1003 4003 16063 32073
8 1009 4001 16016 32036
povp. vred. 1000,875 3999,75 16030 32050,5
std. odk. 6,584783596 7,066647013 42,54997062 73,1641989

---------------------
št. meritev 10x10 [ms] 20x20 [ms] 40x40 [ms] 80x80 [ms]
5 da da ne da
7 ne ne da ne
5 ne ne da ne
5 da da da da
6 da da da da
8 da ne da da
8 da da da da
7 ne da da da

The first column in the second table (they represent the measurement 1st, 2nd,3rd,...) i use =RANDBETWEEN(1;8) , to get random numbers. But the other four columns stay the same as they were, but they should also change when the number of the measurement changes.

Hope it makes sence now, and that its even possible to solve.

[tinyjack]

I would have a look at OFFSET()

HTH

TJ

[DonkeyOte]

I wouldn't given it's Volatile and although I concede RAND(BETWEEN) is Volatile the more Volatiles you have the worse your performance will become... use a combination of INDEX/MATCH.

If you could provide some range references for each table we'd be able to give you a solution ... as is it's a little difficult.

Post a sample workbook if possible

Apologies to TJ & OP for plethora of Edits !

[NBVC]

I think posting the workbook is better, that way we can see the actual cell references....

[bugmenot]

Here is the file: http://rapidshare.com/files/191166980/Naloga5.2.rar

The first table is on the first sheet and the second on the second. Never mind the other numbers.
Its probably a bit chaotic, but i don't really use excel that much, and this is actualy the first time i actualy used all these functions.

[NBVC]

Can you post it here as an attachment instead?

[bugmenot]

Here you go.

[NBVC]

Try this formula in D7:

Please Login or Register  to view this content.

copied down and across

[bugmenot]

WOW, it works. Thank you very much, I never would have solved this myself, but now that i look at it its not that complicated. Thanks again!!!