reza_doang
Board Regular
- Joined
- May 31, 2010
- Messages
- 187
Hi All -
Need your expertise in excel
Currently i have data with thousands of rows and there is duplication in some of data, but i can't delete it.
i have column PO Number and duration of the PO (from PO created - PO release) and not in consecutive.
In that column,I just want to take the information each PO only 1 (irrespective with PO duplication)
i.e
I have 10.000 PO numbers (rows) but might be only 5.000 PO the unique one.
by manually i can use pivot or table and remove duplicate, but it will take more effort.
Really appreciate if you can give formula to get only first PO data and ignore the rest for same PO.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]PO[/TD]
[TD]Days[/TD]
[TD]expected result[/TD]
[/TR]
[TR]
[TD]2000100[/TD]
[TD]5[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]2000200[/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2000100[/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2000300[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2000200[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2000500[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
Hope you understand with my requirement.
Thanks in advance
Reza
Need your expertise in excel
Currently i have data with thousands of rows and there is duplication in some of data, but i can't delete it.
i have column PO Number and duration of the PO (from PO created - PO release) and not in consecutive.
In that column,I just want to take the information each PO only 1 (irrespective with PO duplication)
i.e
I have 10.000 PO numbers (rows) but might be only 5.000 PO the unique one.
by manually i can use pivot or table and remove duplicate, but it will take more effort.
Really appreciate if you can give formula to get only first PO data and ignore the rest for same PO.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]PO[/TD]
[TD]Days[/TD]
[TD]expected result[/TD]
[/TR]
[TR]
[TD]2000100[/TD]
[TD]5[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]2000200[/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2000100[/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2000300[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2000200[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2000500[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
Hope you understand with my requirement.
Thanks in advance
Reza