Excel script

To an existing project: 1. Some cells don't remove the dot "." 2. "HR Packs" tab, kids need to be in alphabetical order 3. HR packages come in 2 different formats, please include both in HR tab. One has a header "Package: HIGH RESOLUTION Package" but the other doesn't. 4. "Social media" tab does not highlight duplicates. 5. "To print" tab, please separate print sizes by light gray shade and white 6. "To print tab", In every print size, higlight duplicates separately in different colors, Can this be done? Maybe use "=ArrayFormula(IFERROR(--(countif(A:A,A2:A)>1)*MATCH(A2:A,A:A),0))" like in [login to view URL] 7. Create another tab with all these products totals: 4x6 (witin a package), 4x6 (single prints), 4x6 total prints, 5x7, 6x8 (call it "group images"), 8x10 single prints, 8x10 within a package, 8x10 total prints, Single Social media, Single Hi res, Basic Package, Standard Package, Social Media Package, Hi res Package, "two room photo" package.