H
hitesh
sheet1
column a column b column c column d
code no customer name amount paid date
123 anil (sumif formul) (sumif
formul)
897 sunil
587 amit
sheet 2
column a column b column c column d
code no amount date customer name
123 100 10/7/2006
897 150 5/7/2006
123 200 15/7/2006
i used the v lookup formula in column d in sheet 2 link with sheet 1.show
that customer name appear in cell.
in sheet2 i write the amount paid by the cusomer code no(123) in cell the
amount calcullated in sheet1 column b, and date also appear in sheet1 in
column d
my problem is that , i wrote 2 time amount given by the customer in two
dates in sheet 2 i.e amount in column b and date in column c
amount calculated but date changes as the customer given a 2 amount in 2
dates but date does not meet with first or second one
so i can i know the customer (123) in sheet 1 given 300/-rs in how many
times and which dates. which formula will use in column d of sheet 1 so date
can be shown as given below
pls date must be seen like this as shoen in colum d of sheet 2 given below
(result must be like this given below)
sheet1
column a column b column c column d
code no customer name amount paid date
(sumif formul)
(sumif formul)
123 anil 300
10/7/2006
15/7/2006
897 sunil
587 amit
iam the new user of the excel
help me out of this
column a column b column c column d
code no customer name amount paid date
123 anil (sumif formul) (sumif
formul)
897 sunil
587 amit
sheet 2
column a column b column c column d
code no amount date customer name
123 100 10/7/2006
897 150 5/7/2006
123 200 15/7/2006
i used the v lookup formula in column d in sheet 2 link with sheet 1.show
that customer name appear in cell.
in sheet2 i write the amount paid by the cusomer code no(123) in cell the
amount calcullated in sheet1 column b, and date also appear in sheet1 in
column d
my problem is that , i wrote 2 time amount given by the customer in two
dates in sheet 2 i.e amount in column b and date in column c
amount calculated but date changes as the customer given a 2 amount in 2
dates but date does not meet with first or second one
so i can i know the customer (123) in sheet 1 given 300/-rs in how many
times and which dates. which formula will use in column d of sheet 1 so date
can be shown as given below
pls date must be seen like this as shoen in colum d of sheet 2 given below
(result must be like this given below)
sheet1
column a column b column c column d
code no customer name amount paid date
(sumif formul)
(sumif formul)
123 anil 300
10/7/2006
15/7/2006
897 sunil
587 amit
iam the new user of the excel
help me out of this