Last seen: Mar 8, 2026
Hello Sunil, The errors you get in the video is because the first row is text. If you make the first row as headers and after that convert the date...
Hello Sunil, As I don't know how you converted the date/time column, but as shown in attached sample file where I have used your .csv file, I don't...
Hello, Have you read this blog article?
Hello Sunil, I would use Power Query to import the csv file and to convert the date/time column to date. Have you tried using PQ? Check out this bl...
Hello, Yes, it is correct. PQ is integrated in Excel 365 and you find it as Get and transform data. Br, Anders
Ish Ey said Dear Sunny, Could you explain where do I copy the conditional formatting and how do I apply to each spreadsheet? Hello, Th...
Hello Salim, Thank you for your nice feedback.
Hello Salim, Yes, the COUPNCD function gives you only the next coupon date after the settlement date, so you need to give it a new settlement date ...
Hello Salim, Perhaps you are looking for the COUPNCD function?
Hello, Just want to show you an alternative approach where there is no need to have extra sheets nor hiding them. You just need to organize your da...
Hello Dean, If you have Excel 2016 or newer you can use the IFS function. If you are using an older version then you can use nested IF function. ...
Hello, In case you have Excel 2016 or newer you can use IFS function.
Hello, For your second problem, check out these two examples.https://stackoverflow.com/questions/6312710/how-to-get-images-to-appear-in-excel-given...
Hello, The fees calculated with percentage, are they calculated on the base value only or with the fees and taxes added? Example: Base Premiu...
Hello Sara, It would be great if you can upload a sample file showing us the data and structure you have, it will be a lot easier for us to give yo...