any Microsoft MsExcel expert here ??? need a little help

[Mr India]

have 2 sets of data as shown in pic. both sets have a common row of data field as shown in example . i wanna combine so i can see the two values column side by side or like i showed in pic. any help ? have forgot all that vlookup, arrays now

 

[Criminal]

have forgot all that vlookup, arrays now

vlookup is the answer. do you want the formula?

 

[Mr India]

got it , there was a format error in date so the formula wasnt working. now solved !

 

[babhishek]

this is basic excel

 

[Mr India]

Another follow up question. how do i optimize my laptop to run excel well. i have files usually over 5-10 mb in excel with lakhs and lakhs of data cells. using heavy formulaes it hangs sometimes and freezes . what to do ? its a core i5 with 4gb ram. cant upgrade , any way to optimize settings etc.

 

[nimod]

Excel is not for handling millions of data.
Upgrading the hardware won't help.

 

[Striker10]

Upgrading RAM will help no?

 

[nimod]

Required if Memory Manager is using Paging.
OP needs to check this.

 

[asingh]

Another follow up question. how do i optimize my laptop to run excel well. i have files usually over 5-10 mb in excel with lakhs and lakhs of data cells. using heavy formulaes it hangs sometimes and freezes . what to do ? its a core i5 with 4gb ram. cant upgrade , any way to optimize settings etc.

Those files are way too overloaded. Most you can do, is some how open the files, and paste over the formulas ---> data.

 

[Criminal]

i have files usually over 5-10 mb in excel with lakhs and lakhs of data cells. using heavy formulaes it hangs sometimes and freezes . what to do ?

try saving one of those huge files as .xlsb and compare the overall performance, file size etc with the original.

xlsb (Excel Binary Workbook) format is meant for performance.

there are disadvantages of using this format but you won't come across any in your job.

 

[gizmoholic]

IF you Pivot with that kind of data, use the PowerPivot addon. It is meant to handle billions of lines of data. I think it is a free add-on with Excel 2013.

 

[rakesh_ic]

A RAM upgrade will definitely help in freezing issues and since the excels are meant to take upto 10L records, a couple of lakhs should still be fine provided you upgrade the RAM.

Also try optimizing the formulas and use macros/VB scripting to better manage complex calculations/nested formulas.