Thread: [Solved] Conditional Row Searching
View Single Post
 
Old 02-21-2018, 12:36 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 749
ArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to behold
Default

In case you/user enter(s) data into your table, then it is poorly designed - and as result you have difficulties to make any calculations based on this table.

In attachment is an alternative.

On sheet DataTable user enters parameters for item - a single parameter on row. In case the user enters some parameter twice, the entry is blocked and a message pops up (Data Validation). (Data Validation formula uses Names, defined in FORMULAS>Name Manager.)

On sheet PivotTable a Pivot Table report is designed, which is an analog of your table.
Attached Files
File Type: xlsx example.xlsx (13.8 KB, 8 views)
Reply With Quote