Need formula to add specific #'s across the top

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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
 
="(" & COLUMN()-1 &", "& ROW()-1 & ")"


Gord

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
Click to expand...
 
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
 
Sorry to have butted in, Gord - your post wasn't visible (in Google
Groups) when I posted mine.

Pete
 
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
 
Back
Top