Showing related tags and posts accross the entire site.
-
I've attached an example using match, countif and offset to achieve your goal, and also created a named range to demonstrate how this can be used too. You could also do the same thing in VBA code, though I'll leave that to someone else for now. Also, this assumes that your 'sections'...
-
I would suggest that the answer is in your question's title - use a pivot table. The first step would be to create a new column (column C) which provides a counter for the duplicate values in column A. Then generate a pivot table off columns A:C, with A as row headings, C as column headings and B...
-
I'm sure many of you knew this but it was new to me and I came across it today, so in an effort to get it out there a bit more, i document it here. It concerns the fact that COUNTIF and SUMIF (and their 2007 plural counterparts SUMIFS and COUNTIFS) carry forward the limitation that Excel has of 15...