Need formula to add specific #'s across the top
 

I want to be able number columns across the top of my excel sheet. EX.
(0, 0) (1, 0) (2, 0)
How do I get it to keep adding 1 number to the front # and keep the second #
as a zero?
When I do it down a column it works fine but when I try to do it across it
just keeps repeating itself so that I get:
(0, 0) (1, 0) (2, 0) (0, 0) (1, 0) (2, 0) instead of
(0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0)
Any help would be greatly appreciated.

Need formula to add specific #'s across the top
 

Enter in A1

="(" & COLUMN()-1 & ", 0)" returns (0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0) as
it is copied across row 1


Gord Dibben MS Excel MVP



On Mon, 23 Jul 2007 15:36:02 -0700, kdogtrainer
wrote:

I want to be able number columns across the top of my excel sheet. EX.
(0, 0) (1, 0) (2, 0)
How do I get it to keep adding 1 number to the front # and keep the second #
as a zero?
When I do it down a column it works fine but when I try to do it across it
just keeps repeating itself so that I get:
(0, 0) (1, 0) (2, 0) (0, 0) (1, 0) (2, 0) instead of
(0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0)
Any help would be greatly appreciated.

Need formula to add specific #'s across the top
 

Your formula did the trick for putting the numbers across the way I needed
them but now when I try to add down it no longer works the way it did. This
is the result I am trying to get on the whole spreadsheet

(0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0)
(0, 1) (1, 1) (2, 1) (3, 1) (4, 1) (5, 1)
(0, 2) (1, 2) (2, 2) (3, 2) (4, 2) (5, 2)

Thank you very much for your help

"Gord Dibben" wrote:

Enter in A1

="(" & COLUMN()-1 & ", 0)" returns (0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0) as
it is copied across row 1


Gord Dibben MS Excel MVP



On Mon, 23 Jul 2007 15:36:02 -0700, kdogtrainer
wrote:

I want to be able number columns across the top of my excel sheet. EX.
(0, 0) (1, 0) (2, 0)
How do I get it to keep adding 1 number to the front # and keep the second #
as a zero?
When I do it down a column it works fine but when I try to do it across it
just keeps repeating itself so that I get:
(0, 0) (1, 0) (2, 0) (0, 0) (1, 0) (2, 0) instead of
(0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0)
Any help would be greatly appreciated.

Need formula to add specific #'s across the top
 

="(" & COLUMN()-1 &", "& ROW()-1 & ")"


Gord

On Tue, 24 Jul 2007 10:32:06 -0700, kdogtrainer
wrote:

Your formula did the trick for putting the numbers across the way I needed
them but now when I try to add down it no longer works the way it did. This
is the result I am trying to get on the whole spreadsheet

(0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0)
(0, 1) (1, 1) (2, 1) (3, 1) (4, 1) (5, 1)
(0, 2) (1, 2) (2, 2) (3, 2) (4, 2) (5, 2)

Thank you very much for your help

"Gord Dibben" wrote:

Enter in A1

="(" & COLUMN()-1 & ", 0)" returns (0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0) as
it is copied across row 1


Gord Dibben MS Excel MVP



On Mon, 23 Jul 2007 15:36:02 -0700, kdogtrainer
wrote:

I want to be able number columns across the top of my excel sheet. EX.
(0, 0) (1, 0) (2, 0)
How do I get it to keep adding 1 number to the front # and keep the second #
as a zero?
When I do it down a column it works fine but when I try to do it across it
just keeps repeating itself so that I get:
(0, 0) (1, 0) (2, 0) (0, 0) (1, 0) (2, 0) instead of
(0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0)
Any help would be greatly appreciated.

Need formula to add specific #'s across the top
 

You can amend Gord's formula like so:

="(" & COLUMN()-1 & ", " & ROW()-1 & ")"

Enter this in cell A1 and copy it across. Then highlight row 1 and
copy it down - you will get the layout you want.

Hope this helps.

Pete

On Jul 24, 6:32 pm, kdogtrainer
wrote:
Your formula did the trick for putting the numbers across the way I needed
them but now when I try to add down it no longer works the way it did. This
is the result I am trying to get on the whole spreadsheet

(0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0)
(0, 1) (1, 1) (2, 1) (3, 1) (4, 1) (5, 1)
(0, 2) (1, 2) (2, 2) (3, 2) (4, 2) (5, 2)

