Hello, I have problem on designing a worksheet for client order management.
One client order usually comes with several delivery from our side :
PO# order qty DN# Qty
ABC 20000pcs #12345 5000
#14355 5000
#21379 10000
DEF 10000pcs #23198 5000
#19834 5000
Question:
the problem is that when I sort the column "DN#" with figures started by "1"
the result comes out like this:
Since the result is misleading, I am now looking for solutions that could
correctly display my query. Any suggestions on the design/ excel function
that could be used?
I think your problem is just that you don't have PO# on each line
You can achieve this quite easily.
Select the range of cells in column A, equivalent to the range of cells in
DN#
F5>Special>Blanks>OK
This will select all the blank cells and your cursor will be in the first of
these.
=up arrow>Control+Enter
All the blanks will now be filled with the PO#
as far as the delivery point DN# is concerned, ignore Order Qty, it is just
the Qty that is relevant
There are 4 navigation keys on the keyboard Up, Down Left and Right
Press the = key, then the up arrow, which will select the cell above the
first of the empty cells, then press Enter.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
