Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Im trying to count how may occurrences of a number there are, for a letter in the same row, for the following table (~{a,b,c}{1,2,3,4,5}~) |.a c 1 2 3.| |.b c 2 3 4.| |.a c 3 4 5.| The result should be the matrix 1 2 3 4 5 a 1 1 2 1 1 b 0 1 1 1 0 c 1 2 3 2 1 Tanks Mossi.pt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUM, COUNT and SUMPRODUCT | Excel Worksheet Functions | |||
how can I count if column A="active" and column E="Job"? | Excel Worksheet Functions | |||
Count number of uniques starting with a given letter? | Excel Discussion (Misc queries) | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
adding two sumproduct formulas together | Excel Worksheet Functions |