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.