Queennie L
asked on
Add number to New Column if the row starts at AAA with 1 in the Same Filename
Hello Experts,
I have SQL table columns:
UniqueID
Filename
DataName
NewColumn
If the Filename starts with AAA in row then 1, if there are more than AAA in rows with the same filename then starts with 1 then 2 then 3 in NewColumn.
Please see attach file.
Thank you for all your help.
Add-number-to-New-Column-if-the-row.xlsx
I have SQL table columns:
UniqueID
Filename
DataName
NewColumn
If the Filename starts with AAA in row then 1, if there are more than AAA in rows with the same filename then starts with 1 then 2 then 3 in NewColumn.
Please see attach file.
Thank you for all your help.
Add-number-to-New-Column-if-the-row.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@RyanChong:
OMG! It is working.
Thank you and Thank you again and again for your help.
I really appreciate it for you intelligence and expertise.
OMG! It is working.
Thank you and Thank you again and again for your help.
I really appreciate it for you intelligence and expertise.
ASKER
I will test your code. I will let you know.
Thank you again for your help.