Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I compare cells in a column
I am inputing a large column of names and numbers and would like to insure I
don't repeat any. I'm not sure how the Vlookup works I continually receive errors and the If command only works with 2 cells. Thank you in advance for any help!! |
#2
|
|||
|
|||
One way ..
Suppose the list to be entered is in col F Select col F Click Data Validation Make the settings: Choose under "Allow:" : Custom Source: =COUNTIF($F$1:F1,F1)<=1 Click OK -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Jim K" <Jim wrote in message ... I am inputing a large column of names and numbers and would like to insure I don't repeat any. I'm not sure how the Vlookup works I continually receive errors and the If command only works with 2 cells. Thank you in advance for any help!! |
#3
|
|||
|
|||
Source: =COUNTIF($F$1:F1,F1)<=1
Minor typo: "Source: " should read: "Formula:" -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I take 3 cells and move them to a different column into 1 | Excel Discussion (Misc queries) | |||
calculate which cells in column A will give me the total of column | Excel Worksheet Functions | |||
How do I compare data in two different spreadsheets i.e. (column . | Excel Discussion (Misc queries) | |||
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
How do I ROUNDUP a Column of cells on a worksheet template? | Excel Worksheet Functions |