Hi all,
I have a text file which is system generated. And I want to import the data from this text file to Excel in the manner as displayed in the screenshot of the excel ****. I want the Average of the number mentioned from Q3-06= X to Q3-10= X.
But the problem is the I could not find the Average as its not purely a Numeric data, and also not sorted out like what I need.
I need help to find these average numbers using any farmula or script. Pls help.
Thanks a lot in Advance.
(I have attached both Source file and the mentioned screenshot of excel sheet)
Source file: EXCEL.jpg
ScreenShot file: Sur.txt
Bookmarks