Ask Your Question
0

row number in calc function [closed]

asked 2013-03-21 18:16:53 +0200

PhiJ gravatar image

updated 2013-03-22 23:51:32 +0200

I'm trying to make a function in calc that prints the row number of a cell. I tried creating the sequence:

=IF(U4="",4,"")

=IF(U4="",5,"")

=IF(U4="",6,"")

=IF(U4="",7,"")

and then dragging the formula downwards, but it just cycles 4 5 6 7 4 5 6 7.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-27 12:32:11.880079

Comments

I fail to understand what it is that you want to achieve. Could you please be more specific on the expected results.

mahfiaz gravatar imagemahfiaz ( 2013-03-21 18:46:28 +0200 )edit

Sorry. I'm rubbish at writing and should really sit on my posts before rereading them and clicking submit. I'll edit it for clarity.

PhiJ gravatar imagePhiJ ( 2013-03-22 23:50:01 +0200 )edit

2 Answers

Sort by » oldest newest most voted
1

answered 2013-03-21 22:30:37 +0200

mahfiaz gravatar image
=IF(U4="",ROW(U4),"")
edit flag offensive delete link more
0

answered 2013-03-22 08:59:39 +0200

JohnSUN gravatar image

Try drag the formula downwards WITH HOLD DOWN CTRL-key

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-03-21 18:16:53 +0200

Seen: 10,685 times

Last updated: Mar 22 '13