Quote:
Originally Posted by 0rion
...Table1 is for a barcode scanner data entry...using a defined table is nice because when you scan the data into column A and then into B, it goes to the next row-column A automatically without keyboard input. I can focus on scanning with an occasional glimpse back at the laptop to make sure nothing was missed.
|
I can't test it out currently, but maybe this will work:
Have calculated columns in your Table 1, but hide them. This ensures calculations are made when data are read in, but the Table will work like with 2 columns only;
Try to use FILTER() to get wanted report data displayed separately (I'm currently only aware there is such function in latest versions, but I have never used it. You have to test yourself, is it possible to get all 3 columns of data returned without applying any conditions).