Originally Posted by
WhatF
Hi,
I have a sheet with a column of ID Numbers (Column C)
I need a formula in the next column (Column D) to inform me if the new ID Number which I'm entering now is already existing somewhere in column C.
example:
Column C -----Column D
ID Number
105235 --------the needed formula
125435 --------the needed formula
145298 --------the needed formula
548694 --------the needed formula
125435 --------the needed formula should tell me that this ID exists
In the example, I entered the new ID number 125435 after the last ID number in column C, the formula in column D (in the same row as the newely eneterd ID)should inform me that it exists in row 3 as shown
How can I do that?
Thank you
Bookmarks