Feb 22, 2018 · I want to count a number of rows for each value appearing in a column. Is there an easy way to do this in excel? Let's say I have the following table: A B C 1 Cat A 3 Cat A 3 ...

I'm trying to figure out how to "group by" values in an Excel spreadsheet. Given the following example (this is an inventory sheet I use at my restaurant:) At the far right of the spreadsheet …

Nov 1, 2018 · Each group is 3 columns. Group 1 is 1500 cells long. Group 2 is 500 cells long. I need to see if there are any matches from group 2 in group 1 and highlight them. I know you …

Jun 13, 2019 · I'm trying to find out if there's a shortcut key combination in Excel to expand & collapse an entire group outline level. This would be the the equivalent of mouse clicking on …

Jun 15, 2020 · Excel decides I want to join this somehow to the first one. Group columns G:J together This creates a group but combines it with the one done in step 1 Can this behavior be …

I have a formula where I am checking for a range of cells whether or not they are blank. If all of them are blank I want to return another blank. If any of the cells in the range are not blan...

Oct 29, 2010 · Bonus: You can have excel automatically highlight the cells that you're looking for by adding conditional formatting to those cells. Select all of the cells you want to format and …

Jul 23, 2021 · I have an Excel table with 4 columns - name of the company, website, area, and description. How do I group the companies from the same area (column 3 in my case) together?

Nov 18, 2020 · As always there are many ways to skin an excel cat. Go with pivot tables and count the number of occurrences in three separate tables (pivot tables are easier than they …

Aug 6, 2020 · A1:C1 and F2:H2 (as in A1:C1:F2:H2 or simply the result Excel uses from that expression, A1:H2) This example would give two rows and eight columns rather than a single …