Hi,
I am new to the forum and was just hoping to get some help analysing my experimental results.
I have attached an example spreadsheet of the data.
Basically the data is generated by tracking bees using antennas. The antennas are numbered 1,2,3 or 4 (Column C).
I need to count how many times 3 or 4 occur in a sequence. eg the count of (3,4,3,4,3) would equal 5.
Antenna 1+2 can be ignored.
Time Bee ID Antenna
20170413T082042.394418+10 14 3 (eg.Either 3 or 4 occurred 5 times a row)
20170413T082042.394418+10 14 4
20170413T082042.660167+10 14 3
20170413T082042.660167+10 14 4
20170413T082042.919958+10 14 3
Any help would be greatly appreciated.
Cheers
Bookmarks