Thread
:
ROW()
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
phocused
external usenet poster
Posts: 37
ROW()
Don,
that doesnt appear to have made any differenct, it still returns blank when
i want it to return the column number. Thanks anyway.
Rgds Paul
"Don Guillett" wrote:
Perhaps g1 should be absolute $g$1
--
Don Guillett
SalesAid Software
"phocused" wrote in message
...
Hi,
Can anyone help please.
I have the following straightforward formula in a spreadsheet.
=IF(MONTH(C2)=G1,ROW(),"")
For some reason it doesnt return the row number when the months are the
same. What am I missing?
thanks in advance for the help
Rgds Paul
Reply With Quote
phocused
View Public Profile
Find all posts by phocused