Home » Blogs » RReyes's blog

Answer - Get Data of Bottom 5 Customer But Greater Than 0

Submitted by RReyes on 13 April, 2013 - 13:43

Hi 0713910067,

A control answer to your question, please find attach the macro that should achieve VBA "macro" you were looking for.

Hope it helps,

Raymond

AttachmentSize
Bottom Issue (RReyes).xls63 KB
»

Get data of bottom 5 customer but >0

Submitted by 0713910067 on 16 April, 2013 - 16:43.

Hi RReyes,

Thanks for your help.
But i need to do it in pivot table.

So, can you please tell me how to do it in pivot table.
As we have value filter of "bottom", when i put then it considers 0 value also , but i want to get names who are bottom but >0.

Thanks

»
Nick's picture

linking the

Submitted by Nick on 15 April, 2013 - 13:39.

linking the question:
http://excelexperts.com/get-data-bottom-5-customer-greater-0

»