Sorting problem

  • Thread starter Thread starter Khoshravan
  • Start date Start date
K

Khoshravan

As far as I understand the sorting is Ok. Why do you think the result is
misleading?
 
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:

PO# order qty DN# Qty
ABC 20000pcs #12345 5000
#14355 5000
#19834 5000

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?
 
Hi

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.
 
Back
Top