First of all, the worksheet in question can be seen here:
http://www.cameronspencer.com/semester5.html
I added the column and row headers (abc, 123, etc.) so everyone knows what's what.
Basically I'm looking for a formula to figure out how many dual flights, solo flights, etc. I haven't done yet.
Pseudo code:
dual_flights_remaining = 0;
for(i<=30,i=1,i++) {
if (("I"+i == "") && ("B"+i<>""))
dual_flights_remaining++;
}
Then cell L22 would be "=dual_flights_remaining"
I'm assuming this would be accomplished with VB Scripting?
Thanks.
EDIT: Fixed the URL.
This message was edited by Ice5 on 2002-09-19 17:42
http://www.cameronspencer.com/semester5.html
I added the column and row headers (abc, 123, etc.) so everyone knows what's what.
Basically I'm looking for a formula to figure out how many dual flights, solo flights, etc. I haven't done yet.
Pseudo code:
dual_flights_remaining = 0;
for(i<=30,i=1,i++) {
if (("I"+i == "") && ("B"+i<>""))
dual_flights_remaining++;
}
Then cell L22 would be "=dual_flights_remaining"
I'm assuming this would be accomplished with VB Scripting?
Thanks.
EDIT: Fixed the URL.
This message was edited by Ice5 on 2002-09-19 17:42