Excel Version 2013See formula in cell G6.
If you're using Excel 2013 (which I think you are), you need to select the whole range G6:G98 while committing the formula to the sheet using Ctrl+Shift+Enter rather than plain Enter.
Macros need to be enabled.
It sould be FIFO as long as the dates increase top to bottom.
What version of Excel are you using?
Thank you Very Much, Sir. Work perfectly.See formula in cell G6.
If you're using Excel 2013 (which I think you are), you need to select the whole range G6:G98 while committing the formula to the sheet using Ctrl+Shift+Enter rather than plain Enter.
Macros need to be enabled.
It sould be FIFO as long as the dates increase top to bottom.
What version of Excel are you using?
Dear Sir, If there is more than one customer and the receipt# distribution should be distributed on the basis of the customer name. means carry forward amount receipt no should be distributed against that one customer using FIFO.See formula in cell G6.
If you're using Excel 2013 (which I think you are), you need to select the whole range G6:G98 while committing the formula to the sheet using Ctrl+Shift+Enter rather than plain Enter.
Macros need to be enabled.
It sould be FIFO as long as the dates increase top to bottom.
What version of Excel are you using?
appreciatable. Thanks once againThis would take too much time.
Suggest sorting your data by customer name then secondarily by date then putting separate formulae for each company.
See cells F6:F17 and F18:F36 in the attached.
Sir, as you helped me for distributing Receipt No. Now Please help me for distributing the Date of that Receipt no. in the very next column. The file is attached to understand what help I needed. thanksThis would take too much time.
Suggest sorting your data by customer name then secondarily by date then putting separate formulae for each company.
See cells F6:F17 and F18:F36 in the attached.
Please find attached the file with UDF for populating the datesSir, as you helped me for distributing Receipt No. Now Please help me for distributing the Date of that Receipt no. in the very next column. The file is attached to understand what help I needed. thanks
See attached, same method of committing the formula to the sheet but apply the formula to 2 columns at once instead of one. Note that the range that the formula refers to has expanded to include 5 columns.for distributing the Date of that Receipt no. in the very next column
That's absolutely fine!still I was able to change the references to populate the dates as required by Haider