ClioSport.net
Register a free account today to become a member!
Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!
-
When you purchase through links on our site, we may earn an affiliate commission. Read more here.
MS Excel Help
- Thread starter Munday
- Start date
Wouldn't it be great if Microsoft provided help for Office.. 
http://office.microsoft.com/en-us/excel/HA010346261033.aspx
http://office.microsoft.com/en-us/excel/HA010346261033.aspx
Black-Gold 182
in the cells next to the list use the countif formula
ie, if you have a range of cells 4 rows, high, the forumla would be;
=countif($A$1:$a$4,a1)
You need to make sure that the first part is a non dynamic link (with the $ signs)- using F4. Then drag the formula down, and if you have anything showing more than one, then its a duplicate!
MB_182
(Resident CS Excel Guru)
ie, if you have a range of cells 4 rows, high, the forumla would be;
=countif($A$1:$a$4,a1)
You need to make sure that the first part is a non dynamic link (with the $ signs)- using F4. Then drag the formula down, and if you have anything showing more than one, then its a duplicate!
MB_182
(Resident CS Excel Guru)
