View Single Post
 
Old 10-27-2015, 05:16 AM
mesTrethowan mesTrethowan is offline Windows 10 Office 2013
Novice
 
Join Date: Oct 2015
Posts: 7
mesTrethowan is on a distinguished road
Default

the formula appears to list the records sequentially as they appear in the data set.

So if I want 25 results for letter "T" it list the first 25 records it finds, anything after this is hidden.

Therefore if I have a total of say 150 records that are coded "T" number 1 - 150 the formula seems to list values 1 - 25 while hiding 26 - 150 thus not random.

Hope that makes more sense.
Reply With Quote