Hello Bob,

Many thanks for the array formula if I am not mistaken.

Best Regards,

Low

--
A36B58K641


"Bob Umlas, Excel MVP" wrote:

make that Ctrl+Shift+Enter (!)

"Mr. Low" wrote:

Hi,

I am working on the following table:

A B C D E
1 Item Amount Balance Status Group
2 L21 100 Full
3 L21 -60 Full
4 L21 -40 0 Full Full
5 T48 250 Part
6 T48 -50 Part
7 T48 -50 -100 Part Part
8 M64 120 Unpaid
9 M64 220 340 Unpaid Unpaid
10 K74 500 Full
11 K74 -300 Full
12 K74 -100 Full
13 K74 -100 0 Full Full
14 Q32 400 Part
15 Q32 -150 250 Part Part

Column D is the status of the item based on the balance.

May I know what formula I must input at cell E2 and copy downwards to fill
up the status for the rows with like items ?

Thanks

Low

--
A36B58K641