Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can i keep from repeating a name in an excel cell?
I work for a non-profit org and we are trying a new way of keeping up with
monies distributed. I just have basic knowledge of the excel program and i only have one question that may sound silly but is very important to us. We are listing the clients name in cell A and then the amount of money they recieve and to whom (the utility company) in the rows b-f. Every evening i add the clients names to the spreadsheet and sort them in alphabetical order. What i need to know is there anyway to flag a name if it has been listed twice? For example, last year we did this same method and didn't sort them alphabetically. When it was time to send the reports to FEMA, there was one person who double-dipped and received benefits twice. SO, we are trying to prevent this from happening again. Is there some way of customizing options or anything to detect if the name has been typed before? Maybe like how the Word program offers the shortcut drop-down box when something has been typed before. Sorry for being confusing but i don't really know how to ask this in any other manner. Thank you so much if you can possibly help me. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can i keep from repeating a name in an excel cell?
Locating, removing, and preventing duplicates are covered in:
http://www.cpearson.com/excel/topic.aspx -- Gary''s Student - gsnu200837 "bobbijo81" wrote: I work for a non-profit org and we are trying a new way of keeping up with monies distributed. I just have basic knowledge of the excel program and i only have one question that may sound silly but is very important to us. We are listing the clients name in cell A and then the amount of money they recieve and to whom (the utility company) in the rows b-f. Every evening i add the clients names to the spreadsheet and sort them in alphabetical order. What i need to know is there anyway to flag a name if it has been listed twice? For example, last year we did this same method and didn't sort them alphabetically. When it was time to send the reports to FEMA, there was one person who double-dipped and received benefits twice. SO, we are trying to prevent this from happening again. Is there some way of customizing options or anything to detect if the name has been typed before? Maybe like how the Word program offers the shortcut drop-down box when something has been typed before. Sorry for being confusing but i don't really know how to ask this in any other manner. Thank you so much if you can possibly help me. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can i keep from repeating a name in an excel cell?
One way is to use conditional formating in the column, then when you type in
a duplicate the cell will be coloured. Highlight the column, eg column A Format, conditional formatting format is put in =countif(A:A,A1)1 Click on the format button, then use the pattern to choose a cell shading colour. Hope this helps, Barbara "bobbijo81" wrote in message ... I work for a non-profit org and we are trying a new way of keeping up with monies distributed. I just have basic knowledge of the excel program and i only have one question that may sound silly but is very important to us. We are listing the clients name in cell A and then the amount of money they recieve and to whom (the utility company) in the rows b-f. Every evening i add the clients names to the spreadsheet and sort them in alphabetical order. What i need to know is there anyway to flag a name if it has been listed twice? For example, last year we did this same method and didn't sort them alphabetically. When it was time to send the reports to FEMA, there was one person who double-dipped and received benefits twice. SO, we are trying to prevent this from happening again. Is there some way of customizing options or anything to detect if the name has been typed before? Maybe like how the Word program offers the shortcut drop-down box when something has been typed before. Sorry for being confusing but i don't really know how to ask this in any other manner. Thank you so much if you can possibly help me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data in cell repeating | Excel Discussion (Misc queries) | |||
Repeating numbers in same cell | Excel Worksheet Functions | |||
How do I set repeating text for a specific cell. | Excel Worksheet Functions | |||
Repeating a Cell | Excel Worksheet Functions | |||
Repeating same task for different cell | New Users to Excel |