User Profile
Harun24HR
Bronze Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Re: Regrouping Data in single row
Thank you sir for noticing my answer. Can you please explain problem of filtering rows to drop null strings so that I can aware for future to use the formula? Your formula is too advanced to hard to catch in brain. I will study your formula to understand.15Views0likes1CommentRe: Why does Excel STILL automatically remove zeroes at the start of numbers I export into the program?
Why not you type a single quote in-front of 102320241016. Just write '102320241016 so Excel will not convert it scientific numbers. I would suggest you learn Excel first then start to use it. Tell your barcode software designer to export data as text instead of numbers. Don't blame Excel rather blame to barcode software.20Views0likes0Comments- 29Views0likes0Comments
Re: new people only from array
First apply both formula to your sample data as shown on screenshot. Also, you may test on my Excel sheet that I have attached to my answer. Then observe result you got and compare which formula gibe you correct result. Then apply the correct formula to your actual dataset.45Views0likes2Comments