Unique List - only if greater than zero

[pauldaddyadams]

Hi,

I was previously helped here with a formula that returns all unique account numbers listed on two sheets "P&L New" and "Bsheet Walk"

It works how it should but I now need to make an amendment...

What I require is the list to only return the unique account number if the number is greater than zero.

e.g. on the FDQM load sheet in cell I2 the user selects the month.

Then if there is a value for an account on the P&L New sheet or Bsheet Walk for this particular month then I would like this number returned.

e.g. in the attached example where April 2015 is selected I would like only the following accounts returned:
600010
600060
110011
110200

Can anyone help please? I can use helper columns

[José Augusto]

Hi
See Aux sheet.
Best regards

[AlKey]

Hi Paul,

Please see attached file with a new formula in column B. This formula will pull unique values only and will ignore cells with zeros or blanks. I think you can now delete those helper columns in columns C & D.

[pauldaddyadams]

Hi Alkey

Sorry for the slow reply. This formula is brilliant. Me seeing this post comes at perfect timing as I am about to rebuild a model and this will help. The reduction of helper columns is great as my model is slow to calculate.