Hello all,
I'm new here and I hope somebody can help me.
I'm currently trying to finish my thesis and the chapter particle shape gives a bit of a problem.
I have 2 excel files with data that contains 32 columns of 1,048,576 rows of numbers. (each 2 columns are 1 data set)
So it's giving my poor laptop a really hard time.
I am now trying to make sense of 100,000 rows of data but my existing formula doesn't do the trick anymore to have a minimum and maximum.
The formula:
=IF(OR(L10<=325;L10>=1400);NB();L10)
Because increasing the data from 10,000 to 100,000 dots showed me something new.. Instead of removing everything before x=325 and after x=1400 there is a clear empty path between A and B (yellow line) and this line is not vertical unfortunately.
I tried my best but i can't figure it out how to remove all the dots of A/left of the yellow line.
The yellow line was found with trial and error.
I defined also a name "KAY" (excel 2016 -> formula -> name define -> =Blad1!$P:$P (is just a column with 1 till 100,000)
=IF((L4>=0.369*LN(KAY)-1.4124);NB();L4)
But this doesn't work.
(my excel is in dutch so i hope i translated everything correctly)
I hope somebody here can help me.
Goodnight!
I'm new here and I hope somebody can help me.
I'm currently trying to finish my thesis and the chapter particle shape gives a bit of a problem.
I have 2 excel files with data that contains 32 columns of 1,048,576 rows of numbers. (each 2 columns are 1 data set)
So it's giving my poor laptop a really hard time.
I am now trying to make sense of 100,000 rows of data but my existing formula doesn't do the trick anymore to have a minimum and maximum.
The formula:
=IF(OR(L10<=325;L10>=1400);NB();L10)
Because increasing the data from 10,000 to 100,000 dots showed me something new.. Instead of removing everything before x=325 and after x=1400 there is a clear empty path between A and B (yellow line) and this line is not vertical unfortunately.
I tried my best but i can't figure it out how to remove all the dots of A/left of the yellow line.
The yellow line was found with trial and error.
I defined also a name "KAY" (excel 2016 -> formula -> name define -> =Blad1!$P:$P (is just a column with 1 till 100,000)
=IF((L4>=0.369*LN(KAY)-1.4124);NB();L4)
But this doesn't work.
(my excel is in dutch so i hope i translated everything correctly)
I hope somebody here can help me.
Goodnight!