So I can't extend the formula to have a column of rates corresponding to the column of dates. When I use the formula to refer to a specific date (using the cell instead of the date), the result takes 4 cells because it creates the table date/close that we can see on your examples. I would like to have the currency exchange rate on a 2nd column, using dates from the first one, and extend the function so when we put a new date, the currency exchange rate appear automatically. It's not daily nor monthly, it depends on our customers. On my google sheet, I have a column for our delivery dates. I have some trouble to use it, and I would like to know if there is a solution to my problem. Thank you for sharing this useful formula. How to compare data in two Google sheets or columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |