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...
Emmarky you can do this using FILTER or a Pivot Table or PowerPivot
attached is a sample using the FILTER function
=FILTER(Orders,$A$1=Orders[Segment],$A$1&" have no data")where on each of the 3 sheets I typed the name of the Segment into A1 and on the Orders page I 'formatted as table' the data and named that table Orders so that the formula is more 'readable'