|
|
#1
06-17-2024, 10:14 AM
|
|||
|
|||
Finding Duplicated Number in Column B to A
Hi there, I have been trying to figure this out and just can't seem to find a resolution..
I have a column A and B with a list of job numbers. What I want to do is create a formula where it will allow me to point out job numbers in column B that has already been duplicated in column A. Any way to go on about this? Any help would be much appreciated! 
|
|
#2
06-17-2024, 11:07 AM
|
||||
|
||||
|
For your data picture ranges, select as shown, then conditional formatting as follows:
2024-06-17_190356.jpg Extend the ranges for your whole data.
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Two column newsletter and first page duplicated | tapyeno | Word | 2 | 07-19-2019 05:33 AM |
| Excel Formula for Finding the Last "S" number used | Aklouzek | Excel | 3 | 01-05-2019 01:45 AM |
 Finding product number
|
mjh35 | Office | 3 | 05-17-2015 02:20 AM |
|
Finding a value in one column and in another
|
itmaster | Excel | 2 | 12-12-2014 10:13 AM |
| Want a quotient using a constant to show up in column c each time a number is added to column b | fibbermcghee | Excel | 2 | 12-09-2014 05:48 PM |
Windows 11 
Office 2019
Linear Mode
