Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date formula
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Trending Formula Results by Date | Excel Worksheet Functions | |||
Year-to-date year to date formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions |