Function in excel

Hi Jacek


Thank you for your question regarding the counting of unique objects in a list.

The best way to achieve this is to:

- Firstly make sure the range has a column header

- On the Data menu, point to Filter & then select Advanced filter

- In the Advanced filter dialogue box click 'Copy to another location'

- In the List Range box, delete anything that may already be in there & then select the your data range (including the column header) so your data range cell ref is now in the List Range box.

- In the Copy To box, delete anything that may be in there and then select a cell from where you would like the unique values to appear

- Tick the Unique Records Only checkbox - OK

- Now just count the rows that have appeared using the function ROWS

e.g if the unique objects appear in cell range B2:B10, the formula would look like =ROWS (B2:B10)


I hope this resolves your question. If it has, please mark this question as resolved.


If you require further assistance, please reply to this post.


Regards,


Nafeesa

Microsoft Office Specialist Trainer