LinkBack URL
About LinkBacks
I'd like to populate cells based on a WBS value. For example, if a cell contains 1.1.1.1, I'd like to have it populate a cell in the column titled "Level 4"
Is there a way to return the value of a cell based on the number of periods it contains?
I'd like to populate cells based on a WBS value. For example, if a cell contains 1.1.1.1, I'd like to have it populate a cell in the column titled "Level 4"
Is there a way to return the value of a cell based on the number of periods it contains?
I'd go the other way (calculate WBS from level), but to answer your question,
=len(a1) - len(substitute(a1, ".", "")) + 1
Entia non sunt multiplicanda sine necessitate
I agree that I would like to go the other way, but that's not how I am given data unfortunately.
I've attached a sample spreadsheet - I did not capture my problem correctly the first time I believe.
I would like to have the part number listed in Column B returned in the appropriate level column (C through G) dependent on the Part Level Identifier (PLI).
As an example, I would like to have part number 5 (B6) be populated in cell G6 with a formula. My true data set is something like 500 parts long, so doing this by hand would be quite tedious.
For some reason I cannot upload attachments, so the image attached may helpCapture.PNG
1 a c2: =if(len($a2) - len(substitute($a2, ".", "")) + 1 = c$1, $b2, "") 1.1 b 1.1.1 c 1.1.2 d 1.2 e 1.3 f 1.3.1 g
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks