Re: How do I compare the entry in one cell against all other cells
Tech-Archive recommends: Speed Up your PC by fixing your registry
=if(countif(a:a,a25)>1,a25,"")
Micki wrote:
How do I compare the entry in one cell against all other cells in the same
column, except the cell the entry is in, and make it display the entry in a
different cell if it matches. I almost have it, but I'm getting all
duplicates becuase the entry matches itself.
--
Dave Peterson
.
Relevant Pages
- Re: Performing calculation in active cell based on user input
... entry area spans columns A:F: ... Private Sub Worksheet_Change(ByVal Target As Range) ... numbers to the format I need in another cell. ...
(microsoft.public.excel.programming) - Re: MoveAfterReturn is tricking me.
... The argument Target in the Worksheet_Change event tells you what cell ... > I've got the first column of my worksheet checking to see if the ... > first character of the typed entry is a string or a number. ... > Because of the way that the event trigger seems to work, ...
(microsoft.public.excel.programming) - Re: Capture Screen Position
... before any change was made to the cell - not in the change event. ... You can always bet the visible range with ActiveWindow.VisibleRange ... entry. ...
(microsoft.public.excel.programming) - Re: Capture Screen Position
... "Tom Ogilvy" wrote: ... before any change was made to the cell - not in the change event. ... entry. ...
(microsoft.public.excel.programming) - Re: Looking for matches between columns
... Thanks Bernie. ... In cell H2, ... I have a spreadsheet with 6 columns of data that I would like to compare ... I want an entry made. ...
(microsoft.public.excel) |
|
