Finding entries that first appear only after a certain date

[shredr]

Good afternoon...I have a sheet that lists part numbers and orders going back about 10 years or so...probably about 40000 rows

I need to figure out how many new parts appear per year, along with a list of what they are.
Ideally, I'd like to filter by date (say 2022) and get a list of items that were new that year

This is what my columns are:

(Everything in the cells is just data, the only oddball is columnA that catconcates Cols B& D)

Not sure what the simplest way to do this would be...haven't seen anything yet that gets me there.

Thanks for any & all suggestions!

 

[awoohaw]

what version of excel are you using? what column has the part number? I'm guessing the date to filter is column H? Can you provide some examples of expected results?

 

[shredr]

what version of excel are you using? what column has the part number? I'm guessing the date to filter is column H? Can you provide some examples of expected results?

working with Excel365

Column F has the p/n
Column H is the date

Ideally if I filter is for say 2022 in ColH, the result would give me any p/n that was produced for the first time that year


I have some new overlords who are requesting how many new parts were introduced over the last 10 years, broken down by year, with a list of p/n and description

results something like this? doesn't have to be anything fancy, just a list I can paste into a report

(and I'm guess a "Go Hoos" is in order by you handle? My daughter's graduating from there in a couple weeks...)

 

[awoohaw]

You're the first to figure that out.! Or least inquire about it. The desired handle was already taken, so I just said, okay backwards will do.
Congrats to your daughter. I was able to go there when it was just a tad less difficult (being very facetious, I would not get in to many good colleges today with my scores from way back then) to get in. My son with a 4.0 was not accepted (his SAT was not quite 1400).

Regarding your question, I just want to confirm, you would not want to see washers in a new parts list of 2023, is that correct?

 

[Tetra201]

Using your column layout from Post #1 (P/N in column F): try adding a helper column, say column X, placing the following formula in cell X2 and drag-copying it down as needed.

=IF(COUNTIFS($F$2:F2,F2)=1,"New","")

Next, filter your data by date (column H) and by "New" (column X).

 

[shredr]

Using your column layout from Post #1 (P/N in column F): try adding a helper column, say column X, placing the following formula in cell X2 and drag-copying it down as needed.

=IF(COUNTIFS($F$2:F2,F2)=1,"New","")

Next, filter your data by date (column H) and by "New" (column X).

That's perfect, super easy!

 

[Tetra201]

Glad to have helped.

 

[shredr]

You're the first to figure that out.! Or least inquire about it. The desired handle was already taken, so I just said, okay backwards will do.
Congrats to your daughter. I was able to go there when it was just a tad less difficult (being very facetious, I would not get in to many good colleges today with my scores from way back then) to get in. My son with a 4.0 was not accepted (his SAT was not quite 1400).

Regarding your question, I just want to confirm, you would not want to see washers in a new parts list of 2023, is that correct?

Correct, would not want to see washers in 2023 listing...

Thank you, it was perfect place for for her...totally self driven, getting a BS in Bio, 3.9gpa (sorry for the humble brag!) Waffling on work or MCAT/med school...
We really enjoy visiting C'ville, sharp group of kids there.

My wife is a HS guidance counselor at a very good public school. The stories she comes home with are bananas, the admissions process has no rhyme or reason anymore. Hopefully your son landed someplace that he likes and is a good fit. I think that's the biggest thing as opposed to the 'brand'

 

[shredr]

Glad to have helped.

actually now that I'm playing around it, if I filter by year, it ignores the previous years...

I think this sol'n requires keeping all dates open (no filtering original table) to get the list of new parts, then pasting results into a new table and filtering teh new table by year.
Is that on target?