Lizard Of Confusion
Board Regular
- Joined
- Jan 18, 2016
- Messages
- 113
this is part of a book it seams the big problem is figuring out column E, it is a number of movies are in the pack i need E to some how convert when 1 is put into it it will put out in another cell 0100- . this will later be combined with other data on sheet coming from other columns so that when it lands into columns it looks like Act-0100-5-Jan-01 <-- a sorting number code whatever. back to main problem 1= 0100- i dont think is hard and all 1 s can be 0100- but when a 2 is entered the first one can be 0200- which will really be 2 of them 1 for each movie the next 2 entered needs to put out two 0201- s this numbering keeps the disc together for their set Act-0200 is a 2 Kurt Russell movie pack Act-0201- is another movie pack of 2 West-5000 is 50 western movie collection only one of these dose anybody have a clue as to where to even start with trying to make this thing figure out how when or why to change its number from 0200- after making 2 of them to 0201- there is another column in sheet that is listed as "belongs to" this basically the name of the set can this be used some way ?
any help with trying to figure this out is much appreciated and thank you in advance
Excel 2012
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
any help with trying to figure this out is much appreciated and thank you in advance
Excel 2012
D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6 | Column E | Column F | Column AL | Column AM | Column AN | Column AO | Column AP | Column AQ | Column AR | Column AS | AT | Column AX | BH | |
7 | No. Of Movies | Date | Name | Movie Genre | Movie Genre2 | Movie Genre3 | Movie Genre4 | Movie Genre5 | Movie Genre6 | Movie Genre7 | Movie Pict. | No. Of Movies2 | Belongs to | Column92 |
8 | 1 | 5-Jan-01 | Action, Drama, Thriller, Crime, | Action | Drama | Thriller | Crime | Act- | 0100- | Act-0100-5-Jan-01 | ||||
9 | 1 | 16-Jan-98 | Action, Crime, Drama | Action | Crime | Drama | Act- | 0100- | Act-0100-01-Jan-16 | |||||
10 | 2 | 15-Mar-96 | Action, Adventure | Action | Adventure | Act- | 0200- | Kurt Russell Collection (Executive Decision / Unlawful Entry) | Act-0200-03/15/1996 | |||||
11 | 2 | 26-Jun-92 | Action, Adventure, Crime, Drama, Thriller | Action | Adventure | Crime | Drama | Thriller | Act- | 0200- | Kurt Russell Collection (Executive Decision / Unlawful Entry) | Act-0200-06/26/1992 | ||
12 | 2 | 24-May-02 | Action, Adventure, Drama, Mystery, Thriller | Action | Adventure | Drama | Mystery | Thriller | Act- | 0201- | Devil's Advocate / Insomnia (Double Feature) | Act-0201-05/24/2002 | ||
13 | 2 | 17-Oct-97 | Action, Adventure, Drama, Mystery, Thriller | Action | Adventure | Drama | Mystery | Thriller | Act- | 0201- | Devil's Advocate / Insomnia (Double Feature) | Act-0201-10/17/1997 | ||
14 | Crap | |||||||||||||
15 | 3 | 28-Jan-00 | Drama, Mystery, Thriller | Drama | Mystery | Thriller | Drama- | |||||||
16 | 4 | 5-Feb-10 | Drama, Music, Romance | Drama | Music | Romance | Drama- | |||||||
17 | 5 | War, Drama, | War | Drama | War- | |||||||||
18 | 6 | War, WWII, History, Drama | War | WWII | History | Drama | War- | |||||||
19 | 8 | War, Biography, History, Drama, Documentary | War | Biography | History | Drama | Documentary | War- |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet5