I don't know if anyone will find this useful, but here's something I learned literally this weekend. Sort rows/cells into groups based on the value of a cell.

I don't know if anyone will find this useful, but here's something I learned literally this weekend. Sort rows/cells into groups based on the value of a cell. =FILTER(Stories!B2:D13,Stories!F2:F13=A2) First parameter, "Stories!B2:D13" is a group of cells showing some stories. Second parameter, "Stories!F2:F13=A2" is the column where each cell is compared to the value of A2. Rows that match are then copied into wherever the =FILTER formula is placed. I use it to take a list of Stories and sorts them into Sprints automatically. That's useful for program increment planning, etc. The other useful Excel thing I learned recently is: =IF(NOT(ISBLANK(A2)),HYPERLINK("https://jira-instance.atlassian.net/browse/PROJECT-"&A2,"PROJECT-"&A2),"") That says: If the cell A2 is not blank, append its value onto the url given, and show that as a link with the text PROJECT- with the value of A2 appended. I know I should have probably done something cooler with Emacs and org-mode, but I have to share it with a lot of business folks. If by some chance either of those are useful to you, I hope they work OK for you :)