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!
Last edited by roxana_rox; 09-11-2015 at 06:02 AM.
I think you better to go with Pivot Table for this.
If you dont know about Pivot Table, Please provide the report so that I'll make it for you
Please post a file as many of us are unable to view PNG files.
Click "Go Advanced" then Paper Clip icon to upload file.
Thank you!
Indeed i can handle this using pivot tables, but this is a template and i hoped that this can be done automatically using formulas.
Did you check the reference locking is correct in your formula? If references will dancing it may be cause of the this result.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
I have added also the excel file
You have putted range reference in if function argument so you need to put this formula with Ctrl+Shift+Enter. And yes your formula is absolutely correct just need key Strock Ctrl+Shift+Enter.
Thank you for your help!
I was not aware of using Ctrl+Shift+Enter
Glad it helps you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks