| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking up values in multiple cells
Hi,
I have a spreadsheet that shows open purchase order lines, the due date and the quantity. Some part numbers have multiple receipt dates and quantities. How can I get those multiple dates into one cell on another spreadsheet? Thank you, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Looking up values in multiple cells
Hi Richard,
If the receipt dates are located in B2 and B3, the formula may be =TEXT(B2,"dd.mmm.yy")&", "&TEXT(B3,"dd.mmm.yy") -- ~roar Richard skrev: Hi, I have a spreadsheet that shows open purchase order lines, the due date and the quantity. Some part numbers have multiple receipt dates and quantities. How can I get those multiple dates into one cell on another spreadsheet? Thank you, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| offsetting values of multiple cells! | Excel Worksheet Functions | |||
| percenatge increase in values across multiple cells | New Users to Excel | |||
| How do I merge cells with multiple data values? | Excel Discussion (Misc queries) | |||
| Adding separate accumulators for multiple cells | New Users to Excel | |||
| Adding multiple cells, return specific values | Excel Worksheet Functions | |||
Linear Mode
