awk - getting uniq count on multiple col

view story

http://www.unix.com – Hi My file have 7 column, FIle is pipe delimed Code: Col1|Col2|col3|Col4|col5|Col6|Col7 I want to find out uniq record count on col3, col4 and col2 ( same order) how can I achieve it. ex Code: 1|3|A|V|C|1|1 1|3|A|V|C|1|1 1|4|A|V|C|1|1 Output should be Code: FREQ|A|V|3|2 FREQ|A|V|4|1 Here last column is count. Moderator's Comments: Please use code tags next time for your code and data. (HowTos)