Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello. I will try to describe an issue and hope someone could help me. I am new to it
1. I have a copy of a spreadsheet with formulas (textboxes and so one). Original project was fully functional. This project ( a copy i am speaking of) has a lot of variables, wich i need to add and recalulate.
Example.
I have a file (qvo) with such structure (let name be "Table1"):
value fild 1| value field2 | value field 3|
Yes asdasd 1111
No treasd 2231
So now i need to calc unique values of field2 and print them somewhere. I can do it like
=Count(DISTINCT [value field2]) and it works good.
This is way i rewrite it
But originaly this was with variable like
=(Count(DISTINCT $(vField2Count)) and it worked and did the same.
It is dynamic.
I think this Variable vField2Count was assigned like with every field of that column.Think it was loading at the load script.
I need to do it like this as this variables are using across all project.
Hope you understand me. Thx
this is exactly what i needed!
I think i described problem very complicated!!
Thank you very much