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

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
You must log in or register to reply here.

Similar threads

S
  • Solved
Seperate Data In One Cell Across Multiple Cells
Replies
6
Views
1K
Alex Blakenburg
A
N
  • 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
Complex VBA code - Multiple IF conditions including Worksheet Name contains text partially matching Cell
Replies
1
Views
3K
celebwen_orn
C
K
  • Question
Finding IDs from one Excel that are missing in a different Excel
Replies
2
Views
645
sandy666
sandy666
R
  • 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,214,918
Messages
6,122,241
Members
449,075
Latest member
staticfluids

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