Filtering Excel range in NL Rows function

Martin Emanuel

August 28, 2019 20:48

None

Folks I'm trying to use the NL Rows function over an Excel list with filtered values. In the example table below, how could I return the list of Ford Models (Fiesta,Focus, Explorer), i.e. the values in cells D6:D8 using NL function?

There may be answers in historical posts but I'm unable to access them for some reason.

Thanks for your help!

	C	D
	Make	Model
3	Hyundai	Elentra
4	Hyundai	Sonata
5	Hyundai	Accent
6	Ford	Fiesta
7	Ford	Focus
8	Ford	Explorer
9	Nissan	Altima
10	Nissan	Cube
11	Nissan	Sentra
12	Nissan	Versa
13	Nissan	Maxima

Date Votes

1 comment

0

Bryan Robinson September 19, 2019 17:17

You can't use Jet exclusively to do this because if you have a range of cells as your table parameter in a replicator, filters are disabled in the JFx.

Can you get creative? Sure (I love a good brain teaser). https://jetreports.sharefile.com/d-s9d097193ff64ac5a (file only available for 180 days from 09/19/19)

Edited by Bryan Robinson September 19, 2019 17:18

Comment actions Permalink

Please sign in to leave a comment.