Hi there,

 

I'm trying to summarise and count unique values in a field and would appreciate any help to make it a swifter process.  I just can't seem to get my head around it.

 

My list looks like this ...

 

Large Carton

Large Carton

Medium Carton

Medium Carton

Medium Carton

Medium Carton

Medium Carton

Medium Carton

Small Carton

Small Carton

 

And I want it to look like this ...

 

2 Large Carton

6 Medium Carton

2 Small Carton

 

Any suggestions would be massively appreciated.

 

Thanks

J

 

No worries, I found this great CF ...

http://www.briandunning.com/cf/890

You should also have a look at:

http://fmforums.com/forum/topic/91000-grouping-and-summing-a-list/?p=417829

I would do this with a regular report and summary fields.  Would a regular report work for you?  How do you need this information?

 

And what Comment says.

 

and count unique values in a field 

 

Hi Charity,

 

What you suggest is spot-on if those lines were records ... which they should be ... rather than a single field as they are.  Everything becomes simpler when the data is normalised.  Nice suggestion!