Selecting multiple cells based on the value of an adjacent cell

[m0nkeyb0y66]

I am collecting sensor data from an Arduino project, and it saves the data to a text file. Each second 16 data points are collected. Three seconds of that data looks like the following with the spaces separating the data for each second it was recorded:

29.02
84.23
55.63
0.12
25.11
971
372.29
77.10
770.70
-92.70
0.06
0.02
0.05
-0.06
0.12
9.78

29.02
84.23
55.63
0.12
25.11
971
372.29
77.10
765.90
-93.30
0.07
0.02
0.05
-0.07
0.11
9.79

29.02
84.23
55.63
0.12
25.11
971
372.29
81.90
768.30
-92.70
0.06
0.00
0.05
-0.08
0.12
9.81

I have copied all of this data into an Excel spreadsheet and added a column with headings for each data point. I now have two columns that look like the following:

Temp ℃: 29.02
Temp ℉: 84.23
Humidity %: 55.63
Ultraviolet intensity mw/cm2: 0.12
LuminousIntensity lx: 25.11
Atmospheric pressure hpa: 971
Altitude m: 372.29
Mag X uT: 77.1
Mag Y uT:: 770.7
Mag Z uT: -92.7
Gyryo X g: 0.06
Gyryo Y g: 0.02
Gyryo Z g: 0.05
Accel X m/s^2 -0.06
Accel Y m/s^2 0.12
Accel Z m/s^2 9.78
--------------------------------------
Temp ℃: 29.02
Temp ℉: 84.23
Humidity %: 55.63
Ultraviolet intensity mw/cm2: 0.12
LuminousIntensity lx: 25.11
Atmospheric pressure hpa: 971
Altitude m: 372.29
Mag X uT: 77.1
Mag Y uT:: 765.9
Mag Z uT: -93.3
Gyryo X g: 0.07
Gyryo Y g: 0.02
Gyryo Z g: 0.05
Accel X m/s^2 -0.07
Accel Y m/s^2 0.11
Accel Z m/s^2 9.79
--------------------------------------
Temp ℃: 29.02
Temp ℉: 84.23
Humidity %: 55.63
Ultraviolet intensity mw/cm2: 0.12
LuminousIntensity lx: 25.11
Atmospheric pressure hpa: 971
Altitude m: 372.29
Mag X uT: 81.9
Mag Y uT:: 768.3
Mag Z uT: -92.7
Gyryo X g: 0.06
Gyryo Y g: 0
Gyryo Z g: 0.05
Accel X m/s^2 -0.08
Accel Y m/s^2 0.12
Accel Z m/s^2 9.81
--------------------------------------

I'd like to be able to separate the data points based on the heading that goes with them. I want to get all of the readings for Mag Z uT and be able to paste them to a separate sheet or column so that I can select them all and create a graph of the change over time. Is there a way to do this quickly? Can I select numbers in column B based on what it says in the adjacent cell in column A? For example, only select cells in column B if the adjacent cell in column A says Mag Z uT.

Book1
	A	B
1	Temp ℃:	29.02
2	Temp ℉:	84.23
3	Humidity %:	55.63
4	Ultraviolet intensity mw/cm2:	0.12
5	LuminousIntensity lx:	25.11
6	Atmospheric pressure hpa:	971
7	Altitude m:	372.29
8	Mag X uT:	77.1
9	Mag Y uT::	770.7
10	Mag Z uT:	-92.7
11	Gyryo X g:	0.06
12	Gyryo Y g:	0.02
13	Gyryo Z g:	0.05
14	Accel X m/s^2	-0.06
15	Accel Y m/s^2	0.12
16	Accel Z m/s^2	9.78
17	--------------------------------------
18	Temp ℃:	29.02
19	Temp ℉:	84.23
20	Humidity %:	55.63
21	Ultraviolet intensity mw/cm2:	0.12
22	LuminousIntensity lx:	25.11
23	Atmospheric pressure hpa:	971
24	Altitude m:	372.29
25	Mag X uT:	77.1
26	Mag Y uT::	765.9
27	Mag Z uT:	-93.3
28	Gyryo X g:	0.07
29	Gyryo Y g:	0.02
30	Gyryo Z g:	0.05
31	Accel X m/s^2	-0.07
32	Accel Y m/s^2	0.11
33	Accel Z m/s^2	9.79
34	--------------------------------------
35	Temp ℃:	29.02
36	Temp ℉:	84.23
37	Humidity %:	55.63
38	Ultraviolet intensity mw/cm2:	0.12
39	LuminousIntensity lx:	25.11
40	Atmospheric pressure hpa:	971
41	Altitude m:	372.29
42	Mag X uT:	81.9
43	Mag Y uT::	768.3
44	Mag Z uT:	-92.7
45	Gyryo X g:	0.06
46	Gyryo Y g:	0
47	Gyryo Z g:	0.05
48	Accel X m/s^2	-0.08
49	Accel Y m/s^2	0.12
50	Accel Z m/s^2	9.81
51	--------------------------------------
Sheet1

Cell Formulas
Range	Formula
A18:A51	A18	=A1

Named Ranges
Name	Refers To	Cells
Print_Titles	=Sheet1!$A:$A	A18

 

[Anthony47]

Let's say that you queue your data in column A & B

Now in D2 insert the formula

=LET(myTABL,A2:B10000,FilterBy,"Mag Z uT:",FILTER(myTABL,INDEX(myTABL,0,1)=FilterBy))

This will return all the rows where col A is equal to "Mag Z uT:" (case insensitive)
If you need other data, replicate the same formula but changing the value of the label FilterBy

This formula works with Office 365 (and other versions that handle Dynamic Arrays)

But you might also use directly an Autofilter on the column A