Thank you very much for your help



"Gord Dibben" wrote:
Enter in A1

="(" & COLUMN()-1 & ", 0)" returns (0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0) as
it is copied across row 1

Gord Dibben MS Excel MVP

On Mon, 23 Jul 2007 15:36:02 -0700, kdogtrainer
wrote:

I want to be able number columns across the top of my excel sheet. EX.
(0, 0) (1, 0) (2, 0)
How do I get it to keep adding 1 number to the front # and keep the second #
as a zero?
When I do it down a column it works fine but when I try to do it across it
just keeps repeating itself so that I get:
(0, 0) (1, 0) (2, 0) (0, 0) (1, 0) (2, 0) instead of
(0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0)
Any help would be greatly appreciated.- Hide quoted text -

- Show quoted text -

Need formula to add specific #'s across the top
 

Sorry to have butted in, Gord - your post wasn't visible (in Google
Groups) when I posted mine.

Pete

On Jul 24, 7:44 pm, Gord Dibben <gorddibbATshawDOTca wrote:
="(" & COLUMN()-1 &", "& ROW()-1 & ")"

Gord

On Tue, 24 Jul 2007 10:32:06 -0700, kdogtrainer



wrote:
Your formula did the trick for putting the numbers across the way I needed
them but now when I try to add down it no longer works the way it did. This
is the result I am trying to get on the whole spreadsheet

(0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0)
(0, 1) (1, 1) (2, 1) (3, 1) (4, 1) (5, 1)
(0, 2) (1, 2) (2, 2) (3, 2) (4, 2) (5, 2)

Thank you very much for your help

"Gord Dibben" wrote:

Enter in A1

="(" & COLUMN()-1 & ", 0)" returns (0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0) as
it is copied across row 1

Gord Dibben MS Excel MVP

On Mon, 23 Jul 2007 15:36:02 -0700, kdogtrainer
wrote:

I want to be able number columns across the top of my excel sheet. EX.
(0, 0) (1, 0) (2, 0)
How do I get it to keep adding 1 number to the front # and keep the second #
as a zero?
When I do it down a column it works fine but when I try to do it across it
just keeps repeating itself so that I get:
(0, 0) (1, 0) (2, 0) (0, 0) (1, 0) (2, 0) instead of
(0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0)
Any help would be greatly appreciated.- Hide quoted text -

- Show quoted text -

Need formula to add specific #'s across the top
 

No problem Pete

If one is good two must be better<g

My Dad organized his life on that philosphy and only rarely got into trouble but
when he did.................hooboy!!


Gord

On Tue, 24 Jul 2007 16:01:38 -0700, Pete_UK wrote:

Sorry to have butted in, Gord - your post wasn't visible (in Google
Groups) when I posted mine.

Pete

On Jul 24, 7:44 pm, Gord Dibben <gorddibbATshawDOTca wrote:
="(" & COLUMN()-1 &", "& ROW()-1 & ")"

Gord

On Tue, 24 Jul 2007 10:32:06 -0700, kdogtrainer



wrote:
Your formula did the trick for putting the numbers across the way I needed
them but now when I try to add down it no longer works the way it did. This
is the result I am trying to get on the whole spreadsheet

(0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0)
(0, 1) (1, 1) (2, 1) (3, 1) (4, 1) (5, 1)
(0, 2) (1, 2) (2, 2) (3, 2) (4, 2) (5, 2)

Thank you very much for your help

"Gord Dibben" wrote:

Enter in A1

="(" & COLUMN()-1 & ", 0)" returns (0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0) as
it is copied across row 1

Gord Dibben MS Excel MVP

On Mon, 23 Jul 2007 15:36:02 -0700, kdogtrainer
wrote:

I want to be able number columns across the top of my excel sheet. EX.
(0, 0) (1, 0) (2, 0)
How do I get it to keep adding 1 number to the front # and keep the second #
as a zero?
When I do it down a column it works fine but when I try to do it across it
just keeps repeating itself so that I get:
(0, 0) (1, 0) (2, 0) (0, 0) (1, 0) (2, 0) instead of
(0, 0) (1, 0) (2, 0) (3, 0) (4, 0) (5, 0)
Any help would be greatly appreciated.- Hide quoted text -

- Show quoted text -