Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Resolved: Exercise Solution - Column array seems wrong but still returns correct number?
Why do I get the correct Aug number for Store E when the column array is in Store B? Shouldn't I get the Store B number in that case?
1 answers ( 1 marked as helpful)
Hello,
The COLUMNS function works as a counter. It simply counts the number of columns you have from B to J and tells Excel to provide the respective value from the source table (table_array). Best,
Ned