Link to home
Start Free TrialLog in
Avatar of Quenn L
Quenn 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
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Quenn L
Quenn L

ASKER

@Ryan Chong,

I will test your code. I will let you know.

Thank you again for your help.
Avatar of Quenn L

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.