Forum Discussion
Emmarky
Oct 21, 2024Copper Contributor
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...
HansVogelaar
Oct 23, 2024MVP
You can use the FILTER function. See the attached version.