by MYLE
21. June 2010 16:38
Had some ask me how can I find the Dups in a list of number items in a list with out sorting them. mmmmmmmmmmmm
thinking ................
so this is what I told him why not count the number of items in a list
the formala would be =Countif([range],[cell_to_check])
you must put the $ in the [range]
ie =countif($A$4:$A$1000,A4) it will put a 1 in the formula cell and if more than 1 put the count of it.
47d21f9a-7f42-4d68-993d-ad824875ce70|0|.0
Category: Execl
Tags: Excel