Forum Discussion
Data Consolidation Function skipping text fields
Hi Folks.... I am using the consolidation function to consolidate 5 worksheets in to a Master in the same workbook. When I do this, any cell with text in it shows as blank. I have searched the ...
All functions for data aggregation in Data Consolidation ignore texts. Or almost all, perhaps some return errors, don't remember what is inside exactly. Data Consolidation ignores all such cells. Thus if in the same cell in all 5 sheets you have texts, nothing will be returned. Except headers of course.
Didn't use it for a long while, above is my guess how it shall work.