Hello,
There is walk-in in AON Hewitt on Saturday..
Please share your resume to puneet.rawa...@aonhewitt.com and mention Refer
By: Pankaj Sangotra
Role: Business Analyst / Data Analyst
Experience: 0 - 4
Expertise: Excel, VBA, Access, SQL
Venue: Noida 127 Express Highway
Thanks!!
Pankaj
Why not you are using MS Access. It's pretty cool and can we use easy..
this is best for if some one have to work in large data
Pramod
On 28 Apr 2015 15:41, Mandeep Baluja rockerna...@gmail.com wrote:
Yes it works, Thanks for the same we can considered this issue is
resolved. But one thing
I think you should move and grab the opportunity...
Send your resume to Puneet AON HR... All the Best buddy!!
On Wed, Apr 29, 2015 at 6:03 AM, Nasir Saikh nasirsa...@gmail.com wrote:
Hi Pankaj,
As per your post I am looking for job and I think I ll suitable for your
expectation.
And I have
Hi Pankaj,
As per your post I am looking for job and I think I ll suitable for your
expectation.
And I have lot of experience about Advance Excel, VBA , Access but I have
worked on SQL but I know some queries like select , update, append, make
table, ,making database, new users access etc.
r8 Pramod access is very easy and taking very less time than excel on huge
data you can use it till 2 GB data.
On Tuesday, April 28, 2015 at 11:34:45 AM UTC+5:30, Mandeep Baluja wrote:
My mmaster file is large and i just want to do lookup on my sheet from
master file without opening my
Hi Excel Beginner,
I want your help in converting the date in two columns in Excel.
If in one column(A1) I will enter Hijri Date the next column(B1) should be
changed to English date.
Please help me to solve this problem
Thanks Regards,
Sumesh Nair
On Tuesday, September 25, 2012 at
Excel 2010 and file is on the same machine. Vabz I know the procedure to
get the data from excel file but here my file is always large and opening
will take a lot of time .
On Tuesday, April 28, 2015 at 11:59:45 AM UTC+5:30, Vabz wrote:
Which version of excel you are using?
Are both file
My mmaster file is large and i just want to do lookup on my sheet from
master file without opening my master file as it is of huge mb around 250
mb or more than that. any ideas
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official
Yes it works, Thanks for the same we can considered this issue is resolved.
But one thing Excel is not useful for large files On Daily basis I got
files of 350 mb having data of 2-3 lakh rows and I am unable to combine the
same jjust because excel not responds.
On Tuesday, April 28, 2015 at
Hi Mandeep
As per my suggestion you can use table link vloopup as I am using and it is
working fine. Example is given below.
Sub LoopUp()
Dim iRow As Integer
Dim MaxRow As Long
MaxRow = ActiveSheet.Range(A Rows.Count).End(xlUp).Row
Range(B2).FormulaR1C1 =
Sub Getvalues()
Dim r As Range
lr = ActiveSheet.Cells(Rows.Count, 2).End(xlUp).Row
Set Rng = Sheets(Sheet1).Range(B2:B lr)
For Each cell In Rng
If cell.Value Like *LF* Then
cell.Offset(0, 1) = 0
Else
cell.Offset(0, 1) = 1
End If
Next
On Error Resume Next
Which version of excel you are using?
Are both file on same machine or they are on Network?
On Tue, Apr 28, 2015 at 11:34 AM, Mandeep Baluja rockerna...@gmail.com
wrote:
My mmaster file is large and i just want to do lookup on my sheet from
master file without opening my master file as it is
Dear it's not working, please check the file...i have deleted the LF
records but coding is not doing copy and paste exactly correct location to
other data!!!
You can check!!!
i m sending you both filekindly give me one coding which will be work
on both data without error.
--
Thanks
13 matches
Mail list logo