Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
To simply flag the 2nd one, use conditional formatting: select the cells in
column B, with B2 active, Format/Conditional Formatting, Formula Is, and type =B1; then set your formatting. On 06 Oct 2004 19:25:39 GMT, (Lizmerrill) wrote: How can I use excel to find consecutive duplicate entries in a column? e.g, Col B 1614 1522 1522 duplicate consecutive entry how can I use excel to flag this for me? Thanks, Liz Merrill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Solve for X and Y | Excel Worksheet Functions | |||
Need help to solve err#429 | Excel Discussion (Misc queries) | |||
if A1<0 let B2 =A1 and if A1=0 let B3=A1 solve PLEASE!!!!!!!!!! | Excel Worksheet Functions | |||
y i cannot solve it ? | Excel Worksheet Functions | |||
How do I solve this? | Excel Programming |