im using DEREFERENCE to populate information from SHEET1 to SHEET2, but it seems that when I make a change to the information to SHEET1 it doesnโt change and reflect on SHEET2.
is there an alternative to REFERENCE to solve this issue?
thank you;
@Francisco_Martinez It sounds like you should be using your dereference formula in a virtual column instead of a non-virtual column.
User | Count |
---|---|
43 | |
27 | |
24 | |
23 | |
13 |