Tag data as "Parent", "Child 1", "Child 2"

[iamrohin]

I have a set of data in a column laid out in the format shown below.
I want to tab "ABC" as parent in next column, "DEF" as child 1, "GHI" as child 2 and so on and so forth.

Can someone help me to write a formula that would do this for be in the next column

 

[dreid1011]

What are the conditions to mark an entry "Parent", "Child 1/2", etc? I mean, I can look at it and make the decision, but that is easier said than writing the formula for it. Would the third entry of "DEF" also be "Parent"?

 

[Scott Huish]

Assuming this is how you're grouping them:

ABC

DEF

GHI

JKL

MNO

PQR

STU

VWX

YZ

=IF(A1="","",IF(LEFT(A1)="A","Parent","Child " & INT((CODE(LEFT(A1))-64)/3)))

Book3
	A	B
1	ABC	Parent
2	DEF	Child 1
3	GHI	Child 2
4	JKL	Child 3
5	MNO	Child 4
6	PQR	Child 5
7	STU	Child 6
8	VWX	Child 7
9	YZ	Child 8
Sheet1

Cell Formulas
Range	Formula
B1:B9	B1	=IF(A1="","",IF(LEFT(A1)="A","Parent","Child " & INT((CODE(LEFT(A1))-64)/3)))

 

[iamrohin]

What are the conditions to mark an entry "Parent", "Child 1/2", etc? I mean, I can look at it and make the decision, but that is easier said than writing the formula for it. Would the third entry of "DEF" also be "Parent"?

No DEF will be child 1 and anything under DEF will be child 2 (in this case GHI)

 

[iamrohin]

Assuming this is how you're grouping them:

ABC

DEF

GHI

JKL

MNO

PQR

STU

VWX

YZ

=IF(A1="","",IF(LEFT(A1)="A","Parent","Child " & INT((CODE(LEFT(A1))-64)/3)))

Book3
	A	B
1	ABC	Parent
2	DEF	Child 1
3	GHI	Child 2
4	JKL	Child 3
5	MNO	Child 4
6	PQR	Child 5
7	STU	Child 6
8	VWX	Child 7
9	YZ	Child 8
Sheet1

Cell Formulas
Range	Formula
B1:B9	B1	=IF(A1="","",IF(LEFT(A1)="A","Parent","Child " & INT((CODE(LEFT(A1))-64)/3)))

I tried this but it won't work as it is not necessary that the first parent will start from "A"

 

[Scott Huish]

That is what you explained. How are you entering them and what are the conditions for determining it?