Hi

I am wondering if it is possible through formula / SQL to have a field which states whether or not a record is unique from the current line down to the end of the range. I need to do this based on a check against one field and based on two fields as well.

I am sure this makes no sense so I will show an example of the excel formulae I currently use to calculate this:

Single field check against column A over a 10,000 line record set.

=IF(COUNTIF(A2:$A$10000,A2)=1,1,0)

Two (or more) field check against column A & B over a 10,000 line record set.

=IF(COUNTIFS(A2:$A$10000,A2,M2:$M$10000,M2)=1,1,0)

When I drag this down against the record set it returns a 1 or 0 as appropriate.

Thanks for the help.


Edited by pentesh - 03 Nov 2011 at 2:27am