Hi All,
Sorry if this seems a little daft but i can't fathom what is happening here.
I have converted some information to a table, but I don't want to see the header, so I've removed it under Design>Table Style Options.
The problem with the removed header is that i now have an issue when inserting rows.
Say I have the following in the G Column:
Row 23.... =PRODUCT(F23,COUNTA(H23:J23))
Row 24.... =PRODUCT(F24,COUNTA(H24:J24))
Row 25.... =PRODUCT(F25,COUNTA(H25:J25))
Row 26.... =PRODUCT(F26,COUNTA(H26:J26))
If I were to insert a row between Rows 24 & 25, the following is shown in G Column:
Row 23.... =PRODUCT(F23,COUNTA(H23:J23))
Row 24.... =PRODUCT(F24,COUNTA(H24:J24))
Row 25.... =PRODUCT(F24,COUNTA(H24:J24))
Row 26.... =PRODUCT(F26,COUNTA(H26:J26))
Note the Row 25 formula has repeated that of Row 24
Unfortunately I can't upload an example of this as when i do, the issue goes away.
Any ideas what is causing this and how I can resolve it?
Regards,
Jack
Bookmarks