Greetings,
I had help on this forum with this question a month ago, and am following up. Initially, I thought I only needed only the cell entry most adjacent to a #N/A entry. Now I am needed that + the second most-adjacent data as well. Formula suggested was: =TAKE(FILTER(G2:NB2,NOT(ISNA(G2:NB2))),,-1). I tried this: =TAKE(FILTER(G2:NB2,NOT(ISNA(G2:NB2))),,-2) and am getting a
I'll upload the data file for reference. I'm trying to parse multiple complex data files and extract limited information. Data is from acoustic doppler flow data in a river. First three rows have yellow highlights for the data I'm trying to return.
Many thanks!
Eric
I had help on this forum with this question a month ago, and am following up. Initially, I thought I only needed only the cell entry most adjacent to a #N/A entry. Now I am needed that + the second most-adjacent data as well. Formula suggested was: =TAKE(FILTER(G2:NB2,NOT(ISNA(G2:NB2))),,-1). I tried this: =TAKE(FILTER(G2:NB2,NOT(ISNA(G2:NB2))),,-2) and am getting a
I'll upload the data file for reference. I'm trying to parse multiple complex data files and extract limited information. Data is from acoustic doppler flow data in a river. First three rows have yellow highlights for the data I'm trying to return.
Many thanks!
Eric
| data v2.xlsx | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | AU | AV | AW | AX | AY | AZ | BA | BB | BC | BD | BE | BF | BG | BH | BI | BJ | BK | BL | BM | BN | BO | BP | BQ | BR | BS | BT | BU | BV | BW | BX | BY | BZ | CA | CB | CC | CD | CE | CF | CG | CH | CI | CJ | CK | CL | CM | CN | CO | CP | CQ | CR | CS | CT | CU | CV | CW | CX | CY | CZ | DA | DB | DC | DD | DE | DF | DG | DH | DI | DJ | DK | DL | DM | DN | DO | DP | DQ | DR | DS | DT | DU | DV | DW | DX | DY | DZ | EA | EB | EC | ED | EE | EF | EG | EH | EI | EJ | EK | EL | EM | EN | EO | EP | EQ | ER | ES | ET | EU | EV | EW | EX | EY | EZ | FA | FB | FC | FD | FE | FF | FG | FH | FI | FJ | FK | FL | FM | FN | FO | FP | FQ | FR | FS | FT | FU | FV | FW | FX | FY | FZ | GA | GB | GC | GD | GE | GF | GG | GH | GI | GJ | GK | GL | GM | GN | GO | GP | GQ | GR | GS | GT | GU | GV | GW | GX | GY | GZ | HA | HB | HC | HD | HE | HF | HG | HH | HI | HJ | HK | HL | HM | HN | HO | HP | HQ | HR | HS | HT | HU | HV | HW | HX | HY | HZ | IA | IB | IC | ID | IE | IF | IG | IH | II | IJ | IK | IL | IM | IN | IO | IP | IQ | IR | IS | IT | IU | IV | IW | IX | IY | IZ | JA | JB | JC | JD | JE | JF | JG | JH | JI | JJ | JK | JL | JM | JN | JO | JP | JQ | JR | JS | JT | JU | JV | JW | JX | JY | JZ | KA | KB | KC | KD | KE | KF | KG | KH | KI | KJ | KK | KL | KM | KN | KO | KP | KQ | KR | KS | KT | KU | KV | KW | KX | KY | KZ | LA | LB | LC | LD | LE | LF | LG | LH | LI | LJ | LK | LL | LM | LN | LO | LP | LQ | LR | LS | LT | LU | LV | LW | LX | LY | LZ | MA | MB | MC | MD | ME | MF | MG | MH | MI | MJ | MK | ML | MM | MN | MO | MP | MQ | MR | MS | MT | MU | MV | MW | MX | MY | MZ | NA | NB | |||
| 1 | Sample # | Date/Time | Most adjacent to #N/A entry | 2nd most adjacent entry | Frequency (MHz) | Profile Type | Depth (m) | Cell Size (m) | Cell Start (m) | Cell1 Location (m) | Cell1 Ve (m/s) | Cell1 Vn (m/s) | Cell1 Vu (m/s) | Cell1 Vd (m/s) | Cell1 Spd (m/s) | Cell1 Dir (deg) | Cell2 Location (m) | Cell2 Ve (m/s) | Cell2 Vn (m/s) | Cell2 Vu (m/s) | Cell2 Vd (m/s) | Cell2 Spd (m/s) | Cell2 Dir (deg) | Cell3 Location (m) | Cell3 Ve (m/s) | Cell3 Vn (m/s) | Cell3 Vu (m/s) | Cell3 Vd (m/s) | Cell3 Spd (m/s) | Cell3 Dir (deg) | Cell4 Location (m) | Cell4 Ve (m/s) | Cell4 Vn (m/s) | Cell4 Vu (m/s) | Cell4 Vd (m/s) | Cell4 Spd (m/s) | Cell4 Dir (deg) | Cell5 Location (m) | Cell5 Ve (m/s) | Cell5 Vn (m/s) | Cell5 Vu (m/s) | Cell5 Vd (m/s) | Cell5 Spd (m/s) | Cell5 Dir (deg) | Cell6 Location (m) | Cell6 Ve (m/s) | Cell6 Vn (m/s) | Cell6 Vu (m/s) | Cell6 Vd (m/s) | Cell6 Spd (m/s) | Cell6 Dir (deg) | Cell7 Location (m) | Cell7 Ve (m/s) | Cell7 Vn (m/s) | Cell7 Vu (m/s) | Cell7 Vd (m/s) | Cell7 Spd (m/s) | Cell7 Dir (deg) | Cell8 Location (m) | Cell8 Ve (m/s) | Cell8 Vn (m/s) | Cell8 Vu (m/s) | Cell8 Vd (m/s) | Cell8 Spd (m/s) | Cell8 Dir (deg) | Cell9 Location (m) | Cell9 Ve (m/s) | Cell9 Vn (m/s) | Cell9 Vu (m/s) | Cell9 Vd (m/s) | Cell9 Spd (m/s) | Cell9 Dir (deg) | Cell10 Location (m) | Cell10 Ve (m/s) | Cell10 Vn (m/s) | Cell10 Vu (m/s) | Cell10 Vd (m/s) | Cell10 Spd (m/s) | Cell10 Dir (deg) | Cell11 Location (m) | Cell11 Ve (m/s) | Cell11 Vn (m/s) | Cell11 Vu (m/s) | Cell11 Vd (m/s) | Cell11 Spd (m/s) | Cell11 Dir (deg) | Cell12 Location (m) | Cell12 Ve (m/s) | Cell12 Vn (m/s) | Cell12 Vu (m/s) | Cell12 Vd (m/s) | Cell12 Spd (m/s) | Cell12 Dir (deg) | Cell13 Location (m) | Cell13 Ve (m/s) | Cell13 Vn (m/s) | Cell13 Vu (m/s) | Cell13 Vd (m/s) | Cell13 Spd (m/s) | Cell13 Dir (deg) | Cell14 Location (m) | Cell14 Ve (m/s) | Cell14 Vn (m/s) | Cell14 Vu (m/s) | Cell14 Vd (m/s) | Cell14 Spd (m/s) | Cell14 Dir (deg) | Cell15 Location (m) | Cell15 Ve (m/s) | Cell15 Vn (m/s) | Cell15 Vu (m/s) | Cell15 Vd (m/s) | Cell15 Spd (m/s) | Cell15 Dir (deg) | Cell16 Location (m) | Cell16 Ve (m/s) | Cell16 Vn (m/s) | Cell16 Vu (m/s) | Cell16 Vd (m/s) | Cell16 Spd (m/s) | Cell16 Dir (deg) | Cell17 Location (m) | Cell17 Ve (m/s) | Cell17 Vn (m/s) | Cell17 Vu (m/s) | Cell17 Vd (m/s) | Cell17 Spd (m/s) | Cell17 Dir (deg) | Cell18 Location (m) | Cell18 Ve (m/s) | Cell18 Vn (m/s) | Cell18 Vu (m/s) | Cell18 Vd (m/s) | Cell18 Spd (m/s) | Cell18 Dir (deg) | Cell19 Location (m) | Cell19 Ve (m/s) | Cell19 Vn (m/s) | Cell19 Vu (m/s) | Cell19 Vd (m/s) | Cell19 Spd (m/s) | Cell19 Dir (deg) | Cell20 Location (m) | Cell20 Ve (m/s) | Cell20 Vn (m/s) | Cell20 Vu (m/s) | Cell20 Vd (m/s) | Cell20 Spd (m/s) | Cell20 Dir (deg) | Cell21 Location (m) | Cell21 Ve (m/s) | Cell21 Vn (m/s) | Cell21 Vu (m/s) | Cell21 Vd (m/s) | Cell21 Spd (m/s) | Cell21 Dir (deg) | Cell22 Location (m) | Cell22 Ve (m/s) | Cell22 Vn (m/s) | Cell22 Vu (m/s) | Cell22 Vd (m/s) | Cell22 Spd (m/s) | Cell22 Dir (deg) | Cell23 Location (m) | Cell23 Ve (m/s) | Cell23 Vn (m/s) | Cell23 Vu (m/s) | Cell23 Vd (m/s) | Cell23 Spd (m/s) | Cell23 Dir (deg) | Cell24 Location (m) | Cell24 Ve (m/s) | Cell24 Vn (m/s) | Cell24 Vu (m/s) | Cell24 Vd (m/s) | Cell24 Spd (m/s) | Cell24 Dir (deg) | Cell25 Location (m) | Cell25 Ve (m/s) | Cell25 Vn (m/s) | Cell25 Vu (m/s) | Cell25 Vd (m/s) | Cell25 Spd (m/s) | Cell25 Dir (deg) | Cell26 Location (m) | Cell26 Ve (m/s) | Cell26 Vn (m/s) | Cell26 Vu (m/s) | Cell26 Vd (m/s) | Cell26 Spd (m/s) | Cell26 Dir (deg) | Cell27 Location (m) | Cell27 Ve (m/s) | Cell27 Vn (m/s) | Cell27 Vu (m/s) | Cell27 Vd (m/s) | Cell27 Spd (m/s) | Cell27 Dir (deg) | Cell28 Location (m) | Cell28 Ve (m/s) | Cell28 Vn (m/s) | Cell28 Vu (m/s) | Cell28 Vd (m/s) | Cell28 Spd (m/s) | Cell28 Dir (deg) | Cell29 Location (m) | Cell29 Ve (m/s) | Cell29 Vn (m/s) | Cell29 Vu (m/s) | Cell29 Vd (m/s) | Cell29 Spd (m/s) | Cell29 Dir (deg) | Cell30 Location (m) | Cell30 Ve (m/s) | Cell30 Vn (m/s) | Cell30 Vu (m/s) | Cell30 Vd (m/s) | Cell30 Spd (m/s) | Cell30 Dir (deg) | Cell31 Location (m) | Cell31 Ve (m/s) | Cell31 Vn (m/s) | Cell31 Vu (m/s) | Cell31 Vd (m/s) | Cell31 Spd (m/s) | Cell31 Dir (deg) | Cell32 Location (m) | Cell32 Ve (m/s) | Cell32 Vn (m/s) | Cell32 Vu (m/s) | Cell32 Vd (m/s) | Cell32 Spd (m/s) | Cell32 Dir (deg) | Cell33 Location (m) | Cell33 Ve (m/s) | Cell33 Vn (m/s) | Cell33 Vu (m/s) | Cell33 Vd (m/s) | Cell33 Spd (m/s) | Cell33 Dir (deg) | Cell34 Location (m) | Cell34 Ve (m/s) | Cell34 Vn (m/s) | Cell34 Vu (m/s) | Cell34 Vd (m/s) | Cell34 Spd (m/s) | Cell34 Dir (deg) | Cell35 Location (m) | Cell35 Ve (m/s) | Cell35 Vn (m/s) | Cell35 Vu (m/s) | Cell35 Vd (m/s) | Cell35 Spd (m/s) | Cell35 Dir (deg) | Cell36 Location (m) | Cell36 Ve (m/s) | Cell36 Vn (m/s) | Cell36 Vu (m/s) | Cell36 Vd (m/s) | Cell36 Spd (m/s) | Cell36 Dir (deg) | Cell37 Location (m) | Cell37 Ve (m/s) | Cell37 Vn (m/s) | Cell37 Vu (m/s) | Cell37 Vd (m/s) | Cell37 Spd (m/s) | Cell37 Dir (deg) | Cell38 Location (m) | Cell38 Ve (m/s) | Cell38 Vn (m/s) | Cell38 Vu (m/s) | Cell38 Vd (m/s) | Cell38 Spd (m/s) | Cell38 Dir (deg) | Cell39 Location (m) | Cell39 Ve (m/s) | Cell39 Vn (m/s) | Cell39 Vu (m/s) | Cell39 Vd (m/s) | Cell39 Spd (m/s) | Cell39 Dir (deg) | Cell40 Location (m) | Cell40 Ve (m/s) | Cell40 Vn (m/s) | Cell40 Vu (m/s) | Cell40 Vd (m/s) | Cell40 Spd (m/s) | Cell40 Dir (deg) | Cell41 Location (m) | Cell41 Ve (m/s) | Cell41 Vn (m/s) | Cell41 Vu (m/s) | Cell41 Vd (m/s) | Cell41 Spd (m/s) | Cell41 Dir (deg) | Cell42 Location (m) | Cell42 Ve (m/s) | Cell42 Vn (m/s) | Cell42 Vu (m/s) | Cell42 Vd (m/s) | Cell42 Spd (m/s) | Cell42 Dir (deg) | Cell43 Location (m) | Cell43 Ve (m/s) | Cell43 Vn (m/s) | Cell43 Vu (m/s) | Cell43 Vd (m/s) | Cell43 Spd (m/s) | Cell43 Dir (deg) | Cell44 Location (m) | Cell44 Ve (m/s) | Cell44 Vn (m/s) | Cell44 Vu (m/s) | Cell44 Vd (m/s) | Cell44 Spd (m/s) | Cell44 Dir (deg) | Cell45 Location (m) | Cell45 Ve (m/s) | Cell45 Vn (m/s) | Cell45 Vu (m/s) | Cell45 Vd (m/s) | Cell45 Spd (m/s) | Cell45 Dir (deg) | Cell46 Location (m) | Cell46 Ve (m/s) | Cell46 Vn (m/s) | Cell46 Vu (m/s) | Cell46 Vd (m/s) | Cell46 Spd (m/s) | Cell46 Dir (deg) | Cell47 Location (m) | Cell47 Ve (m/s) | Cell47 Vn (m/s) | Cell47 Vu (m/s) | Cell47 Vd (m/s) | Cell47 Spd (m/s) | Cell47 Dir (deg) | Cell48 Location (m) | Cell48 Ve (m/s) | Cell48 Vn (m/s) | Cell48 Vu (m/s) | Cell48 Vd (m/s) | Cell48 Spd (m/s) | Cell48 Dir (deg) | Cell49 Location (m) | Cell49 Ve (m/s) | Cell49 Vn (m/s) | Cell49 Vu (m/s) | Cell49 Vd (m/s) | Cell49 Spd (m/s) | Cell49 Dir (deg) | Cell50 Location (m) | Cell50 Ve (m/s) | Cell50 Vn (m/s) | Cell50 Vu (m/s) | Cell50 Vd (m/s) | Cell50 Spd (m/s) | Cell50 Dir (deg) | Cell51 Location (m) | Cell51 Ve (m/s) | Cell51 Vn (m/s) | Cell51 Vu (m/s) | Cell51 Vd (m/s) | Cell51 Spd (m/s) | Cell51 Dir (deg) | ||
| 2 | 1 | 5/16/23 14:43 | 254.548 | #SPILL! | 3MHz | IC | 1.26 | 0.1 | 0.15 | 0.2 | -0.436 | 0.085 | -0.073 | -0.155 | 0.444 | 281.032 | 0.3 | -0.707 | -0.086 | -0.058 | -0.196 | 0.712 | 263.065 | 0.4 | -0.838 | 0.621 | 0.007 | 0.021 | 1.043 | 306.54 | 0.5 | -0.933 | -0.216 | -0.065 | 0.103 | 0.958 | 256.965 | 0.6 | -0.334 | -0.162 | -0.129 | -0.053 | 0.371 | 244.125 | 0.7 | -0.74 | 0.352 | -0.068 | -0.046 | 0.819 | 295.439 | 0.8 | -0.361 | 0.469 | -0.082 | 0.062 | 0.592 | 322.414 | 0.9 | -0.246 | -0.068 | -0.192 | 0.05 | 0.255 | 254.548 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | ||
| 3 | 2 | 5/16/23 14:43 | 293.891 | 3MHz | HD | 1.23 | 0.02 | 0.11 | 0.12 | -0.534 | 0.257 | 0.009 | 0.014 | 0.593 | 295.7 | 0.14 | -0.545 | 0.268 | 0.011 | 0.019 | 0.607 | 296.185 | 0.16 | -0.544 | 0.257 | 0.008 | 0.026 | 0.602 | 295.287 | 0.18 | -0.551 | 0.255 | 0.007 | 0.027 | 0.607 | 294.834 | 0.2 | -0.519 | 0.211 | 0.03 | 0.066 | 0.56 | 292.124 | 0.22 | -0.513 | 0.202 | 0.028 | 0.069 | 0.551 | 291.493 | 0.24 | -0.593 | 0.312 | -0.014 | 0.005 | 0.67 | 297.751 | 0.26 | -0.535 | 0.206 | 0.014 | 0.06 | 0.573 | 291.059 | 0.28 | -0.575 | 0.263 | 0 | 0.032 | 0.632 | 294.579 | 0.3 | -0.549 | 0.228 | 0.005 | 0.031 | 0.594 | 292.553 | 0.32 | -0.554 | 0.224 | 0.006 | 0.037 | 0.598 | 292.015 | 0.34 | -0.577 | 0.219 | -0.002 | 0.045 | 0.617 | 290.784 | 0.36 | -0.555 | 0.229 | 0.004 | 0.038 | 0.6 | 292.422 | 0.38 | -0.531 | 0.233 | 0.014 | 0.023 | 0.58 | 293.692 | 0.4 | -0.505 | 0.276 | 0.018 | -0.016 | 0.576 | 298.658 | 0.42 | -0.478 | 0.215 | 0.029 | 0.013 | 0.524 | 294.218 | 0.44 | -0.433 | 0.218 | 0.04 | -0.003 | 0.485 | 296.724 | 0.46 | -0.455 | 0.217 | 0.032 | -0.002 | 0.504 | 295.498 | 0.48 | -0.569 | 0.166 | -0.005 | 0.057 | 0.593 | 286.264 | 0.5 | -0.457 | 0.245 | 0.031 | -0.011 | 0.519 | 298.196 | 0.52 | -0.57 | 0.176 | 0.003 | 0.065 | 0.597 | 287.159 | 0.54 | -0.459 | 0.254 | 0.031 | -0.013 | 0.525 | 298.959 | 0.56 | -0.452 | 0.215 | 0.031 | -0.002 | 0.501 | 295.439 | 0.58 | -0.562 | 0.151 | 0.003 | 0.068 | 0.582 | 285.039 | 0.6 | -0.502 | 0.3 | 0.013 | -0.05 | 0.585 | 300.863 | 0.62 | -0.49 | 0.258 | 0.032 | -0.032 | 0.554 | 297.768 | 0.64 | -0.503 | 0.255 | 0.031 | -0.035 | 0.564 | 296.883 | 0.66 | -0.474 | 0.264 | 0.046 | -0.007 | 0.543 | 299.116 | 0.68 | -0.599 | 0.208 | -0.005 | 0.046 | 0.634 | 289.149 | 0.7 | -0.51 | 0.31 | 0.02 | -0.029 | 0.597 | 301.293 | 0.72 | -0.49 | 0.32 | 0.015 | -0.005 | 0.585 | 303.147 | 0.74 | -0.582 | 0.276 | -0.014 | 0.016 | 0.644 | 295.372 | 0.76 | -0.557 | 0.271 | -0.011 | -0.017 | 0.619 | 295.945 | 0.78 | -0.551 | 0.288 | -0.016 | -0.024 | 0.622 | 297.595 | 0.8 | -0.527 | 0.262 | -0.024 | -0.015 | 0.589 | 296.434 | 0.82 | -0.54 | 0.186 | -0.01 | 0.06 | 0.571 | 289.006 | 0.84 | -0.559 | 0.184 | -0.01 | 0.034 | 0.589 | 288.219 | 0.86 | -0.499 | 0.181 | -0.017 | 0.045 | 0.531 | 289.937 | 0.88 | -0.534 | 0.324 | 0.015 | 0.072 | 0.625 | 301.247 | 0.9 | -0.522 | 0.325 | 0.013 | 0.075 | 0.615 | 301.907 | 0.92 | -0.447 | 0.196 | -0.002 | 0.049 | 0.488 | 293.676 | 0.94 | -0.476 | 0.247 | -0.018 | 0.021 | 0.536 | 297.425 | 0.96 | -0.519 | 0.413 | 0.011 | 0.041 | 0.663 | 308.511 | 0.98 | -0.482 | 0.389 | 0.005 | -0.012 | 0.619 | 308.905 | 1 | -0.487 | 0.354 | 0.014 | 0.018 | 0.602 | 306.013 | 1.02 | -0.477 | 0.316 | 0.001 | -0.029 | 0.572 | 303.523 | 1.04 | -0.583 | 0.379 | 0.013 | 0.068 | 0.695 | 303.027 | 1.06 | -0.561 | 0.373 | 0.008 | 0.072 | 0.674 | 303.619 | 1.08 | -0.666 | 0.295 | 0.057 | 0.036 | 0.728 | 293.891 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |||
| 4 | 3 | 5/16/23 14:43 | 289.61 | 3MHz | HD | 1.22 | 0.02 | 0.11 | 0.12 | -0.611 | 0.189 | -0.005 | -0.021 | 0.64 | 287.188 | 0.14 | -0.609 | 0.179 | -0.007 | -0.017 | 0.635 | 286.379 | 0.16 | -0.625 | 0.182 | -0.009 | -0.009 | 0.651 | 286.236 | 0.18 | -0.628 | 0.179 | -0.008 | -0.006 | 0.653 | 285.909 | 0.2 | -0.62 | 0.161 | -0.009 | 0.002 | 0.641 | 284.557 | 0.22 | -0.616 | 0.161 | -0.008 | 0.008 | 0.637 | 284.647 | 0.24 | -0.62 | 0.155 | -0.011 | 0.009 | 0.639 | 284.036 | 0.26 | -0.611 | 0.147 | -0.013 | 0.015 | 0.628 | 283.528 | 0.28 | -0.59 | 0.146 | -0.008 | 0.011 | 0.608 | 283.899 | 0.3 | -0.564 | 0.153 | 0.001 | -0.007 | 0.584 | 285.178 | 0.32 | -0.558 | 0.161 | 0.003 | -0.012 | 0.581 | 286.094 | 0.34 | -0.556 | 0.169 | 0.001 | -0.019 | 0.581 | 286.907 | 0.36 | -0.558 | 0.175 | 0.004 | -0.031 | 0.585 | 287.412 | 0.38 | -0.528 | 0.139 | 0.016 | -0.007 | 0.546 | 284.749 | 0.4 | -0.535 | 0.143 | 0.013 | -0.013 | 0.554 | 284.965 | 0.42 | -0.547 | 0.153 | 0.008 | -0.014 | 0.568 | 285.627 | 0.44 | -0.532 | 0.155 | 0.013 | -0.027 | 0.554 | 286.244 | 0.46 | -0.536 | 0.154 | 0.01 | -0.028 | 0.558 | 286.03 | 0.48 | -0.536 | 0.163 | 0.001 | -0.034 | 0.56 | 286.915 | 0.5 | -0.527 | 0.159 | 0.002 | -0.032 | 0.55 | 286.789 | 0.52 | -0.527 | 0.177 | 0.004 | -0.018 | 0.556 | 288.565 | 0.54 | -0.528 | 0.176 | 0.007 | -0.007 | 0.557 | 288.435 | 0.56 | -0.531 | 0.171 | 0.008 | -0.001 | 0.558 | 287.85 | 0.58 | -0.547 | 0.175 | 0.01 | 0 | 0.574 | 287.741 | 0.6 | -0.56 | 0.176 | 0.015 | -0.006 | 0.587 | 287.447 | 0.62 | -0.564 | 0.198 | 0.014 | -0.002 | 0.598 | 289.344 | 0.64 | -0.579 | 0.207 | 0.011 | -0.013 | 0.615 | 289.673 | 0.66 | -0.569 | 0.21 | 0.013 | 0 | 0.607 | 290.258 | 0.68 | -0.564 | 0.193 | 0.016 | 0.003 | 0.596 | 288.891 | 0.7 | -0.553 | 0.191 | 0.009 | 0.005 | 0.585 | 289.054 | 0.72 | -0.557 | 0.169 | 0.009 | -0.001 | 0.582 | 286.878 | 0.74 | -0.547 | 0.153 | 0.002 | 0.003 | 0.568 | 285.627 | 0.76 | -0.538 | 0.153 | 0.002 | 0.013 | 0.559 | 285.875 | 0.78 | -0.545 | 0.16 | 0.004 | 0.009 | 0.568 | 286.361 | 0.8 | -0.533 | 0.167 | 0.001 | -0.007 | 0.559 | 287.397 | 0.82 | -0.54 | 0.203 | 0.001 | 0.004 | 0.577 | 290.603 | 0.84 | -0.537 | 0.18 | 0.007 | 0.015 | 0.566 | 288.531 | 0.86 | -0.571 | 0.169 | 0.003 | 0.015 | 0.595 | 286.487 | 0.88 | -0.565 | 0.129 | -0.001 | 0.033 | 0.58 | 282.861 | 0.9 | -0.605 | 0.182 | -0.026 | 0.014 | 0.632 | 286.743 | 0.92 | -0.585 | 0.187 | -0.018 | 0.016 | 0.614 | 287.727 | 0.94 | -0.587 | 0.188 | -0.021 | -0.001 | 0.616 | 287.759 | 0.96 | -0.557 | 0.225 | -0.012 | -0.031 | 0.601 | 291.996 | 0.98 | -0.592 | 0.211 | -0.026 | -0.007 | 0.628 | 289.617 | 1 | -0.583 | 0.201 | -0.026 | -0.001 | 0.617 | 289.023 | 1.02 | -0.503 | 0.159 | -0.027 | -0.008 | 0.528 | 287.542 | 1.04 | -0.494 | 0.176 | -0.028 | 0.011 | 0.524 | 289.61 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |||
Sheet1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| D2 | D2 | =TAKE(FILTER(G2:NB2,NOT(ISNA(G2:NB2))),,-2) |
| C2:C4 | C2 | =TAKE(FILTER(G2:NB2,NOT(ISNA(G2:NB2))),,-1) |
