'In Excel, how do I count the number of times a pair of phrases in Column B are associated with a unique ID in Column A?
Hoping this is something Excel can do. I work in a pharma lab, and have been assigned a task of totaling up the number of Freeze/Thaw cycles each sample/vial has gone through in our labs for a particular study. To do this, I exported a storage report from our database and pasted the pertinent info in a new worksheet, see below. Column A is a list of the barcoded labels adhered to each specimen. Column B is a list of the transfers each sample has gone through during its life cycle here.
What I am needing: the number of "Move to Thaw" / "Move to Freeze" (f/t cycles- one pair of move to thaw/move to freeze combos = 1 f/t cycle) associated with each Custom Id. Not all Custom IDs will have a F/T cycle, and some may have up to 7. All other transfer types are not important.
So....is this something Excel can do for me? There are 2000 lines in this workbook that I'd rather not go through line by line...so far, I tried filtering out all the other transfer types, but then the ones with NO f/t cycle are excluded.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|