Without repeating numbers

**thair** · 05-20-2012, 02:19 PM

Hi
The formula her changed when I clear the value from column
I want it not changed when I clear any value
is that possible
thanks
attached below

**Russell Dawson** · 05-20-2012, 02:41 PM

Hi

I hope I understand correctly.

Try this entered as array formula

Please Login or Register  to view this content.

Use Ctrl-Shift-Enter instead of enter

**thair** · 05-20-2012, 02:51 PM

Hi
this array formula working , but i wondering if i get not array formula please
thanks

**thair** · 05-20-2012, 02:55 PM

Hi
this array formula working , but i wondering if i get not array formula please
thanks

**Haseeb Avarakkan** · 05-20-2012, 02:57 PM

Hi Thair,

=SUMPRODUCT((names<>"")/COUNTIF(names,names&""))

**Russell Dawson** · 05-20-2012, 03:00 PM

Hi

Select cell B15 but then paste the formula into formula bar and then Ctrl-Shift-Enter

**thair** · 05-20-2012, 03:12 PM

Please Login or Register  to view this content.

Thanks Haseeb it's working well
That's what i wanted
thank you

Hi Russell Dawson
your array formula both working
Thanks

Re: Without repeating numbers