| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Definitelly, nice to have met a fellow Excel fanatic!
Regards, Dave -- David Billigmeier "Manish Bajpai" wrote: David, You are simply great !! Nice to brainstorm with you. Thanks, Manish "David Billigmeier" wrote: Sorry... I see a typo, paste that code in B1 :-) -- David Billigmeier "David Billigmeier" wrote: Without using pivot tables: Assume your values are in the range A1:A10, paste this code in A1 and drag down: =IF(COUNTIF($A$1:$A$10,A1)1,"dup","nodup") -- David Billigmeier "Krista" wrote: I need to check for duplicate names in a column. Is there a way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running total w/2 columns - Excel | Excel Worksheet Functions | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| how do i insert words into a column without erasing the words | Excel Discussion (Misc queries) | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| looking to assign different numbers in column B to different words in column A | Excel Worksheet Functions | |||
Threaded Mode
