column row, which way did he go?
 

I'm not sure even what I'm asking, so good luck.

What I'm trying to do is break the column row indicatorial
thingamajig, that A1 or C5 or F117 (you sunk my battleship) into
separate sections.

Soooooo

Instead of typing =A6
I can type =Column A **separately** Row 6

If you know what I mean

Thanks if you can help, but don't feel bad if you can't. Well, maybe
if you want to feel bad you can, but, only a little. OK. It's
Holidays for chrissakes.

Seano

Here's some thoughts ..

Let's say the positions of the battleships/patrol boats in Sheet1 are
represented via typing the letter "X" into cell(s) within a
predetermined "play-grid", say A1:G10

(So your opponent will set up his/her positions in Sheet1
via marking the X's within the grid A1:G10,
and then hide the Sheet1 away from your sight [but of course])

And you'll be using another sheet, say: Sheet2
to plonk in the guided missile coords
into 2 separate cols, say cols A and B,
where the inputs:
in col A, A1 downwards, will be the letters: A, B, C ... G
in col B, B1 downwards, will be the numbers: 1, 2, 3, ... 10

with inputs in each pair (A1:B1, A2:B2, etc ... )
giving the coords (cell refs) of where
you're directing the missiles to land in Sheet1

In Sheet2
---------
Put in C1:

=3DIF(OR(A1=3D"",B1=3D""),"",IF(INDIRECT("Sheet1!" &A1&B1)=3D"X","Direct
Hit!!","Miss"))

Copy C1 down as many rows as needed, say down to C50?
(can copy down ahead of expected data input in cols A and B)

Col C will return the results of the missiles' targeting:
either "Direct Hit!!" or "Miss"

So, if say, B5 in Sheet1 (hidden away) contains an "X",
and you happen to key in Sheet2
in cell A1: B, in cell B1: 5
then C1 will return: Direct Hit!!

--
Rgds
Max
xl 97
---
GMT+8, 1=B0 22' N 103=B0 45' E
xdemechanik <atyahoo<dotcom
----

Seano wrote:
I'm not sure even what I'm asking, so good luck.

What I'm trying to do is break the column row indicatorial
thingamajig, that A1 or C5 or F117 (you sunk my battleship) into
separate sections.

Soooooo

Instead of typing =3DA6
I can type =3DColumn A **separately** Row 6

If you know what I mean

Thanks if you can help, but don't feel bad if you can't. Well, maybe
if you want to feel bad you can, but, only a little. OK. It's
Holidays for chrissakes.
=20
Seano

Cool!

Excel Battleship!

OK, let me throw a monkey wrench into the mix. <bg

How will you know when you've sunk one of your opponents=20
ships?

I guess you could count the total "hits" against the total=20
number of "X's" but that would only let you know when=20
you've destroyed the entire fleet.

Biff

-----Original Message-----
Here's some thoughts ..

Let's say the positions of the battleships/patrol boats=20
in Sheet1 are
represented via typing the letter "X" into cell(s) within=20
a
predetermined "play-grid", say A1:G10

(So your opponent will set up his/her positions in Sheet1
via marking the X's within the grid A1:G10,
and then hide the Sheet1 away from your sight [but of=20
course])

And you'll be using another sheet, say: Sheet2
to plonk in the guided missile coords
into 2 separate cols, say cols A and B,
where the inputs:
in col A, A1 downwards, will be the letters: A, B, C ... G
in col B, B1 downwards, will be the numbers: 1, 2, 3, ...=20
10

with inputs in each pair (A1:B1, A2:B2, etc ... )
giving the coords (cell refs) of where
you're directing the missiles to land in Sheet1

In Sheet2
---------
Put in C1:

=3DIF(OR(A1=3D"",B1=3D""),"",IF(INDIRECT("Sheet1! "&A1&B1)
=3D"X","Direct
Hit!!","Miss"))

Copy C1 down as many rows as needed, say down to C50?
(can copy down ahead of expected data input in cols A and=20
B)

Col C will return the results of the missiles' targeting:
either "Direct Hit!!" or "Miss"

So, if say, B5 in Sheet1 (hidden away) contains an "X",
and you happen to key in Sheet2
in cell A1: B, in cell B1: 5
then C1 will return: Direct Hit!!

--
Rgds
Max
xl 97
---
GMT+8, 1=B0 22' N 103=B0 45' E
xdemechanik <atyahoo<dotcom
----

Seano wrote:
I'm not sure even what I'm asking, so good luck.

What I'm trying to do is break the column row=20
indicatorial
thingamajig, that A1 or C5 or F117 (you sunk my=20
battleship) into
separate sections.

Soooooo

Instead of typing =3DA6
I can type =3DColumn A **separately** Row 6

If you know what I mean

Thanks if you can help, but don't feel bad if you=20
can't. Well, maybe
if you want to feel bad you can, but, only a little. =20
OK. It's
Holidays for chrissakes.
=20
Seano

.

Biff wrote
....
How will you know when you've sunk
one of your opponents ships?

SImple <bg, since we're only talking patrol boats here
so each "Direct Hit!!" = an "X" = 1 patrol boat

Chip's page has some interesting games:
http://www.cpearson.com/excel/games.htm

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----