Hello,
I have big for monthly sales,
Each invoice is in a separate row and each invoice has (invoice price, the invoice cost, the discount, the additional, and the invoice profit)
My problem is that I have each invoice separately and in my case I want to group the invoices by Date to show the total amounts of the invoices on a specific date on one date and one line..
For example, i need collect all the details of the invoices that are on 20/09/2022 with one line that is on the table on the left and so on ...
Please look at the picture for clarity.
Untitled.png
There is also a problem that the date is not in the same row as the invoice details, For example, as you can see in the above picture, the invoice date is in row 2 and its details are in row 3, and so on...
I tried to use a VLOOKUP Function, but it did not work for me because the tablet are in Arabic and they are from right to left.
That's why I think VLOOKUP it didn't work as expected...
I attached the file..
Thank you in advance
Bookmarks