Suppressing Duplicates #2

mason1234 · Feb 20th, 2002, 01:12 PM

Yesterday I got some great advice about using conditional formatting (formula is =A2=A1) and font white to conceal duplicates that appear in a column (so a school name wouldn't be repeated until a cell with a new name).
That worked great for "school" and "course ID" because those are unique. But the column to the right of course ID is "Units." Is there a similar formula I can use so that it won't repeat "3" in that column until a new entry appears in the "course ID" column? So that it will display 3, then not display 3 again until a new course ID appears in the column to the left? Thanks again.
--Merle Mason

Steve Hartman · Feb 20th, 2002, 02:19 PM

Sure! Assuming the Course ID is in column C and the Units are in column D, the procedure is the same as your last question but instead of the formula =A2=A1 use =C2=C1 in the second cell of your data incolumn D.

[ This Message was edited by: Steve Hartman on 2002-02-20 13:20 ]

[ This Message was edited by: Steve Hartman on 2002-02-20 13:32 ]

mason1234 · Feb 20th, 2002, 03:11 PM

Steve,

Works like a charm! Thank You!

Merle Mason

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 20th, 2002, 01:12 PM	#1
mason1234 New Member Join Date: Feb 2002 Posts: 9	Yesterday I got some great advice about using conditional formatting (formula is =A2=A1) and font white to conceal duplicates that appear in a column (so a school name wouldn't be repeated until a cell with a new name). That worked great for "school" and "course ID" because those are unique. But the column to the right of course ID is "Units." Is there a similar formula I can use so that it won't repeat "3" in that column until a new entry appears in the "course ID" column? So that it will display 3, then not display 3 again until a new course ID appears in the column to the left? Thanks again. --Merle Mason

Feb 20th, 2002, 02:19 PM	#2
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Sure! Assuming the Course ID is in column C and the Units are in column D, the procedure is the same as your last question but instead of the formula =A2=A1 use =C2=C1 in the second cell of your data incolumn D. [ This Message was edited by: Steve Hartman on 2002-02-20 13:20 ] [ This Message was edited by: Steve Hartman on 2002-02-20 13:32 ]

Feb 20th, 2002, 03:11 PM	#3
mason1234 New Member Join Date: Feb 2002 Posts: 9	Steve, Works like a charm! Thank You! Merle Mason