Coachmannyz8
New Member
- Joined
- Feb 28, 2018
- Messages
- 9
Good morning Forum ,
Here is my formula:
In 'Sheet 1' (cell J3)
=IFERROR(INDEX('Raw Data'!$B$3:$B$900,SMALL(IF(1=((--($D$6='Raw Data'!$A$3:$A$900))*(--($E$6='Raw Data'!$D$3:$D$900))),ROW('Raw Data'!$B$3:$B$900)-0,""),COLUMN()-1)),"")
my two criteria's are - "Position Title" & "Resource Number"
RAW Data (Sheet 2)
ROW B ROW C ROW D and so on
[TABLE="width: 498"]
<tbody>[TR]
[TD="class: xl66"]Project
[/TD]
[TD="class: xl67, width: 62, bgcolor: silver"]Cost Category
[/TD]
[TD="class: xl66, width: 70, bgcolor: silver"]Resource Number
[/TD]
[TD="class: xl66, width: 88, bgcolor: silver"]Project Line Number
[/TD]
[TD="class: xl68, width: 132, bgcolor: silver"]`
[/TD]
[TD="class: xl66, width: 250, bgcolor: silver"]Position Title 1
[/TD]
[/TR]
</tbody>[/TABLE]
1 ID_389 Utilities
2 ID_389 Utilities
3 ID_389 Utilities
4 ID_389 Utilities
With the formula above, I'm trying to bring the data to cell 'J3' on Sheet 1 with the "Project" numbers "1,2,3,4".
Currently no data is present in cell J3; not sure if the -1 or -0 in the formula are the cause of the problem, but I changed the numbering system and no data seems to ever populate.
thank you for the assistance
Here is my formula:
In 'Sheet 1' (cell J3)
=IFERROR(INDEX('Raw Data'!$B$3:$B$900,SMALL(IF(1=((--($D$6='Raw Data'!$A$3:$A$900))*(--($E$6='Raw Data'!$D$3:$D$900))),ROW('Raw Data'!$B$3:$B$900)-0,""),COLUMN()-1)),"")
my two criteria's are - "Position Title" & "Resource Number"
RAW Data (Sheet 2)
ROW B ROW C ROW D and so on
[TABLE="width: 498"]
<tbody>[TR]
[TD="class: xl66"]Project
[/TD]
[TD="class: xl67, width: 62, bgcolor: silver"]Cost Category
[/TD]
[TD="class: xl66, width: 70, bgcolor: silver"]Resource Number
[/TD]
[TD="class: xl66, width: 88, bgcolor: silver"]Project Line Number
[/TD]
[TD="class: xl68, width: 132, bgcolor: silver"]`
[/TD]
[TD="class: xl66, width: 250, bgcolor: silver"]Position Title 1
[/TD]
[/TR]
</tbody>[/TABLE]
1 ID_389 Utilities
2 ID_389 Utilities
3 ID_389 Utilities
4 ID_389 Utilities
With the formula above, I'm trying to bring the data to cell 'J3' on Sheet 1 with the "Project" numbers "1,2,3,4".
Currently no data is present in cell J3; not sure if the -1 or -0 in the formula are the cause of the problem, but I changed the numbering system and no data seems to ever populate.
thank you for the assistance