I have 4 columns of data.
A: DVD information
B: DVD Title (in order of DVD information)
C: Season and episode number
D: Television title (in order of season and episode)
I'm tryin to output the Season and episode number and Television title in
the order of the DVDs so I can make the new video titles with the season
and episode information.
For example: A2: 1-1-01 | B2: Baseball Bugs | C144: S1946E02 | D144:
Baseball Bugs
The DVD titles don't line up with the episode order.
So I used this formula: =unique( {
filter( B2:B, len(B2:B) ), arrayformula( iferror( vlookup( filter( B2:B, len
(B2:B) ), D2:D, 1, false ) ) ); arrayformula( iferror( vlookup( filter( D2:D
, len(D2:D) ), B2:B, 1, false ) ) ), filter( D2:D, len(D2:D) ) } )
It's matching the DVD and TV titles and showing any gaps, but I need the
season and episode information to go with the rearranged TV titles. So how
do I get the rows in Column C to output with the corresponding rows in
Column D (I imported them together in order)
Thanks in advance.
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-spreadsheets-api/008989dd-9643-49b2-a60d-609712de53fen%40googlegroups.com.
