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?

you need to select only the ranges which is for PO# ABC don't select
the entire column.


On Feb 5, 12:17*pm, Ting Li wrote:
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#
F5SpecialBlanksOK
This will select all the blank cells and your cursor will be in the first of
these.
=up arrowControl+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

--
Regards
Roger Govier

"Ting Li" wrote in message
...
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?

What do yo mean by "up arrow" in: =up arrowControl+Enter
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Roger Govier" wrote:

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#
F5SpecialBlanksOK
This will select all the blank cells and your cursor will be in the first of
these.
=up arrowControl+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

--
Regards
Roger Govier

"Ting Li" wrote in message
...
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,

He means that press the = key, then press the up arrow key and then press
Ctrl+Enter

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Khoshravan" wrote in message
...
What do yo mean by "up arrow" in: =up arrowControl+Enter
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Roger Govier" wrote:

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#
F5SpecialBlanksOK
This will select all the blank cells and your cursor will be in the first
of
these.
=up arrowControl+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

--
Regards
Roger Govier

"Ting Li" wrote in message
...
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?

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.

--
Regards
Roger Govier

"Khoshravan" wrote in message
...
What do yo mean by "up arrow" in: =up arrowControl+Enter
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Roger Govier" wrote:

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#
F5SpecialBlanksOK
This will select all the blank cells and your cursor will be in the first
of
these.
=up arrowControl+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

--
Regards
Roger Govier

"Ting Li" wrote in message
...
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?