Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to compare two columns and get a output from it
example
A1 A2 6.5.6 R200 6.5.6 R200 5.6 R100 here basically i have two column a1 and a2 and i want to count all R200 which has 6.5.6 how do i do this? rajesh |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to compare two columns and get a output from it
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to compare two columns and get a output from it
Scoops wrote: wrote: example A1 A2 6.5.6 R200 6.5.6 R200 5.6 R100 here basically i have two column a1 and a2 and i want to count all R200 which has 6.5.6 how do i do this? rajesh Hi rajesh I *think* you want to count the number of times that 6.5.6 is in the same row as R200. If so, try this: =SUMPRODUCT((A3:A5="6.5.6")*(B3:B5="R200")) Regards Steve Thanks steve, you gave perfect answer. rajesh |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to compare two columns and get a output from it
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|