excel-lent girl
New Member
- Joined
- Jun 22, 2012
- Messages
- 4
I'm trying to do something with excel and I'm not quite sure it's possible.
I have data on a spread sheet ranging from 1:15
One step I have taken in what I want to do is having a formula to count the number of time a certain data input shows up:
=COUNTIFS('spread sheet'!1:15,"data 1")
But what I want to do now is have excel take all the variances where the value of "data 1" is true in a cell and then count the number of times "data 2" shows up in the cell below it... so that it will count the number of times 1 is followed by 2 (or 3 or 4 etc).
Is this possible?
Thanks!
I have data on a spread sheet ranging from 1:15
One step I have taken in what I want to do is having a formula to count the number of time a certain data input shows up:
=COUNTIFS('spread sheet'!1:15,"data 1")
But what I want to do now is have excel take all the variances where the value of "data 1" is true in a cell and then count the number of times "data 2" shows up in the cell below it... so that it will count the number of times 1 is followed by 2 (or 3 or 4 etc).
Is this possible?
Thanks!