If sheet 1 column 4 says hol then it fills in columns A1,B1 and
Closed
scarey3
Posts
4
Registration date
Tuesday October 15, 2013
Status
Member
Last seen
February 12, 2014
-
Jan 31, 2014 at 02:38 PM
Blocked Profile - Jan 31, 2014 at 05:12 PM
Blocked Profile - Jan 31, 2014 at 05:12 PM
Related:
- If sheet 1 column 4 says hol then it fills in columns A1,B1 and
- Tentacle locker 1 - Download - Adult games
- Fnaf 1 download pc - Download - Horror
- Igi 1 download - Download - Shooters
- Five nights in anime 1 - Download - Adult games
- 4 elements trainer - Download - Adult games
1 response
Scarey,
I hope I am not doing homework!
ok, hang tight!
if function: =if(logic_test,true, false)
So, let us look at the first thing:address.
So then, take that function, click on the cell, and drag it down [notice the address locations changes are relative to the cell that is calling it]. The function always needs to see if qualitying cell has HOL.
It will transfer the blank lines, so if line 12 has HOL, then line 12 on second sheet is filled, it DOES NOT LOOK FOR NEXT ROW on second sheet! What do you want for free? :)
Let us know if this helps.
Have Fun!
//ark
-Moderator/Contributor
I hope I am not doing homework!
ok, hang tight!
if function: =if(logic_test,true, false)
So, let us look at the first thing:address.
So then, take that function, click on the cell, and drag it down [notice the address locations changes are relative to the cell that is calling it]. The function always needs to see if qualitying cell has HOL.
It will transfer the blank lines, so if line 12 has HOL, then line 12 on second sheet is filled, it DOES NOT LOOK FOR NEXT ROW on second sheet! What do you want for free? :)
Let us know if this helps.
Have Fun!
//ark
-Moderator/Contributor
