count new entries from dates

[RodrigoFinguer]

Hi guys, i really need this. I am thinking about more than a month but i can't get it!

I have values (serial numbers) in different dates, i will send a picture for better understanding.

I need to calculate the serial numbers which is new, the values that weren't yesterday in my sheet but it is today. I just know how to do it using dynamic table... there is a way to do it with formulas? Thank you so much!!

In my image, the green values are the same in both days and the blue ones are the new values.

 

[Legacy 436357]

Hi,

Without knowing the details maybe you can adapt this for your range:

=countif(a1:a10,"="&today())

 

[RodrigoFinguer]

Hi,

Without knowing the details maybe you can adapt this for your range:

=countif(a1:a10,"="&today())

Look at this:

https://imgur.com/a/e9aOzHv

I need a formula to count the blue values in the "N" column. A formula to count how many values are new at day 24/01 that weren't at 23/01.

 

[Fluff]

How about

Excel 2013/2016
	M	N	O	P	Q
2	Serial No.	Date
3	70859	23/01/2019		24/01/2019	4
4	84732	23/01/2019
5	63403	23/01/2019
6	75705	23/01/2019
7	55287	23/01/2019
8	89542	23/01/2019
9	69636	23/01/2019
10	70859	24/01/2019
11	84732	24/01/2019
12	63403	24/01/2019
13	88676	24/01/2019
14	75367	24/01/2019
15	70850	24/01/2019
16	77030	24/01/2019
Key

Cell Formulas
Range	Formula
Q3	=SUMPRODUCT(--(COUNTIF(M3:M16,M3:M16)=1)*(N3:N16=P3))

 

[RodrigoFinguer]

What does the "--" means?

 

[Fluff]

It converts True/False values to 1 or 0, but it doesn't need to be there on this occasion.

Also please do not quote entire posts as it just clutters up the board.

 

[RodrigoFinguer]

It converts True/False values to 1 or 0, but it doesn't need to be there on this occasion.

Also please do not quote entire posts as it just clutters up the board.

Ah okay, i'm sorry.
It worked, but there is a way to calculate the new values comparing to yesterday? Your formula calculates the new values without comparison.

 

[Fluff]

What would you expect the outcome to be with the data in post#4?

 

[RodrigoFinguer]

What would you expect the outcome to be with the data in post#4 ?

The result is correct in post #4 , but in my worksheet there is data from 02/01/2019 to today. Applying your formula, returns the values that weren't NEVER in my sheet but today, but I actually need the values that weren't just the last worked day, that was friday. So, a comparison between yesterday(or friday in this case) and today, showing me the new values from friday to today. I don't know if i was clear.

 

[RodrigoFinguer]

Excel 2013/2016

	M	N	O	P	Q

<tbody>
[TD="align: center"]2[/TD]
[TD="align: center"]Serial No.[/TD]
[TD="align: center"]Date[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: center"]70859[/TD]
[TD="align: center"]22/01/2019[/TD]
[TD="align: right"][/TD]
[TD="align: center"]24/01/2019[/TD]
[TD="align: right"]6[/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]84732[/TD]
[TD="align: center"]22/01/2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: center"]63403[/TD]
[TD="align: center"]22/01/2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: center"]75705[/TD]
[TD="align: center"]22/01/2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: center"]55287[/TD]
[TD="align: center"]23/01/2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: center"]89542[/TD]
[TD="align: center"]23/01/2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: center"]69636[/TD]
[TD="align: center"]23/01/2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: center"]70352[/TD]
[TD="align: center"]23/01/2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="align: center"]70859[/TD]
[TD="align: center"]24/01/2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="align: center"]84732[/TD]
[TD="align: center"]24/01/2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]
[TD="align: center"]88676[/TD]
[TD="align: center"]24/01/2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: center"]75367[/TD]
[TD="align: center"]24/01/2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]
[TD="align: center"]70850[/TD]
[TD="align: center"]24/01/2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]
[TD="align: center"]77030[/TD]
[TD="align: center"]24/01/2019[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Like this... My outcome is 6 because none of these values in day 24/01 are in 23/01, but it can still be in older days, like 22/01