0

Limits of NL Rows and Columns

Hi,

Is anybody aware of any limitations of the Rows or Columns NL functionality? For example, I have a NL Columns within an NL Columns. They appear to replicate across the sheet Ok, until a point where the inner most NL stops replicating. I'm a little stumped as the inner formula that stops replicating is very simple:

=nl("Columns",{"Builder","Retail","Commercial","Distributor"})
The outer formula replicates using Columns=5 on a table of date ranges - this continues to replicate through all expected values without problem, however the inner one stops at columns FT. No errors are thrown.

Does anybody in forums land have an idea before I try support?

thanks, Mark

8 comments

Please sign in to leave a comment.