User Profile
ajmal_pottekattil_yoousuf
Iron Contributor
Joined Jun 18, 2018
User Widgets
Recent Discussions
Splitting Long Text into Different Columns in Excel
I have a challenge that I am hoping to get some assistance with. In Sheet 3 of my Excel workbook, I have a large dataset where the text is in a long format within a single column. I need to split this text into different columns in Sheet 1 to better organize my data and improve readability.Pivot Table Yearly Sales Report Issue
I'm currently working on creating a pivot table for a yearly sales report. However, I'm encountering an issue where, after a particular row, the year is not being recognized. This results in an error. Can someone please explain why this might be happening and guide me on how to resolve it? Additionally, is there a way to directly convert the date to year within the pivot table without having to separately convert the date to year first and then use the pivot table?Validate the data logger data
Here the data is downloaded from the data Logger We want to check the pass or fail Allowable limit is given below the picture Is it possible to check the readings are within the limit or out of limit please guide me how to solve In time hours 2 hours + 20 hours = 22 hour 2 hours + 20 hours+ 12 hour =34 hours
