Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Repeat Values in rows
I need to search my worksheet (128 X 128) rows for any repeated values,
anyone help? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Repeat Values in rows
It doesn't sound like a charrting question, but in your worksheet (having
selected your 128*128 range & with cell A1 active), use Format/ Conditional Formatting/ Formula Is: =COUNTIF($A$1:$DX$128,A1)<1 and select a format to mark your duplicates. -- David Biddulph "Governor" wrote in message ... I need to search my worksheet (128 X 128) rows for any repeated values, anyone help? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Repeat Values in rows
Thanks David, but what I need is to select row 1 for instance accross all 128
columns and to find if any of the cells contain the same data. "David Biddulph" wrote: It doesn't sound like a charrting question, but in your worksheet (having selected your 128*128 range & with cell A1 active), use Format/ Conditional Formatting/ Formula Is: =COUNTIF($A$1:$DX$128,A1)<1 and select a format to mark your duplicates. -- David Biddulph "Governor" wrote in message ... I need to search my worksheet (128 X 128) rows for any repeated values, anyone help? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Repeat Values in rows
In which case just change the 128 to 1:
=COUNTIF($A$1:$DX$1,A1)<1 -- David Biddulph "Governor" wrote in message ... Thanks David, but what I need is to select row 1 for instance accross all 128 columns and to find if any of the cells contain the same data. "David Biddulph" wrote: It doesn't sound like a charrting question, but in your worksheet (having selected your 128*128 range & with cell A1 active), use Format/ Conditional Formatting/ Formula Is: =COUNTIF($A$1:$DX$128,A1)<1 and select a format to mark your duplicates. -- David Biddulph "Governor" wrote in message ... I need to search my worksheet (128 X 128) rows for any repeated values, anyone help? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Repeat Values in rows
But if you're wanting to do the same for each row in turn you'll need to
make the row reference relative, not absolute: =COUNTIF($A1:$DX1,A1)<1 -- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... In which case just change the 128 to 1: =COUNTIF($A$1:$DX$1,A1)<1 "Governor" wrote in message ... Thanks David, but what I need is to select row 1 for instance accross all 128 columns and to find if any of the cells contain the same data. "David Biddulph" wrote: It doesn't sound like a charrting question, but in your worksheet (having selected your 128*128 range & with cell A1 active), use Format/ Conditional Formatting/ Formula Is: =COUNTIF($A$1:$DX$128,A1)<1 and select a format to mark your duplicates. -- David Biddulph "Governor" wrote in message ... I need to search my worksheet (128 X 128) rows for any repeated values, anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
printing issue - want to repeat two rows and also 5 rows in column | Excel Discussion (Misc queries) | |||
Rows to Repeat at Top | Excel Discussion (Misc queries) | |||
how to repeat rows at the bottom while using the rows repeat at to | Setting up and Configuration of Excel | |||
Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
Unable to select rows in the repeat rows on top option | Excel Discussion (Misc queries) |