Thursday, January 2, 2014

yogi_Count Instances Of Specified Entities From The Last Specified Number Of Entries In Column A

                                          Google Spreadsheet   Post  #1467
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jan-02-2014
post by chessphi (!category-topic/docs/spreadsheets/FoRVcg_yZ7A)
Need spreadsheet function for last X entries in a column

Somewhat new to spreadsheet functions and I happen to hardcode data that looks something like this:

A  B
1  W
2   L
3  W
4   L
5  W
6   L
7  W
8   L
9   L
10 W

...and it continues on to about 100 rows or so.

I need to get two values on column B:
1) the number of W's in the last 5 entries, and
2) the number of L's in the last 5 entries

Thanks in advance!