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
Bookmarks