How to handle excel sheet with 5 lakh rows & above
this data is across 3 years & i need to create pviot table & review reports for my analysis purposes
How to handle excel sheet with 5 lakh rows & above
this data is across 3 years & i need to create pviot table & review reports for my analysis purposes
Hi and welcome to the forum.
Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.
Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Sounds like more of a job for a database software such as Access. That being said, a pivot table should be able to handle 500,000 rows of data. What are you having difficulty with?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks