Forum

Hello, It seems to me that you could use IF statements by adding a conditional column. Br, Anders

Hello, Depending on what version of Excel you use, if you use Excel 365 then chances are that you can use the new functions. Here are some good art...

Hello, I am sorry to say that I can't find a working solution that rounds the monthly salary as you want it. Hopefully someone else in this forum k...

Hello, The problem I see with your approach is that you have to break the formula the second month from start, else the monthly salary for the seco...

Hello Muhammad, I don't really understand why you want to add this extra column, because if you don't want to sum the PO Total Amount column, then ...

Hello, I don't really see any rounding issue. As attached picture shows (you might need to save it on your computer to be able to zoom in and see a...

Hello, If you know the time difference between the zones you can easily add or subtract the time difference to your original time. Example: Univ...

Hello Arthur, I have done some changes in your formula, see attached file. The formula is now consistent for all rows and columns and simplified. ...

Hello, I will look into this in more depth later this evening. Br, Anders

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...