Hi Venkat,
Sounds like a job for SUMPRODUCT.
We could probably do the needful if you attached a sample worksheet.
Regards - Dave.
Date: Wed, 27 May 2009 09:19:07 +0530
Subject: $$Excel-Macros$$ Formula needed
From: sudhakar...@gmail.com
To: excel-macros@googlegroups.com
Dear Friends,
I ne
Hi,
Sounds like a job for SUMPRODUCT
I could probably do the needful if you attached a sample worksheet.
Regards - Dave.
Date: Wed, 27 May 2009 09:19:07 +0530
Subject: $$Excel-Macros$$ Formula needed
From: sudhakar...@gmail.com
To: excel-macros@googlegroups.com
Dear Friends,
I need a fo
Dear Friends,
I need a formula for my work.
There will be 2 Excel sheets.
In First Sheet there will be 2 Columns
In First column there will be code and in 2nd column there will be value and
'n' number of rows will be there. And the code may be repeated at several
times in different rows.
And i
Hi Atul,
Have a look at the attached workbook, and see if it does what you want. I've
added a button to run the macro from the sheet, but you may want to run it some
other way.
I've left your formulas as you had them.
Regards - Dave.
Date: Tue, 26 May 2009 18:33:57 +0530
Subject: $$Excel-
I have code below to put a list of ID's from this:
123
122
121
3532
to this: ('0123','0122','0121','03532')
However, I only want to put a zero in front of the ID if it is 3
characters in lenght. Desired output would be
('0123','0122','0121','3532'). Any help would be appreciated.
thanks,
Pub
Hi, check the below link to write the excel sheet to Word. The code in the
article does not satisfy all your requirements, you might want to tweak the
code according to your requirements. Also to know the details of saving word
to PDF, you might want to check in some PDF forums too. They will have
This code wasn't quite right and it was giving me errors.
I found the problem was in this line: " if date(Range("B2").value)
=dtdate then "
I corrected it to read " if Range("B2").value=dtdate then " and it
works fine!
Many Thanks!
Doug
On May 20, 4:06 am, bala wrote:
> Hi,
>
hi, instead of writing macros in the excel file that your are sharing write
all the code in your own person xls. This will help you in preserving your
code and re using macros on any excel you have. Check the below microsoft
link to get more insight about Personal XLS.
http://office.microsoft.com/
Check the code block 4 in the below article to delete entire row based on a
blank cell in a particular column (for you it is first column)
http://funwithexcel.blogspot.com/2009/05/macros-to-delete-blank-or-empty-cells.html
On Wed, May 20, 2009 at 2:49 PM, tuigje7 wrote:
>
> How can I change the
Hi,
Check the link below for the VBA code.
http://funwithexcel.blogspot.com/2009/05/how-to-open-url-list-from-excel-using.html
Hope this helps.
On Wed, May 20, 2009 at 4:10 PM, Lexster wrote:
>
> Hi.
>
> I have a list of URL links in a 2003 spreadsheet, tab name="Sheet 1",
> first cell referen
Hi...
anybody looking into this? Are there a solution?
Apreciate all feedback and help...
On 5/24/09, Phillip Swanepoel wrote:
> I include the sample file...
>
> Hi all..
>
> I got this roster on a excell work book. Could you please help me to get
> the following.
>
> the names on the firs
Hi
here i want to make chart acc. to data received
here i try to make column like count n frequency
so that i cn show the data on chart in which i wanted to show
data acc. to intervals
but i m not able to count data in time format
wat cn i do?
--~--~-~--~~~---~--~~
No file attached.
ankur kochar wrote:
> Hi,
>
> Sorry for attaching the password file. Please find here attached file for
> help on how to work in excel with macros when it is s
>
> On Thu, May 21, 2009 at 10:02 PM, Fabio Lemos wrote:
>
> > Your file has password... please attach a file without
Hi,
try this
=IF(OR(D5=B5,D5=A5),"match","mismatch")
however you've to remove the domain name from column "d" or use text formula
to remove the domain name value i.e "@gmail.com, which is not there in
column "a"
thanks
Durai
On 5/25/09, Pooja Sharma wrote:
>
> Hi All,
>
> I need a help, with
Hello Dave,
Thanks for the below formulas.
The reason I am asking for the macro is that we have more then 25 sheet in a
file and more then 200 line items in each sheet, macro would help to reduce
the file size and minimize the changes of error.
I have attached a file in which i have tried to wri
Hi,
This code is not running. Does this requires any reference library to be
included except default..
Regards,
Upendra Singh
9910227325
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of ddadmin2009
Sent: Tuesday, May 26, 2009 11:47 AM
To: exce
On Tue, May 26, 2009 at 11:31 AM, Pooja Sharma wrote:
> Hi All,
>
> I need a help, with a condition in which I have to match a column with
> other two columns and if out of those two columns any of them match with the
> first column then the result will be "Match" otherwise "Mismatch"
>
> --
> Bes
Pooja,
I hope you are looking for this one..(colored in red) this was calculated as
per the length..so you can adjust the same per your convience...
Good Luck
Cheers
Surya
On Tue, May 26, 2009 at 11:31 AM, Pooja Sharma wrote:
> Hi All,
>
> I need a help, with a condition in which I have to mat
=IF(OR(D5=B5,LEFT(D5,FIND(".",D5)-1)=LEFT(A5,FIND("
",A5)-1)),"Match","Mismatch")
Hi Pooja,
Write this formulas on E5 Cell and dreg it down. it should work.
Great Day..!!!
Ciao..!!
Jai Kishan
On May 26, 11:01 am, Pooja Sharma wrote:
> Hi All,
>
> I need a help, with a condition in wh
Pls use this formulas...
=IF(OR(D5=B5,LEFT(D5,FIND(".",D5)-1)=LEFT(A5,FIND("
",A5)-1)),"Match","Mismatch")
on E5 Cell and Drag it down.
Ciao..!!
Jay
On May 26, 11:01 am, Pooja Sharma wrote:
> Hi All,
>
> I need a help, with a condition in which I have to match a column with other
> two c
Hi All,
Me too boys.
Hey Anubhav, if you get any stuff pls share with me too
Thanks
On May 25, 5:07 pm, Anubhav Somani wrote:
> Dear Members,
>
> I am not used to working on macros. though i have prepared simple macros but
> i wish to learn more.
>
> I seek guidance and suggestion from all.
>
>
> Hello Guys,
>
> Need a help on writing macro. I am preparing a sheet which has three
> coloumn.
> The first coloumn would have number ranging from 1 to 3. The Second coloumn
> would have certain number varying from 0 to 6( inclusive of demical to 2
> digit).What I need in third coloumn is a f
Thanks a lot.
it solve my problm.
On May 26, 7:39 am, ddadmin2009 wrote:
> In excel 2007, go to Formulas -> Define Name...and for conditional
> formatting, Home -> Conditional Formatting -> New Rule -> Click on "Use a
> formula to determine which cells to format".
>
> On Mon, May 25, 2009 at 6:2
Excel Matic
///
Function Sumif()
Posted: 25 May 2009 09:43 AM PDT
http://feedproxy.google.com/~r/Excel-matic/~3/UN82YeUnUY0/function-sumif.html
SumIf()
Sumif() is a variant of Sum() function and it calcuates the sum of a given
range, of only those cells
I think that is definitely possible with VBA.. but to start with check the
below code to get google search result count in excel... you can explore
more and tweak the code accordingly to get your desired result.
http://funwithexcel.blogspot.com/2009/05/how-to-get-google-search-results-count.html
j
Hi All,
I need a help, with a condition in which I have to match a column with other
two columns and if out of those two columns any of them match with the first
column then the result will be "Match" otherwise "Mismatch"
--
Best Regards
Pooja Sharma
--~--~-~--~~~---
26 matches
Mail list logo