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 net and the community here and have found nothing. Seems like an easy fix, but beating my head against the wall at this point.
Appreciate any guidance in advance. Thanks yall!
1 Reply
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.
