0

Creating rows based on Excel data

Jet Reports Historic Posts

April 08, 2009 10:51

None

Follow

Hi

In an NL("Rows" …) command I want to be able to create rows based on Excel data and not NAV data. I can use the "My values" option, and create a fomula as

NL("Rows";{"AAA";"BBB";"CCC"};"My values")

which produced three rows as expected.

The trick is that I want to populate the part {"AAA";"BBB";"CCC"} based on an Excel cell, and I think I have tried every possible combination of quotes and single quotes to do that, but with no success.

Anybody knows how to do it?

• Facebook
• Twitter
• LinkedIn

3 comments

• 
  Jet Reports Historic Posts April 08, 2009 13:18 Official comment

  I think I'm following you correctly.
  
  Say, cells E16 to E23 had your list of values.
  
  Then, you could do
  
  =nl("Rows",$E$16:$E$23)
  
  Is that what you were after?

• 0
  
  Jet Reports Historic Posts April 08, 2009 13:23

  Thanks, Mark
  
  That was exactly what I was looking for. And what a simpe solution ;)

• 0
  
  Jet Reports Historic Posts April 08, 2009 14:33

  Happy to help.
  
  I actually use that quite a lot in combination with vlookups -i.e. those cells will be a 'code' and next to it I have the plain language description of the code. Although with vlookups sometimes alphabetical order is important.
  
  cheers, Mark