Hello all,
I have a sheet with the barcodes processed in each day, based on channel received.
sheet1.PNG
What i want is a formula to calculate the minimum and maximum barcode number for each day (in another sheet as below). In each day i can have multiple entries in the first tab.
sheet 2.PNG
I have tried with =min(if(argument, value if true)), but this retrieves only for the first cell the correct data.
Here is also the file.
Book1.xlsx
Can you help me please?
Thank you in advance!
Bookmarks