Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I really need some help to write a formula with nested functions.
How do I write a formula to calculate how many times a specific combination of values appear in two different columns. i.e. column A is populated with the values 1,2 and 3 in random order; column B is populated with values a,b and c, also in random order. What would the formula be to determine the number of times that the combination of 1 and a appear side by side on the same row; over a worksheet with 10 rows. Thanks for any help in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
creating new functions | Excel Worksheet Functions | |||
creating a excel spread sheet using ffinancial functions | Excel Worksheet Functions | |||
Creating a nested COUNTIF???? | Excel Worksheet Functions | |||
Too many nested functions | Excel Worksheet Functions |