Display total countif data

[lazylilsnoop]

Hi guys, i need help on the excel sheet.

I'm trying to display all the cloumn that replies "Y".
first step is i count total of inquiry =counta(O5:O130) [return value 110],
then for every inquiry that was responded i marked "Y".
so i use =countif(O5:O130,"Y"), it return me 52

now the question is how do i display all the 52 details only? i do not want to view the unresponded inquiry.

thanks guys

example, shrink down by 10x

date	End User	Description	Quote	Responded
1/1/14	Mr X			Y
1/1/14	Mr Y
1/1/14	Mr X
1/1/14	Mr V			Y
1/1/14	Mr K
2/1/14	Mr K			Y
3/1/14	Mr Y			Y

<tbody>
</tbody>

 

[Aladin Akyurek]

Try to adapt from the following:
http://www.mrexcel.com/forum/excel-questions/307832-multiple-vlookups.html#post1511354

 

[Arithos]

Hi guys, i need help on the excel sheet.

I'm trying to display all the cloumn that replies "Y".
first step is i count total of inquiry =counta(O5:O130) [return value 110],
then for every inquiry that was responded i marked "Y".
so i use =countif(O5:O130,"Y"), it return me 52

now the question is how do i display all the 52 details only? i do not want to view the unresponded inquiry.

thanks guys

example, shrink down by 10x

date	End User	Description	Quote	Responded
1/1/14	Mr X			Y
1/1/14	Mr Y
1/1/14	Mr X
1/1/14	Mr V			Y
1/1/14	Mr K
2/1/14	Mr K			Y
3/1/14	Mr Y			Y

<tbody>
</tbody>

This: =SUMPRODUCT(--(O5:O130="Y"))
would yied the same as: =countif(O5:O130,"Y")

However, the sumproduct shows you in what place the "Y" occurs (which should help). I use this in combination with an INDEX-MATCH formula to get solutions.

 

[Arithos]

Hi guys, i need help on the excel sheet.

I'm trying to display all the cloumn that replies "Y".
first step is i count total of inquiry =counta(O5:O130) [return value 110],
then for every inquiry that was responded i marked "Y".
so i use =countif(O5:O130,"Y"), it return me 52

now the question is how do i display all the 52 details only? i do not want to view the unresponded inquiry.

thanks guys

example, shrink down by 10x

date	End User	Description	Quote	Responded
1/1/14	Mr X			Y
1/1/14	Mr Y
1/1/14	Mr X
1/1/14	Mr V			Y
1/1/14	Mr K
2/1/14	Mr K			Y
3/1/14	Mr Y			Y

<tbody>
</tbody>

Another Idea could be to just Sort the Range(K5:O130) on column "O", and you will the the U's as the top 52 entrys. then copy them and paste where you would like them to be. You can add a filter etc

 

[Aladin Akyurek]

Another Idea could be to just Sort the Range(K5:O130) on column "O", and you will the the U's as the top 52 entrys. then copy them and paste where you would like them to be. You can add a filter etc

Try the link I provided. It's an efficient set up to gather a sublist of relevant records...

 

[lazylilsnoop]

Another Idea could be to just Sort the Range(K5:O130) on column "O", and you will the the U's as the top 52 entrys. then copy them and paste where you would like them to be. You can add a filter etc

huh?? dont get it.

i'm actually trying to display all the with "Y" value only, do not want to see those details where no "Y" exist.

my end product will be like this.

Date	End User	Description	Quote	Responds
1/1/14	Mr X			Y
1/1/14	Mr V			Y
2/1/14	Mr K			Y
3/1/14	Mr Y			Y

<tbody>
</tbody>

im guessing i should use "vlookup function"
but somehow doesnt make sense.... i think


thanks

 

[lazylilsnoop]

i think i got it mixed up a little.

so from previous table, I calculated how many "Y" it is. then i want to know how many of it i replied (which i will put "Y")
i would like the end result to be

End User	Jan	Feb	Mar	Apr	May
A			1
B	3
C		1
D				4
E	1
F		1			5
G		2			2

<tbody>
</tbody>

i think this should make more sense....
cause my excel is like 50 over buyers

 

[lazylilsnoop]

Try the link I provided. It's an efficient set up to gather a sublist of relevant records...

the link u provided is AWESOME, but i need to do for the whole 12months, so the final product will be like

End User	Jan	Feb	Mar	Apr	May
A			1
B	3
C		1
D				4
E	1
F		1			5
G		2			2

<tbody>
</tbody>

 

[Arithos]

Try the link I provided. It's an efficient set up to gather a sublist of relevant records...

Dit not see it was a link (did not hover mouse over it) :S

 

[Aladin Akyurek]

the link u provided is AWESOME, but i need to do for the whole 12months, so the final product will be like

End User	Jan	Feb	Mar	Apr	May
A			1
B	3
C		1
D				4
E	1
F		1			5
G		2			2

<TBODY>
</TBODY>

Care to post the data from which this out put is derived?