count new entries from dates

RodrigoFinguer

Board Regular
Joined
Jun 13, 2017
Messages
75
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.
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Hi,

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

=countif(a1:a10,"="&today())
 
Upvote 0
Hi,

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

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

Look at this:
7ygRsPX

7ygRsPX

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.
 
Upvote 0
How about


Excel 2013/2016
MNOPQ
2Serial No.Date
37085923/01/201924/01/20194
48473223/01/2019
56340323/01/2019
67570523/01/2019
75528723/01/2019
88954223/01/2019
96963623/01/2019
107085924/01/2019
118473224/01/2019
126340324/01/2019
138867624/01/2019
147536724/01/2019
157085024/01/2019
167703024/01/2019
Key
Cell Formulas
RangeFormula
Q3=SUMPRODUCT(--(COUNTIF(M3:M16,M3:M16)=1)*(N3:N16=P3))
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
What would you expect the outcome to be with the data in post#4?
 
Upvote 0
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.
 
Upvote 0
Excel 2013/2016
MNOPQ
2Serial No.Date
37085922/01/201924/01/20196
48473222/01/2019
56340322/01/2019
67570522/01/2019
75528723/01/2019
88954223/01/2019
96963623/01/2019
107035223/01/2019
117085924/01/2019
128473224/01/2019
138867624/01/2019
147536724/01/2019
157085024/01/2019
167703024/01/2019

<tbody>
</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
 
Upvote 0

Forum statistics

Threads
1,213,517
Messages
6,114,085
Members
448,548
Latest member
harryls

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