View Single Post
 
Old 12-20-2016, 12:00 PM
deejay deejay is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Dec 2016
Posts: 4
deejay is on a distinguished road
Default

You may be right. Thanks.

Since you are so good, here is a question I've had for some time that I just ignored and worked around by turning off formula error detection (which is generally terrible, I think).

What in the world is the legitimate cause and meaning of this error message, "The formula in this cell refers to a range that has additional numbers adjacent to it." That could naturally occur in a BUNCH of places where it is certainly not an error. AND YET, it shows up inconsistently. Where I filled the same formula - =IF(B41="","",COUNTA(D41:BA41)) - down a column (50 rows), and the contents of the referenced array are identical on each row, the error message shows up in only the last 13 cells in that vertical array.

Je vois que vous êtes en Belgique. J'y suis allé plusieurs fois et j'ai 4 Belges dans ma vie ici à Austin, au Texas. Joyeux Noel.
Reply With Quote