Excel question about retrieving larger data

Permalänk
Medlem

Excel question about retrieving larger data

Hi all.

I have a sheet with a large amount of data. The data contains values for an average day depending on two variables. Its 24 rows 12 columns per set. There is 144 sets beside each other. Total of 50 000 cells. I have 24 values for one of the variables, and 6 for the other. Ive put the sets right next to each other. Here is an example:

[set (variable1, variable2)]

excel sheet that i want to retrieve data from:
[set 1,1][set 1,2][set 1,3][set 1,4][set 1,5][set 1,6]...
[set 2,1][set 2,2][set 2,3][set 2,4][set 2,5][set 2,6]...
[set 3,1][set 3,2][set 3,3][set 3,4][set 3,5][set 3,6]...
[set 4,1]...

Every set has 288 values and the thing is that i want to retrieve a whole set in another sheet (same excel-file) depending on which variables you input. is there any way to do this in excel or is it maybe to complex?

Permalänk
Medlem
Permalänk
Medlem
Skrivet av timsah:

Hi all.

I have a sheet with a large amount of data. The data contains values for an average day depending on two variables. Its 24 rows 12 columns per set. There is 144 sets beside each other. Total of 50 000 cells. I have 24 values for one of the variables, and 6 for the other. Ive put the sets right next to each other. Here is an example:

[set (variable1, variable2)]

excel sheet that i want to retrieve data from:
[set 1,1][set 1,2][set 1,3][set 1,4][set 1,5][set 1,6]...
[set 2,1][set 2,2][set 2,3][set 2,4][set 2,5][set 2,6]...
[set 3,1][set 3,2][set 3,3][set 3,4][set 3,5][set 3,6]...
[set 4,1]...

Every set has 288 values and the thing is that i want to retrieve a whole set in another sheet (same excel-file) depending on which variables you input. is there any way to do this in excel or is it maybe to complex?

It most probably can be done but in the long run you better learn R.

https://www.r-project.org/

Here is one link to [too] many videos to get you started.

Visa signatur

| Fractal Design Define R5| Asrock X399 Fatal1ty| Threadripper 1950X| Noctua NH-U14S TR4-SP3| Corsair Vengeance LPX 8x16GB 3200 C16| be quiet! Straight Power 11 Platinum 1000W| ASUS RTX 3080 10GB Strix| LG OLED 4k 42" C2| Debian Sid| KDE 5.x|