LinkBack URL
About LinkBacks
I have a 50 x 50 spreadsheet of integers. I need to find instances of integers within this dataset that appear more than once, and more than twice. How can I do this?
I have a 50 x 50 spreadsheet of integers. I need to find instances of integers within this dataset that appear more than once, and more than twice. How can I do this?
Use Conditional Formatting, with this formula:
=COUNTIF($A$1:$AX$50,A1)>2
and
COUNTIF($A$1:$AX$50,A1)>1
with different coloured fills FOR EACH FORMULA. Like here (20x20 square formatted in the attached file)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks - it works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks