count values in a column, but only if the value does not appear in the previous cells

**rach4444** · 02-22-2008, 06:30 AM

Hi,

Im trying to count values in a column, but only if the value does not appear in the previous cells in the row

eg... Count the YES's

acc Y Y N Y
Pro N Y Y N
tim N N N Y
rac Y N N Y

Existing 0 1 1 2
New 2 1 0 1

Please can you help?

**mrice** · 02-24-2008, 03:22 PM

Try this user defined function

Please Login or Register  to view this content.

Use the formula

=CountSpecial(B1:B4,"Y")

in B5 etc.

**amannan** · 02-27-2008, 06:04 AM

I am also trying the same but little different i want data to be appeared in a column, but only if the data does not appear in the previous cells or in the row.

The data should appear based on the given From & To date and based on status like closed open or etc..

Your help to the above will be much appreciated.

Thanks,

Abdul Mannan

**rach4444** · 02-27-2008, 09:11 AM

Thanks for the info mrice, but I have tried to get this into the spreadsheet and cannot get it to work.

I've added it to VB Editor and all seems to look ok, but cannot work out how to use it in the spreadsheet.

**mrice** · 02-27-2008, 01:20 PM

Please see the attached file.

**rach4444** · 02-28-2008, 04:15 AM

My stupid machine wont allow me to view .zip files. I have a dumn terminal. They dont trust me with a PC of my own.

Any chance of attaching the doc unzipped.

Thanks
Rachel