How to find missing values is a series from 1 to N?

E

east3rd

New Member
Joined
Sep 8, 2008
Messages
48
I receive a large daily report (50K+ lines) that contains all of the TV content we carry. What I'm trying to figure out, is how to find if I'm missing any episodes? The data table contains the following: Title, SeriesName, SeasonNumber, EpisodeNumber

My thinking is I need to determine if an "EpisodeNumber" for a given "SeriesName", within a given "SeasonNumber" is missing when the "EpisodeNumber" values range from 1 to N. Make sense?

Happy to send along some Game of Thrones data for any fans willing to help!

Thanks
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
You must log in or register to reply here.

Similar threads

S
  • Solved
Seperate Data In One Cell Across Multiple Cells
Replies
6
Views
2K
Alex Blakenburg
A
N
  • Question Question
Join data from second worksheet with delimited list values (mults) to another worksheet with one value per cell/row and keep 1:1 relationship
Replies
2
Views
1K
HeadAgainstABrickWall
H
C
  • Question Question
Complex VBA code - Multiple IF conditions including Worksheet Name contains text partially matching Cell
Replies
1
Views
3K
celebwen_orn
C
K
  • Question Question
Finding IDs from one Excel that are missing in a different Excel
Replies
2
Views
803
sandy666
sandy666
R
  • Question Question
How to find a maximum value from a list of json pairs using Excel vba ?
Replies
1
Views
1K
Rasmita Nayak
R

Forum statistics

Threads
1,223,054
Messages
6,169,834
Members
452,284
Latest member
TKM623

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top