Need help with multiple criterias on a sheet
Hi All, i need help on setting multiple criterias as im a bit stuck.
I m trying to count how many specific batteries "Super battery V3X-V4" are available, and i want to exclude recycled, refurbished and lost that have been ticked. because at the minute its only counting the number of v4 batteries that are in that exact range (D22:D20000), once i know the exact formula i will add it to the other specific batteries.
another issue i found is that i have used the formula "=D12-SUM(D14,D15,D16)" to count how many "Total number of batteries available" i have in the sheet, but when i tick both "to be recycled" and "to be refurbished" it removes them both having an incorrect data. Can i impose a criteria in both checklists "to be recycled" and "to be refurbished" that if one is ticked the other cannot so it wont affect the data for available batteries?
Also, I'm trying to set up a command where If I scan a duplicate serial number, it shows up and tells me how many are duplicate, but specific serial numbers, not in total. i have set up the criteria that the box changes colour if duplicate, but when you deal with thousands of batteries, it gets a bit of an issue, even if I use a filter, it still takes time, is there an easier way to catch on a separate sheet\cell the exact serial numbers that are duplicate and find them on the coloumn to then delete edit?
Thank you so much for your help
Help Article Resources
Check out the Formula Handbook template!