Forum Discussion
Excel data segregation
Hi All, I have orders data in Sheet 1, and it needs to be segregated into different sheets based on the segment in Column H (e.g., Consumer, Corporate, or Home Office). Further data analysis will be...
Hi HansVogelaar this is working i have updated to latest version but when i delete any cells in the Orders sheet it is appearing as 0 in the other sheets, how to show blank cells from the orders sheet as blanks in the other sheets please
In the workbook that I attached to my first reply, empty cells from the Orders sheet will be blank on the other sheets too. The last part of the formula
=LET(f, FILTER(Orders!A2:X100000, Orders!H2:H100000="Consumer"), IF(f="", "", f))
takes care of that.
