Dear Ankur Pandey
You cannot able to keep it in a single row If you have large amount of data.
Because Excel 2003 has only 256 columns and excel 2007 has only 16384
columns.
Thanks Regards
Thamu
On Thu, Jan 27, 2011 at 2:55 PM, ankur ankurpande...@gmail.com wrote:
hi excel experts
i need
thank you
On Wed, Jan 19, 2011 at 9:55 AM, Dave Bonallack
davebonall...@hotmail.comwrote:
Hi Aamir,
Have a look at the attached.
Regards - Dave.
--
Date: Tue, 18 Jan 2011 23:28:27 +0500
Subject: Re: $$Excel-Macros$$ Query
From: aamirshahza...@gmail.com
Hi Aamir,
Have a look at the attached.
Regards - Dave.
Date: Tue, 18 Jan 2011 23:28:27 +0500
Subject: Re: $$Excel-Macros$$ Query
From: aamirshahza...@gmail.com
To: excel-macros@googlegroups.com
Thanks for reply, now attached sheet is very clear.
Aamir Shahzad
On Tue, Jan 18, 2011 at 10
Sorry Aamir, Can't understand the question. If your worksheet had a cell with
the desired answer in it (entered manually) this may help me understand your
request.
Regards - Dave.
From: aamirshahza...@gmail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Query
Date: Mon, 17
check the attachment see if it helps you
On Tue, Jan 18, 2011 at 10:36 AM, Dave Bonallack
davebonall...@hotmail.comwrote:
Sorry Aamir, Can't understand the question. If your worksheet had a cell
with the desired answer in it (entered manually) this may help me understand
your request.
Dear Amir,
Pl provide more clarity wid complete example.
a href=http://www.signaturebar.com/img src=
http://www.signaturebar.com/uploads/images/24667.png border=0/a
On Tue, Jan 18, 2011 at 12:01 AM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Dear experts,
How to resolved attached
Is it possible that the names list were sorted ?
Then you may use :
=OFFSET($I$3,MATCH($E$3,$I$4:$I$17,0),1,COUNTIF($I$4:$I$17,$E$3))
as the source data.
Best regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Nikhil Shah
Envoyé : jeudi
Hi Nikhil,
Please find attached solved sheet.
Thanks Regards
Mukesh
On Thu, Dec 2, 2010 at 12:53 PM, Nikhil Shah nikhil201...@gmail.com wrote:
Dear All Members,
Here I am postin excel sheet..
*Problem :
*
*when I select the NAME I want the POLICY NOS. of that perticular
NAME only
On Thu, Dec 2, 2010 at 12:53 PM, Nikhil Shah nikhil201...@gmail.com wrote:
Dear All Members,
Here I am postin excel sheet..
*I used vlookup formula plz see attchmt
*
--
--
Some important links for excel
Dear Daniel
Thanks for FormulaYou have solve my problem..
Regards
Nikhil Shah
On Thu, Dec 2, 2010 at 5:20 PM, Daniel dcolarde...@free.fr wrote:
Is it possible that the names list were sorted ?
Then you may use :
=OFFSET($I$3,MATCH($E$3,$I$4:$I$17,0),1,COUNTIF($I$4:$I$17,$E$3))
as
Dear Nikhil,
Please find the attached file.
There is duplicate name if name is Unique ??
On Thu, Dec 2, 2010 at 5:20 PM, Daniel dcolarde...@free.fr wrote:
Is it possible that the names list were sorted ?
Then you may use :
Xls 2003
Select Data
Copy Data
Past Data
Past Only Filter Data
On Fri, Oct 15, 2010 at 2:04 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Experts,
Please solve my problem. How can we copy only filtered data in Excel.
--
Thanks in advance..
Noorain Ansari
--
Hi,
Please use Data Validation Select the Date option from Allow dropdown
and mention the start and end date in that.
If you are not satisfied with the above please send a sample data and
the group members will reply..
Thanks
Vinod N
On Sat, Jul 10, 2010 at 2:59 PM, Nikhil Shah
Hi Nikhil,
Try below formula:-
=DATE(YEAR(C3),MONTH(C3)-6,DAY(C3))
Note:- Day portion of Date may vary as per the exact calculation, please
revert if you need 31 or 30 as the date every time.
--
Thanks Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
Hi,
If original date is in A1:
=EOMONTH(A1,-6)
Regards - Dave.
Date: Wed, 7 Jul 2010 16:36:18 +0530
Subject: $$Excel-Macros$$ Query - How To Find out Month
From: nikhil201...@gmail.com
To: excel-macros@googlegroups.com
Hi Friends,
Here I am sending One Query, pl Give the formula..
Date :
You are welcome Nikhil..!!
--
Thanks Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Wed, Jul 7, 2010 at 6:17 PM, Nikhil Shah nikhil201...@gmail.com wrote:
Hi Dilip
Thanks for sending me
Assuming your current date is in a1 cell
=date(year(a1),month(a1)-6,day(a1))
Please let me know,if this works
On Wed, Jul 7, 2010 at 4:06 AM, Nikhil Shah nikhil201...@gmail.com wrote:
Hi Friends,
Here I am sending One Query, pl Give the formula..
Date : 31/03/2011 ( Format is
Hi
You can use the below formulae for calculation as required:
=EDATE(31-mar-2011,-6)
Regards
Rajender Soni
On Jul 7, 5:21 pm, Avinash Daga avinashdag...@gmail.com wrote:
Assuming your current date is in a1 cell
=date(year(a1),month(a1)-6,day(a1))
Please let me know,if this works
201 - 218 of 218 matches
Mail list logo
