Assigning Heading to New Column

[seguin85]

Hi,

I export some date from project that is in the following format. What I want to do is take the priority number of the heading and assign it to a new column

	A	B	C
1	Project	Name	Priority
2	C1	Priority 1
3	C1	Task 7	1
4	C1	Task 9	1
5	C1	Task 12	1
6	C1	Priority 2
7	C1	Task 1	2
8	C1	Task 2	2
9	C1	Priority 3
10	C1	Task 22	3
11	C1	Task 4	3
12	C1	Task 5	3

<tbody>
</tbody>

I am looking for some type of formula to populate column C with the proper priority number.

Thanks!

 

[Fluff]

How about
=IF(LEFT(B2,8)="Priority","",IF(LEFT(B1,8)="Priority",--RIGHT(B1),C1))

 

[seguin85]

That worked perfectly, and so much simpler than what I was trying to figure out.

 

[Fluff]

You're welcome & thanks for the feedback