Forum Discussion
Excel formula assistance
I have a sheet that I import a daily ticket report from our corporate server. This report is unformatted and I have created a worksheet that I extract only the fields that I need. One field (Packin...
A picture may be worth a thousand words, but in the excel techcommunity a spreadsheet (sample) is worth even more. Could you upload such a sample...it's truly a lot more productive to work with that, than with an image, because there may be things not visible in the image that are affecting your results. Thanks
mathetes I have attached a sample of my spreadsheet. I do appreciate the assistance.
TeachASU2020 This is an older spreadsheet that I have been using. An associate of mine and I created the macros and formulas. He did most of the formulas that is why the code looks a little crazy. I was attempting to modify his code to get it to pull the correct number of digits regardless if there are 5 or 8 digits.