Have you ever used Excel’s subtotal functionality? It’s great for counting things. For instance, I’m running some tests right now, where the output is a sequence. If I run the test 10,000 times, then I have 10,000 sequences. I want to know how many times each sequence happens. I copy the output into Excel, then …
Continue reading “Excel Tip: Copy Subtotal (Aggregate) Data Only”