Code: Select all
if (
CompareText(Name(Rank(1,c)),[base]),
1,
if (
CompareText(Name(Rank(1,c)),[top]),
2,
))
Code: Select all
if (
CompareText(Name(Rank(1,c)),[base]),
1,
if (
CompareText(Name(Rank(1,c)),[top]),
2,
))
Code: Select all
Do(
var([valRowCount], vbValue, 1),
LoopUntil(
CompareText(cell(valRowCount, 1, refTable), name(first(c))) = 1,
valRowCount := valRowCount + 1
nRows(refTable)
),
Cell(valRowCount , 2, refTable)
)