SORT(UNIQUE) function

[thewiseguy]

Hello all,

I am currently using the following formula/function:

=SORT(UNIQUE(FILTER(Proposal_Input!AA3:AA2002,(Proposal_Input!AA3:AA2002 <>"")*(Proposal_Input!AD3:AD2002<>0),FALSE)))

This is giving me the correct output with the exception of the first value it returns. I have noticed this in other areas of my worksheet but those first line items were left blank or with a "0" so it didn't hurt me.

Any ideas why this is doing this?

Any help is greatly appreciated!

 

[awoohaw]

Have you "cleared" that cell (AD3)?
Im getting a zero for that row, regarding the filtering criteria:

mr excel questions 29.xlsm
	AA	AB	AC	AD
1	AA	AB	AC	AD
2	MAXLITE 27W LED 2x4 Back-Lit Flat Panel MCCT	MLFP24G427WCSCR	2	2
3	ENVISIONLED Straight Arm Mount for ARL3 Area light, White	ARL3-SA-WH	2
4	YOUR FILTER CRITERIA:
5	=(--(AA2:AA3<>""))*(--(AD2:AD3<>0))			1
6				0
thewiswguy

Cell Formulas
Range	Formula
AA5	AA5	=FORMULATEXT(AD5)
AD5:AD6	AD5	=(--(AA2:AA3<>""))*(--(AD2:AD3<>0))
Dynamic array formulas.

 

[Fluff]

Try

=SORT(UNIQUE(FILTER(Proposal_Input!AA3:AA2002,(Proposal_Input!AA3:AA2002 <>"")*(Proposal_Input!AD3:AD2002<>""),FALSE)))

 

[thewiseguy]

not sure what happened but when i "deleted" AD and then tried again, it worked. Was something hidden in the cell?

 

[Fluff]

Was something hidden in the cell?

Very possibly.