User Profile
ajmal_pottekattil_yoousuf
Iron Contributor
Joined 8 years ago
User Widgets
Recent Discussions
- 167Views1like7Comments
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.160Views0likes3CommentsPivot 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?146Views0likes2Comments- 216Views1like0Comments
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 hours437Views0likes1Comment- 2.5KViews0likes0Comments
Extract the text value
Exacting the range and readability from the instrument type How to extract it please guide me i filter the data( please refer the other sheet) and try to extract. In this method is correct or not is it possible to extract data by using regex extract functionSolved3.2KViews0likes11CommentsHow to find the duplicate
CASINETTO TRADING LLC , PO BOX : 125905 , DUBAI , UAE CASINETTO TRADING LLC, PO BOX: 125905, DUBAI, UAE In this condition, both customers are the same. In conditional formatting, the duplicate is used. But conditional formatting duplicate is not working550Views0likes1Comment
Recent Blog Articles
No content to show