Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Number values
Hello experts,
i have a huge database of entries from a survey generated from google forms into excel. long story short i have various pivot tables and iferror(vlookup) functions. but i am doing something manually and i wonder if you can help me. i would like to assign a number value from 1-30 for each name, always resetting to 1 at a new name. this database is pertperually growing, so names are not always in the same row day after day. this is what i need a formula for: john smith 1 john smith 2 john smith 3 mike ward 1 mike ward 2 jane doe 1 jane doe 2 jane doe 3 jane doe 4 jane doe 5 Bill Pull 1 etc thanks for your help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number values
Hi,
Am Wed, 11 Nov 2015 16:32:58 +0000 schrieb CP514: i would like to assign a number value from 1-30 for each name, always resetting to 1 at a new name. this database is pertperually growing, so names are not always in the same row day after day. your names in column A. Try in B1: =A1&" "&COUNTIF($A$1:A1,A1) and copy down. Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
#3
|
|||
|
|||
Hi
Assuming the data is in A1:A11. In B1 and copy down: =COUNTIF(A$1:A1,A1) |
#4
|
|||
|
|||
Quote:
Worked perfectly thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a number of rows based on the number of columns filled bytext values | Excel Programming | |||
number values | Excel Discussion (Misc queries) | |||
Values from website turned into useable number values | Excel Worksheet Functions | |||
is number between values | Excel Worksheet Functions | |||
Number of labels on X-axis one more than number of values on Y-axi | Charts and Charting in Excel |