Hi Frnds
In the attached sheet calcuation problem.
for Example
A
125000 (Ram)
262000 (Amit)
3Total
How to total above which has text.
Please Help
--
sudhir
--
--
Some important links for
hi bro
check your file at
http://www.file-encryptor.com/
i think your file is corrupted
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 Sat, Jan 16, 2010 at 6:04 PM, champaneriya nipun
champ.ni...@gmail.com wrote:
Hi
am working scheduling problem in excel. i would like to know...is there any
way i can get the chart for the datas in Gantt Chart format.
It will be greatful if somebody helps me out with this problem.
Regards
Maniyan
--
I'm relatively new to VBA programming, but what I want to do is go
through a range starting at a10 through the last record listed (varies
in # of records, but always together). If the field in column a =
cogs, then I want to count it as +1. Eventually I'm trying to
create to sum formulas- one to
Thank you so much Dilip.
Now its working fine.
*Unfeigned Regards
Manoj S Negi
Skype - manojsnegi
*
On Fri, Jan 15, 2010 at 3:23 PM, Dilip Pandey dilipan...@gmail.com wrote:
Dear Manoj,
As requested, please find below the process.
Assume you want to do conditional formatting in entire
Hi,
Any special reason for using VBA?
I think this would be done more easily using the worksheet function COUNTIF
Regards - Dave.
Date: Mon, 18 Jan 2010 06:03:26 -0800
Subject: $$Excel-Macros$$ Problem w/ VBA Code Evaluating a Range
From: mdai...@xomox.com
To:
Hi.
Is there a way to protect just the format of some Excel worksheet area
(Excel 2003)?
I have some areas fully protected and some unprotected. I need to
avoid users to change format (making pastes simpler) in unprotected
areas.
Thanks
Martins
--
I have a spreadsheet that is connected to an Access database using the
“Get External Data” feature of Excel.
The Access database has simple macro that executes to refresh the data
used by the queries. Right now, whenever I want to refresh the tables
in Access, I have to open the databases and
Hi,
I want open multiple web pages in IE 7 using excel macros.
Can i use Arrays to store weblinks for loop to move the loop to the next link.
I tried but its not working.
Regards,
Sandeep
--
--
Some important
Guys,
I am facing some problem to Extract the A/c no. from Line written in
Particular Cell.
There is only 2 Unique things
1. A/c No. should be starts from 9.
2. Length of A/c no. is 10 digits.
Example.
A1 = EMI of Rs. 800 From A/c No. 9089655463
A2 = From A/c No. 9826438564 Debt EMI 300
A3 =
Hello dailey,
Can you share a sample workbook with your exact requirement. I went through
your code.. But was unable to get what exactly you are looking for. If you
share a workbook and explain the result you want..probably it would be easy
for this group members to respond.
Thank you!!
Can't you use the same offset and movement code... i.e. End(xlUp) and
calc two SUMIFs functions?
SUMIF(c10:cN,COGS,e10:eN)
SUMIF(c10:cN,Sales,e10:eN)
Dim FirstRow As Long
Dim LastRow As Long
FirstRow = 10
LastRow = Range(A65536).End(xlUp).Offset(0, 0).Row
hi rahul
plz attach sample file
On 19/01/2010, Rahul Gandhi. myname.ra...@gmail.com wrote:
Guys,
I am facing some problem to Extract the A/c no. from Line written in
Particular Cell.
There is only 2 Unique things
1. A/c No. should be starts from 9.
2. Length of A/c no. is 10 digits.
Ichek it
F(NOT(ISERROR(FIND(No.,A1))),MID(A1,FIND(No.,A1)+4,10),IF(NOT(ISERROR(FIND(No,A1))),MID(A1,FIND(No,A1)+3,10),
))
On Tue, Jan 19, 2010 at 12:17 AM, Rahul Gandhi. myname.ra...@gmail.comwrote:
Guys,
I am facing some problem to Extract the A/c no. from Line written in
Particular Cell.
hi rahul
check this
this will work in any format
+MID(A1,FIND(9,A1,1),10)
On 19/01/2010, ashish koul koul.ash...@gmail.com wrote:
Ichek it
F(NOT(ISERROR(FIND(No.,A1))),MID(A1,FIND(No.,A1)+4,10),IF(NOT(ISERROR(FIND(No,A1))),MID(A1,FIND(No,A1)+3,10),
))
On Tue, Jan 19, 2010 at 12:17 AM,
Dear Manoj, you are welcome...!!
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Jan 18, 2010 at 4:56 PM, Manoj S Negi
manojsnegi.uttranc...@gmail.com wrote:
Thank you so much Dilip.
Hi Sudhir
Have a look at the attached. It took some sorting! Hopefully it's what you need.
Regards - Dave.
Date: Mon, 18 Jan 2010 14:12:24 +0530
Subject: $$Excel-Macros$$ Help
From: bluecore...@gmail.com
To: excel-macros@googlegroups.com
Hi Frnds
In the attached sheet calcuation
17 matches
Mail list logo