Google Spreadsheet Post #1467
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-02-2014
post by chessphi (http://productforums.google.com/forum/?zx=ftkkyxcf4zk8#!category-topic/docs/spreadsheets/FoRVcg_yZ7A)
Need spreadsheet function for last X entries in a column
Hi,
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!
------------------------------------------------------------------------------------------------------------------------------------------------
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-02-2014
post by chessphi (http://productforums.google.com/forum/?zx=ftkkyxcf4zk8#!category-topic/docs/spreadsheets/FoRVcg_yZ7A)
Need spreadsheet function for last X entries in a column
Hi,
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!
------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment