gt;> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *thameem
>> *Sent:* 27 June 2013 11:15
>>
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Plz help me to sol
e type will compress the data
> in lowest possible size.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *thameem
> *Sent:* 27 June 2013 11:15
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Exce
2013 11:15
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Plz help me to solve this prob
getting error as excel cannot complete this task with available resources.
choose less data or close other applications
On Thu, Jun 27, 2013 at 9:42 AM, Amit Desai (MERU)
mailto:amit.de...@me
y columns can be removed by shift + Control + Right Arrow & Delete.
>
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *thameem
> *Sent:* 27 June 2013 11:07
>
> *To:* excel-macros@googlegroups.com
> *Subjec
l-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Plz help me to solve this prob
Is any possibility to delete unused cells in row and column, so i can reduce
load, present am using 3000 rows and 40 columns rest all rows and coloumns are
empty, thank you for ur support.
On Thu, Jun 27, 2013 at 9:33
hameem
> *Sent:* 27 June 2013 10:49
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Plz help me to solve this prob
>
> ** **
>
> Thank you, i will follow your step, but is any other solution for this?
> plz tell me, y this prob occurs
Sent: 27 June 2013 10:49
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Plz help me to solve this prob
Thank you, i will follow your step, but is any other solution for this? plz
tell me, y this prob occurs, so i can take precautions in any other files.
On Thu, Jun 27, 2013 at
Thank you, i will follow your step, but is any other solution for this?
plz tell me, y this prob occurs, so i can take precautions in any other
files.
On Thu, Jun 27, 2013 at 9:14 AM, Amit Desai (MERU)
wrote:
> In this case, you should do as follows;
>
> ** **
>
> In case if you wants to d
In this case, you should do as follows;
In case if you wants to delete all the contents of raw, select all the cells of
that raw from first to last till the column heads are there, right click with
mouse, select on Delete, on asking where to shift the below cells select "shift
cells up". You wi
When requesting help
use a meaningful subject line
explain in the post and in the file what you want where, from where, and why,
You sent a file and expected all to read your mind.
A look in the help index for COUNTIF would be helpful
Oh heck, HERE
=COUNTIF(Report!I:I,C5)
Don Guillett
Mi
PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ plz, help me to drive out this sort of
problem!
Try this.
B8
=IF(INDEX($H$1:$H$1794,MATCH(chik,$H$1:$H$1794,0)+ROW()+8)=chik,INDEX($H
$1:$H$1794,MATCH(chik,$H$1:$H$1794,0)+ROW()+8),"")
C8
=IF(INDEX($H$1:$H$1794,MAT
Hi Anil,
We can also use Hyperlink in the same workbook to go Other sheet or other
cell,
Select a Cell and press Ctrl+k, Choose Place in this document ,
A list will show with the name of all sheets present in the Workbook , You
can select any Sheet to Make Hyperlink
Thanks
Rajan
From
Hi,
I just replied to this post, but wonder where that gone.
Anil, please wait for some time and search that again. Let me know if
you do not find the same, I'll send another one.
Regards,
DILIPandey
On 8/4/11, Anil Saxena wrote:
> Hi All,
> Plz find the attached file and solved this query.
> H
Dear Anil,
MS word did not have pivot table function , but you can use them by
insert excel object and use pivot table same as Excel.
2010/6/23 Anil Saxena
> Dear Sir / Mam,
>
>
> Do the create the excel pivot table in to MS world without copy past and
> show the example ?
>
> --
>
> --
Dear Mr. Parab,
Thanks for the help.
Actully you have solved a big problem of mine.
Thanks again
Regards
Vishal Gupta
On Sun, Jun 6, 2010 at 10:58 PM, Mahesh parab wrote:
> Hi Vishal
>
> follow below mention steps
>
>1. Select your column A:A
>2. Go to Data Validation
>3. Click on s
Hi Vishal
follow below mention steps
1. Select your column A:A
2. Go to Data Validation
3. Click on settings
4. Choose custom from drop down list
5. Enter the formula as =IF(COUNTIF(A:A,A1)>1,FALSE,TRUE)
6. Click Error Alert tab , check or select show error alert box
7. choos
On Fri, Apr 9, 2010 at 11:41 AM, Anil Saxena wrote:
> Hi Sir,
> plz help me and Show the Formula
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twit
Hello dear
Please find the attached solution.
Chandra Gupta Maurya
On Fri, Apr 9, 2010 at 11:41 AM, Anil Saxena wrote:
> Hi Sir,
> plz help me and Show the Formula
>
> --
>
> --
> Some important links for excel user
Hi Anil,
Please find attached excel for solution.
Regards,
Swapnil.
On Fri, Apr 9, 2010 at 11:41 AM, Anil Saxena wrote:
> Hi Sir,
> plz help me and Show the Formula
>
> --
>
> --
> Some important links for excel us
Hello Dear,
I have check it and find great.It's working nice
great work.
On Wed, Apr 7, 2010 at 4:56 AM, Harmeet Singh wrote:
> Good one guyz nice to see such creative formulas, here is my share of
> knowledge.
> Kindly check out the index match function without adding additional colu
Good one guyz nice to see such creative formulas, here is my share of
knowledge.
Kindly check out the index match function without adding additional column.
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Tue, Apr 6, 2010 at 4:59 PM, Born to Win wrote:
> your welcome.
>
>
your welcome.
Thanks,
Chandrabhan Singh
9911255330
On Tue, Apr 6, 2010 at 3:57 PM, Anil Saxena wrote:
> Thanks Lot Chandrabhan Singh Ji
>
>
>
> On Tue, Apr 6, 2010 at 2:24 PM, Born to Win wrote:
>
>> Dear Mr. Saxena,
>>
>> Please find Attached file.
>>
>> Thanks,
>> Chandrabhan Singh
>> 991125
Thanks Lot Chandrabhan Singh Ji
On Tue, Apr 6, 2010 at 2:24 PM, Born to Win wrote:
> Dear Mr. Saxena,
>
> Please find Attached file.
>
> Thanks,
> Chandrabhan Singh
> 9911255330
>
>
>
> On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena wrote:
>
>>
>>
>> Hi Dilip
>>> plz do the needful it is urgent
>>
Dear Anil Saxena
Find attached solution to your problem. Hope this suffies
Regards
Sivakumar ES
On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena wrote:
> Hi Dilip
> plz do the needful it is urgent
>
> I want the same ans match with ID and Questions ?
>
> Plz Sir show the Formula also
>
>
>
>
> Re
You're welcome Anil.
On Tue, Apr 6, 2010 at 2:09 PM, Anil Saxena wrote:
> Thanks to Lot Abhishek Ji
> about help me thanks
>
>
> On Tue, Apr 6, 2010 at 1:55 PM, Abhishek Jain wrote:
>
>> Dear Anil,
>>
>> Please see the attached file. I've used an array formula. Press
>> Ctrl+Shift+Enter while app
Dear Mr. Saxena,
Please find Attached file.
Thanks,
Chandrabhan Singh
9911255330
On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena wrote:
>
>
> Hi Dilip
>> plz do the needful it is urgent
>>
>> I want the same ans match with ID and Questions ?
>>
>> Plz Sir show the Formula also
>>
>>
>>
>>
>> Regar
Thanks to Lot Abhishek Ji
about help me thanks
On Tue, Apr 6, 2010 at 1:55 PM, Abhishek Jain wrote:
> Dear Anil,
>
> Please see the attached file. I've used an array formula. Press
> Ctrl+Shift+Enter while applying it. Also to ease the formula, I've defined
> the range names.
>
> Let me know if y
Dear Anil,
Please see the attached file. I've used an array formula. Press
Ctrl+Shift+Enter while applying it. Also to ease the formula, I've defined
the range names.
Let me know if you need any further help on this.
Dilip's friend... :)
Abhishek
On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena wr
check it if this helps u
On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena wrote:
>
>
> Hi Dilip
>> plz do the needful it is urgent
>>
>> I want the same ans match with ID and Questions ?
>>
>> Plz Sir show the Formula also
>>
>>
>>
>>
>> Regards
>>
>> Anil Saxena
>>
>> --
>>
>> ---
Hi Dilip
> plz do the needful it is urgent
>
> I want the same ans match with ID and Questions ?
>
> Plz Sir show the Formula also
>
>
>
>
> Regards
>
> Anil Saxena
>
> --
>
> --
> Some important links for excel users:
30 matches
Mail list logo
