thnks rajan this is what i needed
this is really very nice of youit ease my work load...
now one more queryin attached file...sheet gents reportcell
C2 value should get pasted in sheet gents...in the front of row
having staff no..
example is shown..if income tax calculation
Hi,
Please can u expalin in steps how to do this. Thanks!
On Tue, Jun 28, 2011 at 9:08 AM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hi,
Thanks its working fine. Please can u explain in steps how to do this.
On Mon, Jun 27, 2011 at 6:59 PM, Sam Mathai Chacko
Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Mon, Jul 4, 2011 at 12:08 PM, ankur ankurpande...@gmail.com wrote:
file attachedagain forget to attach file
Have A Nice Time Enjoy Life
Regards:
CMA Ankur
Dear Members,
with reference to the above dear member i want a excel sheet. Earlier i have
downloaded a sheet that updates automatically bse and nse prices. Similary
is there any way by which when i would run macro the LME prices and
Commodities Prices update automatically.
May be its a
Hi Susan,
The result calculated is 2 which is correct as only two rows, mentioned
below, are having the results (i.e., 1) as per your criteria :-
row # 5 of sheet1
row #16 of sheet 2
Now, some of our group members have also provided more power packed
formulas, using which you can get your query
Hi,
i want to count unique values in a selection. I got this formula on
net =SUMPRODUCT((B2:B30)/COUNTIF(B2:B30,B2:B30)) but i dont
know how it works. So please help me understand this formula.
--
--
Some important
Formula needed please.
--
Nemi Gandhi
98204 92963
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
Dear All,
Did anybody build a XBRL Creator in Excel to create a Instance Documents for
MCA filings.
- Tarun Masani
--
Virus Warning: Although our firm has taken reasonable precautions to ensure
no viruses are present in this email, the firm cannot accept responsibility
for any loss or damage
Hi,
Attach Some data ..and send will try..
*Best Regards,*
*Venkat*
*
*
On Mon, Jul 4, 2011 at 3:47 PM, airen airen1...@gmail.com wrote:
Hi,
i want to count unique values in a selection. I got this formula on
net =SUMPRODUCT((B2:B30)/COUNTIF(B2:B30,B2:B30)) but i dont
know how it
Dear All,
Did anybody build a XBRL Creator in Excel to create a Instance
Documents for MCA filings.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
How to use this software?
Thanks,
Chandra Shekar B
On Fri, Dec 24, 2010 at 11:56 AM, Venkat venkat1@gmail.com wrote:
Dear Saijt,
Find below LinkDownload Software Install,It may Help you...
http://www.excel-tool.com/vbarecovery.html
*Best Regards,*
**
*Venkat CV*
On Thu, Dec 23,
Hi All
No boss this is also not working see i show you what excatly i want
202.718
198.724
200.178
202.867
195.514
Total 1000.000
this is i want that random unique numbers between 195.001 to 203.999 which
always gives a total of 1000.000 after every total of 5 numbers
Help me
No worries Susan... you are always welcome..!!
Regards,
DILIPandey
On 7/4/11, Susan sunni...@gmail.com wrote:
Dilip,
I apologize…… after recalculating my sheets I see that it worked J.
Thank you to everyone else..for your insights.
Appreciate it!
Sunnie
From: Dilip Pandey
try this
Option Base 1
Sub nemi()
Dim s(5) As String
Dim z As Long
s(1) = Very Good
s(2) = Good
s(3) = Better
s(4) = Bad
s(5) = Very Bad
For i = 1 To 5
On Error Resume Next
Sheets(1).ShowAllData
z = Sheets(1).Range(f65356).End(xlUp).Row + 1
Sheets(1).Range($A$3:$e$
try this link
http://www.exceltip.com/st/Counting_Unique_Numeric_Values_or_Unique_Data_in_a_List_/818.html
Dave has explained it in detail
On Mon, Jul 4, 2011 at 6:15 PM, Venkatesan c venkat1@gmail.com wrote:
Hi,
Attach Some data ..and send will try..
*Best Regards,*
*Venkat*
try it...
=sum(1/countif(B2:B30,B2:B30)) and press ctrl+shift+Enter
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Mon, Jul 4, 2011 at 3:47 PM, airen airen1...@gmail.com wrote:
Hi,
i want to count unique values in a selection.
Hi allI choose a specific Column Such as X Column and when one cell change it's
return a value in another cell in another column.now i need to make Auto-fill
or Clear Content to act on all row content, plz see the attachment
Best regards,
Ahmed
galal Mohamed
Procurement
Engineer
Dilip,
I apologize…… after recalculating my sheets I see that it worked J.
Thank you to everyone else..for your insights.
Appreciate it!
Sunnie
From: Dilip Pandey [mailto:dilipan...@gmail.com]
Sent: Monday, July 04, 2011 3:27 AM
To: excel-macros@googlegroups.com
Cc:
Hi
just install the software and just open that software and click Remove
Password...Before that you have to open
Locked VBA Book..
--
*Best Regards,*
*Venkat*
*
*
On Mon, Jul 4, 2011 at 6:32 PM, Chandra Shekar chandrashekarb@gmail.com
wrote:
How to use this software?
Thanks,
What help do you need in this macro??
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rash
Sent: Monday, July 04, 2011 10:25 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Excel VBA for BOM
Hi,
With some more detailed
Hi ankur
Attachment Not Found..
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ankur
Sent: Monday, July 04, 2011 11:53 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ need required for data validation value
Hi guys, i have a pivot table that is feeded through another workbook,
then i calculate the rest of the pivot with the option Calculated fields
but i have a problem, each time i open the 2 workbooks and make refresh, my
calculated fields disappear leaving #NAME in the cells, and i have to do
the
try this see if it helps
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 19 And Target.Count = 1 Then
Select Case Target.Value
Case A
Target.EntireRow.Interior.Color = RGB(192, 192, 192)
Case B
Target.EntireRow.Interior.Color = RGB(0, 0, 255)
Case C
You should attached all Sheets so that I can Link Main Sheet with each
other.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ankur
Sent: Monday, July 04, 2011 2:06 PM
To: excel-macros@googlegroups.com
Subject: Re:
have you changed name of a name range used in the formula
On Mon, Jul 4, 2011 at 9:23 PM, Jorge Marques leote.w...@gmail.com wrote:
Hi guys, i have a pivot table that is feeded through another workbook,
then i calculate the rest of the pivot with the option Calculated fields
but i have a
Hi Anshul,
As per the latest scenario provided by you, attached solution may help you.
Let me know if this works :)
Regards,
DILIPandey
On 7/4/11, Anshul Gupta thatsme.a...@gmail.com wrote:
Hi All
No boss this is also not working see i show you what excatly i want
202.718
198.724
200.178
Thanks for getting the award. Even though, i am very new to this group,
I proudly wishes to keep this spirit high always,
Have a nice day
with best wishes,
Regards,
Hari
On 1 July 2011 21:25, Ayush jainayus...@gmail.com wrote:
Dear Group,
I am extremely happy to share a good news with you.
Mmm i checked the range, and everything is ok, even if i open the pivot
workbook and choose the source range again, it gives the same error when i
do refresh data :(, gives #NAME, and also on the list formulas appears
#NAME.
2011/7/4 ashish koul koul.ash...@gmail.com
have you changed name of a
I'll explain what the problem:-try to pull + for cell to auto fill code like
A into 3 cells down it will return error, also if u select more than one cell
including codes and delete selection contents it returns error also.
Date: Mon, 4 Jul 2011 21:27:49 +0530
Subject: Re: $$Excel-Macros$$
can you share the workbooks
On Mon, Jul 4, 2011 at 9:44 PM, Jorge Marques leote.w...@gmail.com wrote:
Mmm i checked the range, and everything is ok, even if i open the pivot
workbook and choose the source range again, it gives the same error when i
do refresh data :(, gives #NAME, and also on
try this code-
Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range
Dim abc As Range
If Target.Column = 19 Then
Set abc = Range(s Target.Row :s Target.Row + Target.Rows.Count)
For Each cell In abc
Select Case cell.Value
Case A
cell.EntireRow.Interior.Color = RGB(192, 192,
Hi Ashish,
Many many congrats...
With best wishesh,
Seraj Alam
On Mon, Jul 4, 2011 at 9:40 PM, Hari harisha.prabha...@gmail.com wrote:
Thanks for getting the award. Even though, i am very new to this group,
I proudly wishes to keep this spirit high always,
Have a nice day
with best
Excellent ashish, it's work nowthanks a lot
Best regards,
Ahmed
galal Mohamed
Procurement
Engineer
Head
Office : SQUARE Engineering Firm
Tel :(202) 2402 8846
Fax :(202) 2405 0476
Mobile :(010) 9 62 60 61
Website : http://www.square.com.eg
31 Lebanon St. Mohandsen,
Giza,
Hello Everyone,
Ashish Koul has been selected as 'Most Helpful Member' for the month of
June'11
He has posted 53 posts in June 2011 and helped many people through his
expertise. He has been consistent contributor to this excel forum and
achieved this recognition from last seven months
Hi Airen,
This is the beauty of SumProduct function.
Below is the explanation:-
If you evaluate the formula in parts, you will get following look:
Congratulations Ashish...!! you Rock :)
Regards,
DILIPandey
On 7/4/11, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Ashish Koul has been selected as 'Most Helpful Member' for the month of
June'11
He has posted 53 posts in June 2011 and helped many people through his
Congratulations Ashish, you deserve it.
Best regards,
Ahmed
galal Mohamed
Procurement
Engineer
Head
Office : SQUARE Engineering Firm
Tel :(202) 2402 8846
Fax :(202) 2405 0476
Mobile :(010) 9 62 60 61
Website : http://www.square.com.eg
31 Lebanon St. Mohandsen,
Giza,
Hey Boss,
Congratulation.
On Sun, Jul 3, 2011 at 8:15 PM, ashish koul koul.ash...@gmail.com wrote:
Thank You All..
On Sat, Jul 2, 2011 at 10:37 AM, Brajesh Kumar Porwal
brajeshkumarpor...@gmail.com wrote:
*Congratulations Ashish
Hey,
try my attachment
i think my formula is very simple so please try
Regards,
Santy C
On Mon, Jul 4, 2011 at 10:13 PM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Hello,
If you want to count the unique numbres in a range, use this with just
Enter,
Hey,
please provide the SUMPRODUCT , SUBSTITUTE and ARRAY formula's
how to use and instruction
--
Regards,
Santy C
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
this was exactly what i'm thinking of building. anyone wants to work
together on this time-sensitive project then email me at
mehul.muk...@gmail.com
regards ... mehul
On Mon, Jul 4, 2011 at 6:21 PM, tikku tarun.mas...@gmail.com wrote:
Dear All,
Did anybody build a XBRL Creator in Excel to
Hello AIren,
Consider B1:B6 we have these values;
B1=1
B2=1
B3=Blank
B4=A
B5=Blank
B6=Blank
=SUMPRODUCT((B1:B6)/COUNTIF(B1:B6,B1:B6))
Firstly take (B1:B6)
This will check B2:B30 is blank or not, If it is blank will give FALSE, if
not will give TRUE. So will get like this
Hi friends,
is there any way where we can copy data from closed workbook A and paste it
into workbook B which is open?
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
MS Excel Expert (Macro / VBA)
2 Opening(s)
Shanti Consultants
*
*
Summary
*Experience:*
3 - 6 Years
*Location:*
Delhi, Delhi/NCR, Noida
*Compensation:*
Rupees 3,00,000 - 6,00,000
*Education:*
UG - B.Sc - Computers,BCA - Computers PG - PG Diploma - Computers
*Industry Type:*
Oil
Ayush,
I wish you well.
Congrats to Ashish!
Pascal
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
Well, I haven't tried but looks like it's exactly what I want
Thanks Million
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2.
Hi! siti Vi
I tried to download the example workbook but no file found
could you send me the file if you can please???
Thanks
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Recruiter - Email – sunit...@synovaindia.com
Experience required for the Job: 4 - 6 years
Job Location: Noida
Dear Candidate,
Hi
Urgent requirement for “VB/VBA†with Synova Innovative Technologies Pvt.
Ltd for one of our CMML5 Client, for Noida.
Skill - “VB/VBAâ€
Location - Noida
Recruiter Email: gunjan.chaphe...@careernet.co.in
Experience required for the Job: 2 - 6 years
Job Location: Bengaluru/Bangalore
Dear Candidate,
We came across your profile on one of the job portal and found it
interesting and prospective for one of our key clients.
In further to this, we
Hey Ashish,
Congrats!,
You deserve it
On Tue, Jul 5, 2011 at 3:47 AM, bpascal123 bpascal...@googlemail.com wrote:
Ayush,
I wish you well.
Congrats to Ashish!
Pascal
--
--
Some important links for excel
Nice explanation Haseeb (HTH).. !!
Regards,
DILIPandey
On Tue, Jul 5, 2011 at 12:34 AM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Hello AIren,
Consider B1:B6 we have these values;
B1=1
B2=1
B3=Blank
B4=A
B5=Blank
B6=Blank
=SUMPRODUCT((B1:B6)/**COUNTIF(B1:B6,B1:B6))
*hi rajan
thnks for such nice helps ...
due to size sensitive data in file i cant upload them
cant be there any vba codes for auto change in data validation list one by
one , and the result which came ,get pasted in other sheets.this is what
i needed...
i just want results get pasted in
*hi sant ram
plz check links below
for sumproduct
http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/
for array formulas
http://www.cpearson.com/excel/ArrayFormulas.aspx
for substitute
http://www.excelitems.com/2010/05/substitute-function.html
*Have A Nice Time Enjoy Life
Regards:
53 matches
Mail list logo