| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting pairs
Hello,
I have a little problem with counting pairs of values in vertically adjacent cells, hope you can help... Cells from A1 to A8 contain Aaa, Xxx, Aaa, Xxx, Aaa, Yyy, Bbb, Yyy. I have 24 similar columns. Generally, odd rows contain Aaas or Bbbs and even ones - only Xxxs or Yyys. Is there a way to count the amount of *pairs* of e.g. Aaas and Xxxs? (He 2 pairs) I'll be very grateful for any clues... -- Thank you very much - Piotrek |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Working with pairs of cells | Excel Worksheet Functions | |||
| Sum product of many pairs of columns | Excel Worksheet Functions | |||
| create pairs of addresses? | Excel Discussion (Misc queries) | |||
| Labeling Data Pairs | Charts and Charting in Excel | |||
| Counting Match Pairs In Rows | Excel Worksheet Functions | |||
Threaded Mode
