I have been watching tutorials on youtube for two days now, and I have yet to run across what I need.
Here is the layout
Sheet 1 is laid out
A column "albums" B column "song" C column "artist" D column "tier".
"Tier" is a ranking, by song, to categorize use and potential productivity of said song.
Sheets 2 through 4 are then corresponding to the rank. Sheet 2 is tier 1, sheet 3 is tier 2, 4 is tier 3.
What I need is set sheets 2-4 up so that every time a "1" shows up in the "tier" column of sheet 1, it transfers the data from the other columns to the corresponding columns in sheet 2. So line 1 on sheet 2 would contain the first time a 1 showed up in the "tier" column and so on.
Then in sheet 3 would appear on the 1st line the 1st time the number 2 showed up in the "tier" column of sheet 1. In the 2nd line would be the 2nd time. Likewise would be in sheet 4 for every time 3 showed up in the "tier" column.
In essence if it was a phonebook, I am looking to pull all the times smith shows up in sheet 1 and place his info on sheet 2, and every time Jones showed up it goes in sheet 3.
It has been a long time since programming Excel and it was on Office 98'. Things have changed so much that I am just lost. And I can't remember what I used to know on 98'. Please I need help. I am falling behind schedule because of this one formula. I cannot continue with my other formulas without the data transferring to these sheets. And I unfortunately do not have the time to read through all the posts to see if it is already here.
Thanks all
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
Here is the layout
Sheet 1 is laid out
A column "albums" B column "song" C column "artist" D column "tier".
"Tier" is a ranking, by song, to categorize use and potential productivity of said song.
Sheets 2 through 4 are then corresponding to the rank. Sheet 2 is tier 1, sheet 3 is tier 2, 4 is tier 3.
What I need is set sheets 2-4 up so that every time a "1" shows up in the "tier" column of sheet 1, it transfers the data from the other columns to the corresponding columns in sheet 2. So line 1 on sheet 2 would contain the first time a 1 showed up in the "tier" column and so on.
Then in sheet 3 would appear on the 1st line the 1st time the number 2 showed up in the "tier" column of sheet 1. In the 2nd line would be the 2nd time. Likewise would be in sheet 4 for every time 3 showed up in the "tier" column.
In essence if it was a phonebook, I am looking to pull all the times smith shows up in sheet 1 and place his info on sheet 2, and every time Jones showed up it goes in sheet 3.
It has been a long time since programming Excel and it was on Office 98'. Things have changed so much that I am just lost. And I can't remember what I used to know on 98'. Please I need help. I am falling behind schedule because of this one formula. I cannot continue with my other formulas without the data transferring to these sheets. And I unfortunately do not have the time to read through all the posts to see if it is already here.
Thanks all
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
