Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel formula
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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel formula
I presume you are trying to ask something more difficult than "how do I
return the values in the first row of a range?", but if so, then the basis upon which your desired result is to be returned is unclear. More information, please. Jerry "raiders1" wrote: 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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions |