highlighting duplicate values in a column

[dslosser]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel For a probability class that I am taking the assignment is to computer simulate birthdays. I have the random numbers in each column for 20 people but now I need to know how to highlight duplicate values (in this case any number between 1 and 365) to determine the probability of 2 or more people sharing the same birthday. I am to complete the simulation for 25, 50, 75, 100, 500 and 1000 randomly selected people. I need to know the steps to highlight the duplicte numbers in each row. My directions are for xcel 2007 and guide me to a: highlight the column of cells (e.g.; A2 to A21) b: click on the Home tab (which I don't see in the 2008 version), c: click on conditional formatting, d: click on highlight cells rules, d: click on duplicate values ... and e: click on OK. Any help would be great, I'm stalled until I can complete the simulation.

 

[CyberTaz]

Your assignment is referring to features available only in the most recent
Windows versions of Excel (2007/2010). Conditional Formatting, itself, is
available from the Format menu in the Mac version but it is comparable to
Windows Excel 2003 & prior versions. You may be able to accomplish the task
but an expression would have to be written using the "Formula Is" option. It
may require a macro, however, and if it does Office 2008 has no VBA.

Perhaps someone more experienced than I can offer a suggestion.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Bob Greenblatt]

Your assignment is referring to features available only in the most recent
Windows versions of Excel (2007/2010). Conditional Formatting, itself, is
available from the Format menu in the Mac version but it is comparable to
Windows Excel 2003& prior versions. You may be able to accomplish the task
but an expression would have to be written using the "Formula Is" option. It
may require a macro, however, and if it does Office 2008 has no VBA.

Perhaps someone more experienced than I can offer a suggestion.

Regards |:>)
Bob Jones
[MVP] Office:Mac

OK, Bob, I'll bite.

Suppose you data is in A1:B10
Then Highlight A1:A10 with A1 as the active cell. Go to
Format-Conditional formatting. Set up for a formula and enter:
=or(a1=$b$1:$b$10)
Then set your condition. Likewise, highlight cells B1:B10 with B1 as
the active cell and enter this formula for the condition:
=or(B1=$a$1:$a$10) and set the condition.

Now any cells duplicated in the range will be highlighted.

 

[John_McGhie_[MVP]]

You sneaky person, you... That one goes in the Little Black Book for future
reference...

Yeah, I AM at the age when the little black book no longer contains girl's
phone numbers... Sad, really...

Cheers

OK, Bob, I'll bite.

Suppose you data is in A1:B10
Then Highlight A1:A10 with A1 as the active cell. Go to
Format-Conditional formatting. Set up for a formula and enter:
=or(a1=$b$1:$b$10)
Then set your condition. Likewise, highlight cells B1:B10 with B1 as
the active cell and enter this formula for the condition:
=or(B1=$a$1:$a$10) and set the condition.

Now any cells duplicated in the range will be highlighted.

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]