I attached a sample xls file in which total column have several item in which some amount are repeated i want to give these amount a unique id so in next column is id i put there values manually i want to generate these id automatically. please provide formula for that
thanks
Bookmarks