Excel table: combine item number and price list, or only item number?

Hi everyone, I have an Excel spreadsheet with products that lists the item number and price. Now I have a second Excel spreadsheet with only item numbers (in a completely different order than the item numbers in the other document) into which I need to enter the prices. Is there a way to enter a…

Excel delete duplicate rows and always keep only the last one?

Hello everyone, I have to delete all duplicate article numbers in the table below, but the LAST line of each article should be retained because I need the last movement date for each article. Anyone have any idea how I can do this most easily without having to do everything manually? The table has over…

Excel deduct amounts monthly – automatically?

Hello everyone! I have the following question: I have currently entered my debts and repayments into Excel to keep track of the remaining debt and monthly payment. Now I thought, instead of doing it manually every month, there must be a way to have it deducted automatically on a certain day of the month. For…