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 Advice
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 hemali...@gmail.com wrote:
Dear Gurus,,
I create summary sheet based on other sheets from in a workbook.
In
Cong. Noorani
On Thu, Feb 2, 2012 at 12:33 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:
Congratulations Noorain
On Thu, Feb 2, 2012 at 5:27 AM, Asa Rossoff a...@lovetour.info wrote:
Congratulations Noorain. Great work and contributions.
Asa
** **
*From:*
Noorain!![?][?][?][?][?]
Thumbs up!! Also cheers for the other contributors (Keep clapping hands)[?][?]
[?][?][?][?][?]
2012/2/2 yasir_shahjee yasir.shah...@gmail.com
Cong. Noorani
On Thu, Feb 2, 2012 at 12:33 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:
Congratulations Noorain
On
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 lakshman...@yahoo.comwrote:
Dear NOORAIN,
It is a
=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
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 Problem,
#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
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,
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
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
quick
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
Congrats..
*ThanksRegards*
* *
* **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,
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
Kindly help for this
On Wed, Feb 1, 2012 at 12:59 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:
Dear Rajan
I m getting error in below part
wksSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
ThisWorkbook.Path \ wksSheet.Name,
Quality:=xlQualityStandard, _
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
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 jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Jan'12
He has posted 175 posts
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 Advice will
# 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
I vote for Noorain, yes - a superb guy with a expert thinking.
On 01/02/2012, Ayush Jain jainayus...@gmail.com 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
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
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
Dear Sam
Please provide solution.
-- Forwarded message --
From: Shankar Bheema shankar.n...@gmail.com
Date: Tue, Jan 31, 2012 at 12:17 PM
Subject: Re: single active cell space between words
To: Sam Mathai Chacko samde...@gmail.com
Good afternoon Sam,
Yes, exactly.
regards
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 p.dhamsa...@gmail.com wrote:
Kindly help for this
On Wed, Feb 1,
Thank you very much Rajan.
John
On Mon, Jan 30, 2012 at 12:44 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
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:
Don, thanks again for your help and guidance.
John
On Thu, Jan 26, 2012 at 2:46 PM, dguillett1 dguille...@gmail.com 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
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
noorain.ans...@gmail.comwrote:
Dear John,
You can also use in F3...
2012/2/2 Excel_Lover idforex...@gmail.com
great, Thanks for sharing..
On Wed, Feb 1, 2012 at 12:39 PM, Darwin Chan
darwin.chankaw...@gmail.comwrote:
Noorain,
Is there any version for Excel 97 - 2003?
Thanks~
2012/2/1 NOORAIN ANSARI noorain.ans...@gmail.com
In Excel 2007
Dear anjul
Plz See the attached file with your solution.
From: Anjul Porwal porwalan...@gmail.com
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
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 betnmtdongna...@gmail.comwrote:
2012/2/2 Excel_Lover idforex...@gmail.com
great, Thanks for sharing..
On Wed, Feb 1, 2012 at 12:39 PM, Darwin Chan
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
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
=MAX(IF($A$2:$A$20=D2,$C$2:$C$20))
array formula so enter with ctrl+shift+entercopy 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.
Are you saying:::
I want to open every file in a certain foldercopy 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
Here's a formula based solution. No pivots
Regards,
Sam Mathai Chacko
On Thu, Feb 2, 2012 at 5:23 PM, Lakshman Prasad lakshman...@yahoo.comwrote:
Dear anjul
Plz See the attached file with your solution.
*From:* Anjul Porwal porwalan...@gmail.com
*To:* excel-macros@googlegroups.com
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 samde...@gmail.comwrote:
Here's a formula based solution. No pivots
Regards,
Sam Mathai Chacko
On Thu, Feb 2, 2012 at 5:23 PM,
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
2012/2/2 dguillett1 dguille...@gmail.com
You may?? be right and yours is great but did OP say that??
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Sam Mathai Chacko samde...@gmail.com
*Sent:* Thursday, February 02, 2012 9:37 AM
*To:* excel-macros@googlegroups.com
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 dguille...@gmail.com wrote:
Are you saying:::
I want to open every file in a certain foldercopy the data from sheet 1
to my master file
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; the
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
Product
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,
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
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 dmo...@gmail.com wrote:
Troubleshooting a colleague's file: on a print-out he wants to show
Page X of Y in the footer. The tab contains
why, u want an invit?
On Feb 1, 10:12 pm, dguillett1 dguille...@gmail.com 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
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 the
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 grug...@gmail.com
Hi Vijayendra
Regarding your answers
1. Right answer to the wrong question. The minimum negative value
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 vijayendrar...@gmail.com wrote:
Thanks David for correct answers. I understand everything except 4th
questions 1 row (row number
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 betnmtdongna...@gmail.comwrote:
2012/2/2 dguillett1 dguille...@gmail.com
You may?? be right and yours is great but did OP say that??
Don
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
in ab1
=if(countif(a1:t1,aa1)0,countif(a1:t1,aa1),)
On Fri, Feb 3, 2012 at 10:30 AM, qcan comeonove...@gmail.com 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
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
Bang on PERFECT.
Thanks very much Viper for the quick accurate response !!
On Feb 3, 12:09 am, The Viper viper@gmail.com wrote:
in ab1
=if(countif(a1:t1,aa1)0,countif(a1:t1,aa1),)
On Fri, Feb 3, 2012 at 10:30 AM, qcan comeonove...@gmail.com wrote:
Hi,
Not sure how to do this.
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...
2012/2/3 David Grugeon da...@grugeon.com.au
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 vijayendrar...@gmail.com wrote:
Thanks David for correct answers. I
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 attached
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 result
go through the attachment
On Thu, Feb 2, 2012 at 9:25 PM, sriram ji sriramg...@gmail.com 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,
Dear Sriram
Kindly find the attached file
On Thu, Feb 2, 2012 at 9:25 PM, sriram ji sriramg...@gmail.com 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
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 “*_*”.
Please
[?][?][?][?]Congratulation [?] Sir[?][?][?][?]
On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain jainayus...@gmail.com 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
61 matches
Mail list logo