Question about only showing a list of values which are not 0. Thanks! learning a lot! trying to improve my skills!

[gorhamsj]

HI guys!!
Hope everyone is well. I am just trying to improve some skills and everyone here has been so kind!! Means a lot!!!
Quick question

If I have a list like this

Apple: 2
Orange: 3
Peach: 0
Banana: 1
Grape: 0
Mango 0
Papaya: 1


What formula can I use to make the list remove the values which are zero... so in the end it will look like

Apple: 2
Orange: 3
Banana: 1
Papaya: 1

Thanks whoever can help me with this rocks

 

[caabyyc]

a	1		1	a	1		1
b	2		2	b	2		2
c	3		3	c	3		3
d	0			e	8		4
e	8		5	g	8		5
f	0						6
g	8		7				7
A	B	C	D	E	F
D1=IF(B1=0,"",ROW())
E1=IF(ROW(A1)>COUNT($D:$D),"",INDEX(A:A,SMALL($D:$D,ROW(A1))))

<colgroup><col style="width: 16pt; mso-width-source: userset; mso-width-alt: 739;" width="21"> <col style="width: 18pt; mso-width-source: userset; mso-width-alt: 853;" width="24"> <col style="width: 19pt; mso-width-source: userset; mso-width-alt: 910;" width="26"> <col style="width: 13pt; mso-width-source: userset; mso-width-alt: 625;" span="3" width="18"> <col style="width: 21pt; mso-width-source: userset; mso-width-alt: 995;" width="28"> <col style="width: 11pt; mso-width-source: userset; mso-width-alt: 512;" width="14"> <col style="width: 48pt;" span="4" width="64"> <tbody>
</tbody>

HI guys!!
Hope everyone is well. I am just trying to improve some skills and everyone here has been so kind!! Means a lot!!!
Quick question

If I have a list like this

Apple: 2
Orange: 3
Peach: 0
Banana: 1
Grape: 0
Mango 0
Papaya: 1


What formula can I use to make the list remove the values which are zero... so in the end it will look like

Apple: 2
Orange: 3
Banana: 1
Papaya: 1

Thanks whoever can help me with this rocks

 

[Aladin Akyurek]

HI guys!!
Hope everyone is well. I am just trying to improve some skills and everyone here has been so kind!! Means a lot!!!
Quick question

If I have a list like this

Apple: 2
Orange: 3
Peach: 0
Banana: 1
Grape: 0
Mango 0
Papaya: 1


What formula can I use to make the list remove the values which are zero... so in the end it will look like

Apple: 2
Orange: 3
Banana: 1
Papaya: 1

Thanks whoever can help me with this rocks

C2, control+shift+enter, not just enter, copy across to D2, and copy down:

=IFERROR(INDEX(A$2:A$8,SMALL(IF(ISNUMBER(1/$B$2:$B$8),
  ROW(A$2:A$8)-ROW(A$2)+1),ROWS(C$2:C2))),"")

 

[gorhamsj]

Hi! how are you doing? Thanks a lot for your help!!
I have a few questions from what you did

In column f how did you order everything perfectly? what was your formula there?
Thanks a bunch

 

[gorhamsj]

Awsome! you just made my week

 

[Aladin Akyurek]

Awsome! you just made my week

You are welcome.