Forum

Hello, See if attached example suits your needs. Br, Anders

Hello, When opening your file I am met with an alert that there one or more circular references, this needs to be looked up on. Also when looking t...

Hello, Can you share a sample file showing what your data and formula looks like, so we can get a better understanding of what you are trying to ac...

Hello Sunil, If you only want six months data then it is of course simplest to limit the export from ServiceNow, but it is doable to also filter in...

Hello Sunil, I have played around with the regional settings and when switching over to English (United Kingdom) settings I get the same issue as y...

Hello Sunil, I made a simple screen recording too, so you can see the difference. Your row 1 is the column headers, for me I get the column headers...

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?