duplicate entries

[stepzilla]

Hello,

I have numbers in column R3:R100 and other numbers in column X3:X100. What I'd like to do is highlight the number red in column R if it is in column X.


I'd also like to be able to delete the duplicated number if the number in column T3:T100 is in column A3:A100

Thanks

 

[jim may]

Part one...

Cell A2 and A4 should return "in red" as they are found in C1:C5

Excel 2012
	A	B	C	D	E
1	268		348		I highlighted (Selected) A1:A5, went to Conditional Formatting, selected Use Formula and in Box
2	172		327		entered =Countif($A$1:$A$5,$A1) -- then Format on the Font Tab, Select Color, OK, OK
3	271		307
4	327		172
5	181		428
6
7	Substitutute		Substitutute
8	Your R Ref		Your X Ref
9	above		above
Sheet1

 

[stepzilla]

22-Nov

23-Nov

24-Nov

25-Nov

26-Nov

27-Nov

28-Nov

C

22-Nov

23-Nov

24-Nov

25-Nov

26-Nov

27-Nov

28-Nov

SAT

SUN

MON

TUE

WED

THU

FRI

C

SAT OPEN

SUN OFF

MON OPEN

TUE OPEN

WED OPEN

THU OPEN

FRI OPEN

NSD

230

HOL

209

AL

NSD

NSD

HOL

210

210

210

NSD

HOL

245

211

NSD

NSD

HOL

217

217

230

NSD

HOL

219

NSD

NSD

HOL

220

220

AL

NSD

NSD

AL

HOL

230

230

230

230

NSD

AL

NSD

HOL

244

244

244

245

NSD

NSD

245

245

230

230

HOL

246

AL

NSD

AL

NSD

HOL

251

251

251

251

391

NSD

HOL

363

361

NSD

HOL

365

NSD

NSD

HOL

369

NSD

NSD

HOL

372

SAT ONLY

361

SAT ONLY

389

SAT ONLY

390T

NSD

NSD

HOL

374

374

NSD

NSD

HOL

380

380

380

NSD

NSD

HOL

384

384

NSD

NSD

HOL

387

NSD

NSD

HOL

391

391

NSD

101T

500

101T

HL

NSD

NSD

HL

HL

HOL

HL

102T

102T

102T

102T

102T

102T

NSD

NSD

2330

104T

107T

NSD

500

107T

NSD

113T

500

113T

HOL

NSD

NSD

121T

121T

121T

NSD

NSD

2215

126T

NSD

102T

HOL

141T

141T

150T

150T

2330

150T

150T

102T

NSD

AL

AL

HOL

203T

203T

203T

203T

249T

NSD

HOL

205T

205T

HL

NSD

NSD

HL

H

HOL

HL

206T

206T

206T

206T

206T

206T

251

NSD

AL

AL

HOL

212T

212T

212T

206T

NSD

HOL

214T

214T

NSD

NSD

HOL

215T

215T

215T

102T

121T

500

216T

216T

NSD

218T

HOL

NSD

218T

218T

218T

218T

NSD

NSD

HOL

222T

222T

HOL

NSD

NSD

223T

223T

223T

AL

AL

NSD

NSD

HOL

224T

224T

224T

224T

224T

NSD

231T

HOL

230

231T

231T

231T

NSD

NSD

HOL

243T

243T

NSD

212T

500

247T

248T

NSD

104T

248T

248T

248T

AL

NSD

NSD

AL

HOL

249T

249T

249T

249T

364T

1200

NSD

364T

364T

366T

1500

NSD

366T

366T

390T

NSD

HOL

367T

NSD

NSD

HOL

368T

NSD

NSD

HOL

370T

370T

NSD

NSD

HOL

371T

NSD

NSD

HOL

381T

NSD

NSD

NSD

NSD

NSD

NSD

NSD

382T

382T

382T

382T

382T

382T

NSD

NSD

HOL

NSD

385T

385T

385T

NSD

382T

HOL

388T

388T

389

NSD

HOL

392T

NSD

NSD

1200

382T

NSD

HOL

395T

396T

1200

NSD

396T

396T

374

NSD

HOL

397T

<colgroup><col width="57" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;"> <col width="43" style="width: 32pt; mso-width-source: userset; mso-width-alt: 1572;" span="7"> <col width="57" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;"> <col width="53" style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;"> <col width="63" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2304;"> <col width="57" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;"> <col width="63" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2304;"> <col width="60" style="width: 45pt; mso-width-source: userset; mso-width-alt: 2194;"> <col width="55" style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;"> <tbody> </tbody>

Thanks …. But I think I didn't ask quite right.
have a look at the spreadsheet above. What I want to do is:
If the numbers in column I are in column A, I want the numbers
in column I to be highlighted red.
I'm going to continue the same formula for columns B and J,
L, etc.

<colgroup><col width="64" style="width: 48pt;" span="7"> <tbody> </tbody>

 

[jim may]

The formula I provided earlier should have been,,, Sorry

=COUNTIF($C$1:$C$5,$A1)