Using SUMPRODUCT in addition to another formula to return the contents of a particular column

[suprsnipes]

Hi,

I have the following sum product formula in A1

=SUMPRODUCT(--(erdedited!$A$3:$A$201<>""),--(erdedited!$A$3:$A$201<>"Company"))

What I want to do in column B is show the contents of column A2 to A200 with no row spaces in between. How would I do that?

 

[Erick]

Hi,

I have the following sum product formula in A1

=SUMPRODUCT(--(erdedited!$A$3:$A$201<>""),--(erdedited!$A$3:$A$201<>"Company"))

What I want to do in column B is show the contents of column A2 to A200 with no row spaces in between. How would I do that?

So what do you want to do if the row in A is Null? move the record up?

 

[suprsnipes]

Thanks for your reply, yes I want to move the record up

 

[Erick]

You can achieve this quite easily in Access but I'm not sure this is doable in Excel