Hi,
I need to scavenge all the functions like Index or Match that have an auto-filled qualifier (like a column or a row) on a pretty massive excel sheet. As in Excel the qualifiers are "guessed" by software and do not give any issue, the transposition into Xcelsius results patchy if not unworkable.
Is there a fast way to find these functions that have been auto-qualified part in the formula or do I have to check all functions that might be constructed that way one by one?
Thanks,
L
I need to scavenge all the functions like Index or Match that have an auto-filled qualifier (like a column or a row) on a pretty massive excel sheet. As in Excel the qualifiers are "guessed" by software and do not give any issue, the transposition into Xcelsius results patchy if not unworkable.
Is there a fast way to find these functions that have been auto-qualified part in the formula or do I have to check all functions that might be constructed that way one by one?
Thanks,
L
Last edited:
