If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I want to compare two coloumn particular text, then count total
I would like to compare two different coloumn particular text then count total
example: A1= "IN" , D1= "RES" A2= "FI" , D2= "SBK" A3= "IN", D3="RES" i would like to compare above coloumn i.e. how many "in" = RES, how many "FI"= sbk please help me |
#2
|
|||
|
|||
I want to compare two coloumn particular text, then count total
Hi - try:
=sumproduct(--(A1:A100="IN"),--(B1:B100="RES")) You could also generate a pivot table out of your columns taht would count all the combiantions of values "Ashraf C.H." wrote: I would like to compare two different coloumn particular text then count total example: A1= "IN" , D1= "RES" A2= "FI" , D2= "SBK" A3= "IN", D3="RES" i would like to compare above coloumn i.e. how many "in" = RES, how many "FI"= sbk please help me |
#3
|
|||
|
|||
I want to compare two coloumn particular text, then count total
Hi,
=sumproduct((A1:A10="IN")*(D110="RES")) "Ashraf C.H." wrote: I would like to compare two different coloumn particular text then count total example: A1= "IN" , D1= "RES" A2= "FI" , D2= "SBK" A3= "IN", D3="RES" i would like to compare above coloumn i.e. how many "in" = RES, how many "FI"= sbk please help me |
#4
|
|||
|
|||
I want to compare two coloumn particular text, then count total
And if you're using xl2007, then you could look at =countifs()
Ashraf C.H. wrote: I would like to compare two different coloumn particular text then count total example: A1= "IN" , D1= "RES" A2= "FI" , D2= "SBK" A3= "IN", D3="RES" i would like to compare above coloumn i.e. how many "in" = RES, how many "FI"= sbk please help me -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|