Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Column A Column B C
D E Question1 Question2 Question 3 Question 25 Correct Answer: A D A C John Bratty C D A B Willy Wonka D A D C Jenny Penny A B A C =SUMPRODUCT(--(B2:Z2=$B$1:$Z$1)) |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() Helpful newsgroup posting advice here... http://www.cpearson.com/excel/newposte.htm -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) wrote in message Column A Column B C D E Question1 Question2 Question 3 Question 25 Correct Answer: A D A C John Bratty C D A B Willy Wonka D A D C Jenny Penny A B A C =SUMPRODUCT(--(B2:Z2=$B$1:$Z$1)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I NEED HELP TO UNDERSTAND THIS MACRO!!! | Excel Discussion (Misc queries) | |||
Help me understand Transpose | Excel Worksheet Functions | |||
I don't Understand | Excel Worksheet Functions | |||
Help me understand this code | Excel Discussion (Misc queries) | |||
< |
Excel Worksheet Functions |