Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
steveh3
273 Views, 3 Replies

Getting data from a spreadsheet with 2 dimension array

Hello Gang...

I have a spreadsheet which has two dimensions OD and BC.

steveh_1-1663779670855.png

For the DimC, I would like to gather all the rows where OD is greater than or equal to the DimC value chosen in the form (grey hi-lited cells).

 

Then also do the same for the BC. Select all rows where BC is greater than or equal to MaxBC (yellow hi-lited cells).

 

Then the result for AvailableDiscs would be the intersection of the two sets (green hi-lited). This would then show up in the form as what would be available to chose. 

 

I have the form and spreadsheet set up, but I can't figure out how to dynamically update the Listing of AvailableDiscs.

 

steveh_2-1663779995871.png

I'm assuming this is possible?

I have included the .ipt and spreadsheet as attachments.

 

Thanks in advance,

Steve H.

 

Steve Hilvers
Inventor Certified User / Vault Professional Influencer