[?][?][?][?]Congratulation [?] Sir[?][?][?][?]
On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote:
> Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> Jan'12
> He has posted 175 posts in Jan'12 and helped many people through his
> expertise. He
Dear Saurabh,
you can also use..
=IFERROR(LEFT(A2,SEARCH("_",A2,1)-1),A2)
See the attached sheet.
On Thu, Feb 2, 2012 at 3:59 PM, Saurabh Madhusudan Patel <
saurabh.pa...@in.aegisglobal.com> wrote:
> Hi,
>
> ** **
>
> I have list with the values. I need only text which comes before “*_*”.
Dear Sriram
Kindly find the attached file
On Thu, Feb 2, 2012 at 9:25 PM, sriram ji wrote:
>
>
>
> Dear Excel Guru,
>
> Kindly provide the solution for the attached file.
>
> Thanks & Regards,
> Sriram G
> Chennai
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use conc
go through the attachment
On Thu, Feb 2, 2012 at 9:25 PM, sriram ji wrote:
>
>
>
> Dear Excel Guru,
>
> Kindly provide the solution for the attached file.
>
> Thanks & Regards,
> Sriram G
> Chennai
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate th
Dear Saurabh
Kindly find the attached file
On Thu, Feb 2, 2012 at 3:59 PM, Saurabh Madhusudan Patel <
saurabh.pa...@in.aegisglobal.com> wrote:
> Hi,
>
> ** **
>
> I have list with the values. I need only text which comes before “*_*”.
> Please find attached herewith the file. I want the res
see the attached
=IF(ISERROR(LEFT(A2,FIND("_",A2)-1)),A2,LEFT(A2,FIND("_",A2)-1))
On Thu, Feb 2, 2012 at 3:59 PM, Saurabh Madhusudan Patel <
saurabh.pa...@in.aegisglobal.com> wrote:
> Hi,
>
> ** **
>
> I have list with the values. I need only text which comes before “*_*”.
> Please find a
Thanks...
2012/2/3 David Grugeon
> Sorry. My mistake. I must have changed the cell accidentally it should
> be =ROUNDUP(C34/2,0) similar to the ones below
>
> On 3 February 2012 13:57, Vijayendra Rao wrote:
>
>>
>>
>> Thanks David for correct answers. I understand everything except 4th
>> que
>
>
>> Dear Group
>>
>> One folder of some excel file is there ,every excel file has Time
>>
>> i nedd total folder excel file data copy 1 excel file but In start A
>> column i need Excel name how is it possible
>> plz find attachment of folder of excel files & Req data
>>
>
Bang on PERFECT.
Thanks very much Viper for the quick accurate response !!
On Feb 3, 12:09 am, The Viper wrote:
> in ab1
>
> =if(countif(a1:t1,aa1)>0,countif(a1:t1,aa1),"")
>
>
>
>
>
> On Fri, Feb 3, 2012 at 10:30 AM, qcan wrote:
> > Hi,
>
> > Not sure how to do this.
>
> > Looking for a formul
Hi,
I have list with the values. I need only text which comes before "_". Please
find attached herewith the file. I want the result shown in the highlighted
cell.
Required formula with out doing text to column.
Regards,
Saurabh Patel
DISCLAIMER:The information contained in this
in ab1
=if(countif(a1:t1,aa1)>0,countif(a1:t1,aa1),"")
On Fri, Feb 3, 2012 at 10:30 AM, qcan wrote:
> Hi,
>
> Not sure how to do this.
>
> Looking for a formula (preferably) or a macro to find a number in a
> row. Kind of like a "loto checker".
>
> In this case.
>
> - There are 20 columns
Hi,
Not sure how to do this.
Looking for a formula (preferably) or a macro to find a number in a
row. Kind of like a "loto checker".
In this case.
- There are 20 columns per row. (A1 to T1)
- Numbers are not neccesarily sorted.
- There could possibly be the same number showing up multiple t
Hi Expart,
Thank you very much for this help, SAM & Tran you've done great job.
Regards
Anjul
On Thu, Feb 2, 2012 at 10:26 PM, Bé Trần Văn wrote:
>
>
> 2012/2/2 dguillett1
>
>> You may?? be right and yours is great but did OP say that??
>>
>> Don Guillett
>> SalesAid Software
>> dguill
Sorry. My mistake. I must have changed the cell accidentally it should
be =ROUNDUP(C34/2,0) similar to the ones below
On 3 February 2012 13:57, Vijayendra Rao wrote:
>
>
> Thanks David for correct answers. I understand everything except 4th
> questions 1 row (row number 34), you have linked D5
Thanks David for correct answers. I understand everything except 4th
questions 1 row (row number 34), you have linked D50.
Regards,
Vijayendra
2012/2/3 David Grugeon
> Hi Vijayendra
>
> Regarding your answers
>
> 1. Right answer to the wrong question. The minimum negative value is
> -300 that
Simple stuff
Check that the footer says "page [page] of [pages]", not "page [page] of
7"
Go to the page setup dialog by using the tiny arrow in the corner of page
setup section on the page layout tab. On the Page tab of that check that
"start page numbering at" is set to Auto or 1.
check that
why, u want an invit?
On Feb 1, 10:12 pm, "dguillett1" wrote:
> Did you bathe today.
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Pascal Baro
> Sent: Wednesday, February 01, 2012 3:48 PM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ To excel macro team
>
Check with another 2 page document with footers starting at 1.
To me, it would have something to do with the settings of the footers.
On Feb 2, 7:33 pm, DaveO wrote:
> Troubleshooting a colleague's file: on a print-out he wants to show
> "Page X of Y" in the footer. The tab contains 5 pages of fo
Hi Vijayendra
Regarding your answers
1. Right answer to the wrong question. The minimum negative value is -300
that is less than -1. I think the question should have been the maximum
negative value which you answered correctly.
2. Your answer is fine. I had a different approach
3. You are
Continuation:
What I'm hoping to find is a specific way to learn which worksheets
have been grouped. I'm happy to build my own array: is there a boolean
that indicates whether a given sheet is selected? Maybe something
like...
dim TabName as worksheet
For each TabName in Sheets
if TabName.Select
In Excel, is there a VBA function or syntax that captures the contents
of the array that holds the sheet names of grouped sheets?
Thanks,
Dave O
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
One way may be to manually copy the data from the three columns, one
at a time, into a single column. In the column next to the Product #
column, write a formula to isolate the number:
=VALUE(MID(A2,FIND(" ",A2,1)+1,LEN(A2)-9))
where column A contains the list and 9 is the length of the word
"Produ
Troubleshooting a colleague's file: on a print-out he wants to show
"Page X of Y" in the footer. The tab contains 5 pages of formatted
material. Print preview shows "Page 7 of 5" and it appears that way on
paper as well. There are no hidden rows or columns; no conflicting
PrintArea named ranges; th
Dear Sir,
i nedd exactly one folder of excel file copt to one sheet & in that sheet
Column A i nedd sheet name
On Thu, Feb 2, 2012 at 8:52 PM, dguillett1 wrote:
> Are you saying:::
>
> I want to open every file in a certain folder>copy the data from sheet 1
> to my master file and then fill
2012/2/2 dguillett1
> You may?? be right and yours is great but did OP say that??
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Sam Mathai Chacko
> *Sent:* Thursday, February 02, 2012 9:37 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Cat
You may?? be right and yours is great but did OP say that??
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Thursday, February 02, 2012 9:37 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Category wise Count.
Didn't see you had posted one D
Didn't see you had posted one Don. I thought the solution intended was
without using the third column.
Sam
On Thu, Feb 2, 2012 at 9:05 PM, Sam Mathai Chacko wrote:
> Here's a formula based solution. No pivots
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Thu, Feb 2, 2012 at 5:23 PM, Lakshman Pras
Here's a formula based solution. No pivots
Regards,
Sam Mathai Chacko
On Thu, Feb 2, 2012 at 5:23 PM, Lakshman Prasad wrote:
> Dear anjul
>
> Plz See the attached file with your solution.
>
>
> *From:* Anjul Porwal
> *To:* excel-macros@googlegroups.com
> *Sent:* Thursday, 2 February 2012 4:5
Are you saying:::
I want to open every file in a certain folder>copy the data from sheet 1 to my
master file and then fill in col A with the name of the file or the name of
sheet1. Please tell us exactly what you want.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Veeru TOC
Se
=MAX(IF($A$2:$A$20=D2,$C$2:$C$20))
array formula so enter with ctrl+shift+enter>copy down
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Anjul Porwal
Sent: Thursday, February 02, 2012 5:22 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Category wise Count.
De
I have your file with the summary sheet and STILL do not know what you want
_ , where_and why ?
It should be fairly easy to help you if ??? we know what you want.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: hemal shah
Sent: Thursday, February 02, 2012 5:02 AM
Did you attach the correct file??
Don Guillett
SalesAid Software
dguille...@gmail.com
From: hemal shah
Sent: Thursday, February 02, 2012 1:52 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ sheet reference from cell
Dear Gurus,,
I create summary sheet based on other sheets from
Dear Darwin/ Bé Trần Văn,
Recently it will available in Excel Version 2003.
On Thu, Feb 2, 2012 at 5:18 PM, Bé Trần Văn wrote:
>
>
> 2012/2/2 Excel_Lover
>
>> great, Thanks for sharing..
>>
>>
>> On Wed, Feb 1, 2012 at 12:39 PM, Darwin Chan > > wrote:
>>
>>> Noorain,
>>>
>>> Is there
Dear anjul
Plz See the attached file with your solution.
From: Anjul Porwal
To: excel-macros@googlegroups.com
Sent: Thursday, 2 February 2012 4:52 PM
Subject: $$Excel-Macros$$ Category wise Count.
Dear Expart,
I want to count or category wise..pls help.
2012/2/2 Excel_Lover
> great, Thanks for sharing..
>
>
> On Wed, Feb 1, 2012 at 12:39 PM, Darwin Chan
> wrote:
>
>> Noorain,
>>
>> Is there any version for Excel 97 - 2003?
>>
>> Thanks~
>>
>>
>> 2012/2/1 NOORAIN ANSARI
>>
>>> In Excel 2007 Version
>>>
>>> On Wed, Feb 1, 2012 at 2:21 PM
Noorain, it is no wonder you are honored as most helpful so often.
Congratulations and thank you for your help.
John
On Thu, Jan 26, 2012 at 11:22 AM, NOORAIN ANSARI
wrote:
> Dear John,
>
> You can also use in F3...
>
>
> =INDEX(Data!$C$2:$C$37,MATCH(1,(Data!$A$2:$A$37=E3)*(Data!$B$2
Don, thanks again for your help and guidance.
John
On Thu, Jan 26, 2012 at 2:46 PM, dguillett1 wrote:
> The dates are sorted so the match is looking for the LAST matching
> date. Look in the help index for MATCH.
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Sourab
Thank you very much Rajan.
John
On Mon, Jan 30, 2012 at 12:44 PM, Rajan_Verma wrote:
> Use this
>
>
> =OFFSET(INDEX(Data!A:A,MATCH(Dashboard!E3,Data!A:A,0),1),2,MATCH(Dashboard!F2,Data!$A$1:$L$1,0)-1)
>
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googleg
hi
you have excell to pdf addin if you not download from below link
http://www.microsoft.com/download/en/details.aspx?id=9943
after you run macro will work
Regards
chandru
On Thu, Feb 2, 2012 at 3:44 PM, PrIyAnKa wrote:
> Kindly help for this
>
>
> On Wed, Feb 1, 2012 at 12:59 PM, PrI
Dear Sam
Please provide solution.
-- Forwarded message --
From: Shankar Bheema
Date: Tue, Jan 31, 2012 at 12:17 PM
Subject: Re: single active cell space between words
To: Sam Mathai Chacko
Good afternoon Sam,
Yes, exactly.
regards
shankar sb
On Mon, Jan 30, 2012 at 11:35
Dear Expart,
I want to count or category wise..pls help...for count.
Regards,
Anjul
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice wi
Hi
I can't attach the workbook here. In the meantime check the spelling of A2
value (any trailing or leading space).
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Pr
I vote for Noorain, yes - a superb guy with a expert thinking.
On 01/02/2012, Ayush Jain wrote:
> Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> Jan'12
> He has posted 175 posts in Jan'12 and helped many people through his
> expertise. He has bee
# ref error...
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a
Dear Group
One folder of some excel file is there ,every excel file has Time
i nedd total folder excel file data copy 1 excel file but In start A
column i need Excel name how is it possible
plz find attachment of folder of excel files & Req data
*Thanks&Regards*
* *
HI
In C2
=LOOKUP(2,1/(INDIRECT("'" &A2&"'!E3:E11")=B2),INDIRECT("'" &A2&"'!G3:G11"))
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need A
Really you are helpful, no prompt helpful, no full of helping nature.
Hearty congratulation !!!
On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote:
> Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> Jan'12
> He has posted 175 posts in Jan'12 and he
Hi,
There is no summary sheet in the attachment.
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or
Kindly help for this
On Wed, Feb 1, 2012 at 12:59 PM, PrIyAnKa wrote:
> Dear Rajan
>
> I m getting error in below part
>
>wksSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
> ThisWorkbook.Path & "\" & wksSheet.Name,
> Quality:=xlQualityStandard, _
>
DEAR MR. NOORAIN ANSARI,
CONGRATILATIONS Mr. Noorain.. I really appreciate you for the effort which
you taken to support others.its a great thing which u did through this blog
or group. so we are EXPECTING more and more knowledgeable spreads from you.
*Mr. Ayush jain Thanks a bunch* to create
Congrats..
*Thanks&Regards*
* *
* **Veerendra.Vanam*
*TOC TEAM*
* * *Bhagyanagar Electrical & Contractors**
** **H.No-5-9-286/65,Plot No-65
Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,
Hyderabad-500072,-Andhra Pradesh
** **91-9177-444-840**,*
On Thu, Feb 2,
KINDLY USE MY ATTACHED FILE AND HELP ME OUT THIS...
THANKS
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attentio
What does this return ?
=MAX(INDIRECT("'" &A2&"'!$D$2:$D$11"))
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
qu
Replace the A2 with the sheet name.
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be ans
Hi Experts,
I need formula (not macro code) to rearrange various column data in a
single column.
Sample file is attached herewith.
Regards,
Mukesh Kumar
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
U
#N/A ERROR...
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a
Hi
=VLOOKUP(MAX(INDIRECT("'" &A2&"'!$D$2:$D$11")),INDIRECT("'"
&A2&"'!$D$1:$G$11"),4)
adjust A2 with appropriate cell
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula P
=VLOOKUP(MAX('*EN8 BRIGHT DIA 28*
'!$D$2:$D$11),Indirect(A2,"!$D$1:$G$11"),4,0)
I dont want to EN8 Bright DIA 28.
I just want to use cell reference instead .
Thanks for your reply
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
Congrats Noorain! Your posts are very useful and informative. Thank you!
Must say thanks to these guys too.. Rajan, Sam, Don Guillett, Kris, Bheema,
Venkat, Chandru , Priyanka, Lokesh!
-Kiran
On Thu, Feb 2, 2012 at 11:33 AM, Lakshman Prasad wrote:
> Dear NOORAIN,
>
> It is a success, you truly
Noorain!![?][?][?][?][?]
Thumbs up!! Also cheers for the other contributors (Keep clapping hands)[?][?]
[?][?][?][?][?]
2012/2/2 yasir_shahjee
> Cong. Noorani
>
>
> On Thu, Feb 2, 2012 at 12:33 PM, PrIyAnKa wrote:
>
>> Congratulations Noorain
>>
>>
>> On Thu, Feb 2, 2012 at 5:27 AM, Asa
Cong. Noorani
On Thu, Feb 2, 2012 at 12:33 PM, PrIyAnKa wrote:
> Congratulations Noorain
>
>
> On Thu, Feb 2, 2012 at 5:27 AM, Asa Rossoff wrote:
>
>> Congratulations Noorain. Great work and contributions.
>>
>> Asa
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailt
Dear Hemal,
Please use formula with Indirect+Vlookup
*=VLOOKUP(MAX('EN8 BRIGHT DIA
28'!$D$2:$D$11),Indirect(A2,"!$D$1:$G$11"),4,0)*
On Thu, Feb 2, 2012 at 1:22 PM, hemal shah wrote:
> Dear Gurus,,
>
> I create summary sheet based on other sheets from in a workbook.
> In summary sheet, colum
Hi
In D2 and copied down,
=IF(SUMPRODUCT(--($A$2:A2&"|"&$B$2:B2=A2&"|"&B2))=1,C2*0.1,D1)
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need
63 matches
Mail list logo
