Hi I want to create a spreadsheet where random people can input random names (not case sensitive) into a field, then that name will be input into the spreadsheet, if exists then it increments a count for that name and if not inputs the new name to a new line in a specific column. Is this possible in excel or do i need a database of some kind?
Could anyone send me some examples of formula if it is possible?
thanks