Hello, I have a list of data, and am attempting to pull out a certain set of numbers from it.
I am attaching the data here, but what I need help with is pulling out the Owner Code from the first modem listed (SN#). It will either return "Purchased" or "Rental/Lease"
Is this possible?
If so, I appreciate any and all help that you all can provide.
I am attaching the data here, but what I need help with is pulling out the Owner Code from the first modem listed (SN#). It will either return "Purchased" or "Rental/Lease"
Is this possible?
If so, I appreciate any and all help that you all can provide.
Book1.xlsx | |||
---|---|---|---|
A | |||
1 | Customer Equipment | ||
2 | SN#BC4DFB903DC0 ; TYPE:30; MODEL:AHCGN2250; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#88EF16696E61 ; TYPE:I; MODEL:CMODEM; OWNER CODE:P Purchased; SYS-PRIN: 8383-9700 | ||
3 | SN#F4C11428CBE8 ; TYPE:31; MODEL:AHCGA4131; OWNER CODE:R Rental/Lease; SYS-PRIN: 8384-9700 | ||
4 | SN#FC528D0429F2 ; TYPE:30; MODEL:AHTC8717; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#FC528D0429F3 ; TYPE:I; MODEL:CMODEM; OWNER CODE:P Purchased; SYS-PRIN: 8383-9700 SN#KBAD0QGYKHGSHBXA ; TYPE:EE; MODEL:EEROPRO6; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#KBAT00SYZVEX964B ; TYPE:EE; MODEL:EEROPRO6; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#M11816TH0926 ; TYPE:EB; MODEL:DCX860QI3; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 | ||
5 | SN#8C61A3C648B5 ; TYPE:I; MODEL:CMODEM; OWNER CODE:P Purchased; SYS-PRIN: 8383-9700 SN#B077AC2BB514 ; TYPE:I; MODEL:CMODEM; OWNER CODE:P Purchased; SYS-PRIN: 8383-9700 | ||
6 | SN#0024D147ECE6 ; TYPE:I; MODEL:AHDHG575; OWNER CODE:R Rental/Lease; SYS-PRIN: 8384-9700 SN#734033500810 ; TYPE:DT; MODEL:THOMDTA; OWNER CODE:R Rental/Lease; SYS-PRIN: 8384-9700 SN#734106202626 ; TYPE:DT; MODEL:THOMDTA; OWNER CODE:R Rental/Lease; SYS-PRIN: 8384-9700 SN#C8FB26A19D44 ; TYPE:I; MODEL:AHDPC3008; OWNER CODE:R Rental/Lease; SYS-PRIN: 8384-9700 SN#PAEY12184876 ; TYPE:SE; MODEL:PCRNG110R; OWNER CODE:R Rental/Lease; SYS-PRIN: 8384-9700 | ||
7 | SN#4432C86953BE ; TYPE:I; MODEL:AHDCM476; OWNER CODE:R Rental/Lease; SYS-PRIN: 8384-9700 SN#5C571A5E6718 ; TYPE:I; MODEL:AHTM604G; OWNER CODE:R Rental/Lease; SYS-PRIN: 8384-9700 SN#F4C11482717A ; TYPE:31; MODEL:AHCGA4131; OWNER CODE:R Rental/Lease; SYS-PRIN: 8384-9700 | ||
8 | SN#484BD4DFA5CB ; TYPE:31; MODEL:AHCGA4236; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#EVW844H04168 ; TYPE:EB; MODEL:EBOX; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#EVY631H05955 ; TYPE:EB; MODEL:EBOX; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#E475DC626D60 ; TYPE:31; MODEL:CM4652442; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#MA1923PJ5800 ; TYPE:EB; MODEL:DCX860QI3; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 | ||
9 | SN#001DCFE12127 ; TYPE:I; MODEL:AHTM601A; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#3K023062 ; TYPE:M; MODEL:REGAL; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#3K024832 ; TYPE:M; MODEL:REGAL; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#541379E3A857 ; TYPE:31; MODEL:AHUBC1301; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#D1209D900153CDC ; TYPE:TI; MODEL:IPW9001; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#D1209D900403BAA ; TYPE:TI; MODEL:IPW9001; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#D6903D7924D44EA ; TYPE:X2; MODEL:DCX900MG2; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 | ||
10 | SN#441C125B72F3 ; TYPE:31; MODEL:AHCGA4234; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9400 SN#688F2E7437F0 ; TYPE:31; MODEL:AHCOD4589; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9400 | ||
11 | SN#00159AE81DE8 ; TYPE:I; MODEL:CMODEM; OWNER CODE:P Purchased; SYS-PRIN: 8383-9400 SN#00159AE81EE8 ; TYPE:I; MODEL:CMODEM; OWNER CODE:P Purchased; SYS-PRIN: 8383-9400 SN#98F781555563 ; TYPE:I; MODEL:CMODEM; OWNER CODE:P Purchased; SYS-PRIN: 8383-9400 SN#A004609AC760 ; TYPE:I; MODEL:CMODEM; OWNER CODE:P Purchased; SYS-PRIN: 8383-9400 | ||
12 | SN#0C473DABCB50 ; TYPE:I; MODEL:AHCGNVRES; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9400 SN#734033607077 ; TYPE:DT; MODEL:THOMDTA; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9400 SN#734033612015 ; TYPE:DT; MODEL:THOMDTA; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9400 SN#734033618699 ; TYPE:DT; MODEL:THOMDCI; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9400 | ||
Sheet1 |