R
raiders1
I have data that I have brought into a spreadsheet from our manufacturing
database.
I have cells that have doubled in the query I did. Example below:
Item No Order Qty CO# lIne# Mfg Or Machine Raw
Material Yield
524725 25,000 52 2 22546 Compo
1755012546 500.00
524725 25,000 52 2 22546 Compo
ikraft 250.00
524725 25,000 52 2 22546 Sub
1755012546 500.00
524725 25,000 52 2 22546 Sub
ikraft 250.00
I was wondering if there is a formula that I can use to get this result
524725 25,000 52 2 22546 Compo
1755012546 500
ikraft 250
Sub
Thanks!!
database.
I have cells that have doubled in the query I did. Example below:
Item No Order Qty CO# lIne# Mfg Or Machine Raw
Material Yield
524725 25,000 52 2 22546 Compo
1755012546 500.00
524725 25,000 52 2 22546 Compo
ikraft 250.00
524725 25,000 52 2 22546 Sub
1755012546 500.00
524725 25,000 52 2 22546 Sub
ikraft 250.00
I was wondering if there is a formula that I can use to get this result
524725 25,000 52 2 22546 Compo
1755012546 500
ikraft 250
Sub
Thanks!!