Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I am not real sure what type formula to use
I have a spreadsheet set up as so:
Part #1 boss-1 X 125.2 125.2 126.2 Y 130.2 130.2 Z 125.5 125.5 boss-2 X 125.2 125.2 126.2 Y 130.2 130.2 Z 125.5 125.5 Part #2 boss-1 X 125.2 125.2 126.2 Y 130.2 130.2 Z 125.5 125.5 boss-2 X 125.2 125.2 126.2 Y 130.2 130.2 Z 125.5 125.5 Part #3....etc. I am trying to make a table that will tell me for part #1, under the boss-1 section, the number in the 4th column. can this be done? Thanks for the help in advance!! |
#2
|
|||
|
|||
if there are always just 2 bosses and Just X,Y and Z under the bosses
try set a cell for the part Nu Cell(PN) set a cell for the Boss "nu" boss(n) = offset(match(cell(pn),part number range,0),if (boss(n)=1,2,7),3,1,1) If the patterns are symetrical this can be expanded. "frustratedwthis" wrote: I have a spreadsheet set up as so: Part #1 boss-1 X 125.2 125.2 126.2 Y 130.2 130.2 Z 125.5 125.5 boss-2 X 125.2 125.2 126.2 Y 130.2 130.2 Z 125.5 125.5 Part #2 boss-1 X 125.2 125.2 126.2 Y 130.2 130.2 Z 125.5 125.5 boss-2 X 125.2 125.2 126.2 Y 130.2 130.2 Z 125.5 125.5 Part #3....etc. I am trying to make a table that will tell me for part #1, under the boss-1 section, the number in the 4th column. can this be done? Thanks for the help in advance!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Frequency formula | Excel Worksheet Functions | |||
Multiple Condition Sumif Formula | Excel Worksheet Functions | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions |