please help me how to use pivot table, vlookup and hlookup in MSEXL. Please send with example in EXL sheet.
I hope you have searched for simiular postings in thie site, \please follow this link, you'll find a useful presentation posted by AS Senthil Kumar
Vlookup N Pivot Table(plz Need Help) Docx Download
In this case if you will use pivot in less than minute you will get the data arranged as you require.
Vlookup & Hlookup are functions defined in excel which will help to find records from one table to another by horizontally & vertically. But it has some conditions which needs to satisfy. Go through the excel help for the conditions. function alias @vlookup(reference of data which need to find, reference table where reference data can be find,result column number, else zero).
Why Vote? User validation is extremely important for good content to prosper.