Hey guys,
I had another question. I have this series as illustrated in the attachment.
I have these ID numbers in Column A which relate to Column B not in a specific way-but it just represents the occurrence of a particular episode. So most of the ID numbers in Column A have one episode number(column B) but not all. For example, the ones highlighted have the same ID number with two different episode numbers-I just need to name it as 1 if it is only 1 episode number and 2 if it is the second episode number for a particular ID number in Column C.
I hope I have expressed myself with clarity-please let me know if what I m saying is not very clear. Would greatly appreciate your help as always.
Thanks.
Bookmarks