-
On Wednesday, October 26, 2016 2:58 AM, C.G.Kumar <
kumar.bemlmum...@gmail.com> wrote:
Hi,
Thanks for looking at my query.
Background (Why the data is scattered) : Data are shared by multiple team
(18-20) and after consolidation it becomes a table where Part Number , Qty
, Pr
>
> What is yours doing?
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As
Does anyone help me to fix the VB code (I'm not a VB guru either)for an
Open spreadsheet -
Purpose : when looking in a spreadsheet, I to look for a couple of column
header names, and then copy those columns only (in a predefined order) into
a clean separate worksheet.
For example,
On Sheet 1 -
:59 PM, Vaibhav Joshi v...@vabs.in wrote:
I did not got the logic of putting 8 in cell C5, can u pl explain..
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 23, 2014 at 9:18 PM, C.G.Kumar kumar.bemlmum...@gmail.com
wrote:
May someone please look
May someone please look and advise macro to solve the puzzle.
Thanks and Regards,
C.G.Kumar
-- Forwarded message -
From: C.G.Kumar kumar.bemlmum...@gmail.com
Date: Mon Dec 22 2014 at 7:09:55 PM
Subject: Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory
To: excel-macros
Please see attached file.
Let me know if any additional info is required.
On Mon, Dec 22, 2014 at 3:18 PM, Anil Gawli gawlianil8...@gmail.com wrote:
Dear Rockernayal,
Pls share a workbook with us.
Regards,
Gawli Anil
On Mon, Dec 22, 2014 at 3:15 PM, Mandeep Baluja
*
*Please see attached excel sample file.*
*Let me know if further details are required.*
*Many Thanks,*
*C.G.kumar*
On Mon, Dec 22, 2014 at 3:15 PM, Mandeep Baluja rockerna...@gmail.com
wrote:
Please explain your Query Again I an unable to understand it . Aeging can
be count
Macro is not providing desired result.
Attached worksheet looks at total Purchase of Specific qty and provides
ageing.
But the need is to have ageing ( Value) of balance stock only.
This mean in Solved worksheet of yours, total qty left in Cell B5 is to
be keyed in Manually and macro is
:23 AM, C.G.Kumar kumar.bemlmum...@gmail.com
wrote:
Hi,
I would appreciate if anyone can help me with Cash Flow Dashboard.
Many Thanks,
C.G.Kumar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum
Hi,
I have purchase data in a spreadsheet and List of Inventory Items on
another worksheet of excel.
May someone help me with a macro or advance formula which computes Ageing
of Inventory.
Age of Inventory is calculated in Purchase Sheet but do not know how to
compute for available qty only.
Hi,
I would appreciate if anyone can help me with Cash Flow Dashboard.
Many Thanks,
C.G.Kumar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1
for your support .
Regards,
C.G.Kumar
On Mon, Dec 22, 2014 at 10:15 AM, Ashish Bhalara ashishbhalar...@gmail.com
wrote:
Mr.C.G.Kumar
See attached file as your require function.
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary.
Spread
.
In above scenario, solution never br advised.
Will appreciate if you can suggest.
On Sunday, August 17, 2014, Vaibhav Joshi v...@vabs.in wrote:
Hi
Browse thru forum, solution to mass mailer is available, you can use that
template.
Cheers!!
On Fri, Aug 15, 2014 at 1:20 AM, C.G.Kumar
this imageto be part of email.
Many thanks in advance;
C.G. Kumar
-- Forwarded message --
From: *C.G.Kumar* kumar.bemlmum...@gmail.com
Date: Saturday, August 9, 2014
Subject: $$Excel-Macros$$ Include dynamic data range
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Attached is sample excel file used to remind customer in India to pay.
Excel expert help and support is expected on the below concern to modify
attached macro:
1. Once Send EMail button in cell N1 is clicked, it capture details well.
But, before, mail is sent to customer , I need to go to
.:)
On Wed, Apr 10, 2013 at 6:03 PM, xlstime xlst...@gmail.com wrote:
Hi CG,
Please try to use Advance filter and macro recording.PFA
.
Enjoy
Team XLS
On Wed, Apr 10, 2013 at 1:58 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
Hi,
I need to filter a long list
for understanding.
C.G.Kumar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help
Missed to attach sample file in trail mail.
On Thu, Apr 11, 2013 at 12:48 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
Thanks for trying but still the solution is not useful to me.
Let me explain correctly; Auto filter based on condition.
Data is available in range (say A6:I6) and i need
Can we do the same thing using Lotus Notes
On Fri, Mar 15, 2013 at 10:58 AM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
Dear Sagar,
Enclosed herewith the required data. Is it Ok ? Tell me .
Files are save in C:\Anil.
note:- When file are saved in the required dir. then automatically
of the list or something alike.
Attached sample workbook with Sample Data, output expected.
Thanks for understanding.
C.G.Kumar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https
, 2012 at 12:59 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
Hi ,
I need to extract a relevant portion from Excel cell.
Attached example file.
Many Regards,
C.G.Kumar
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise
It worked.
Thanks a lot.
On Thu, Dec 6, 2012 at 8:01 PM, ashish koul koul.ash...@gmail.com wrote:
try this
=RIGHT(G4,LEN(G4)-FIND(~,SUBSTITUTE(G4,
,~,LEN(G4)-LEN(SUBSTITUTE(G4, ,)
On Thu, Dec 6, 2012 at 4:07 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
Dear Anoop,
Thanks
Thanks Anoop for helping supporting me.
Regards,
C.G.Kumar
On Fri, Dec 7, 2012 at 9:40 AM, Anoop K Sharma aks.sharm...@gmail.comwrote:
Use the Ashish's formula for second case.
Regards,
Anoop
On Thu, Dec 6, 2012 at 8:01 PM, ashish koul koul.ash...@gmail.com wrote:
try this
=RIGHT
Hi ,
I need to extract a relevant portion from Excel cell.
Attached example file.
Many Regards,
C.G.Kumar
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help
Thanks Noorain.
It is very informative and useful. I am trying to learn macro from this.
May i as k to help me in the following scenarion;
1. I have excel work sheet which enlist customer having outstanding dues .
I need to send e mail to these customer on this list twice a day daily .
May i ask to help me in the following scenario;
1. I have excel work sheet which enlist customer having outstanding dues .
I need to send e mail to these customer on this list twice a day daily .
Attached excel have sample of records.
Is it possible to do it through macro . That is to Send
Thanks Daniel.
It really works.
Regards,
C.G.Kumar
On Sat, Aug 27, 2011 at 3:26 PM, Daniel dcolarde...@free.fr wrote:
Hello,
** **
See attached workbook.
** **
Daniel
** **
*De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
*De la part de
Dear All,
PFA sample file for your kind consideration.
Regards,
AMW-2
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join
Hi Sam,
The reader has sought for code to delete file if Password doesn't matches in
three attempts. You have provided code to delete file without prompting for
password match by oversight.
Hope you will be amend the same.
Regards,
C.G.Kumar
On Thu, May 5, 2011 at 1:58 AM, GoldenLance
,
C.G.Kumar
Is there a way out.
On Tue, May 3, 2011 at 2:24 AM, ChilExcel chilexcel...@gmail.com wrote:
see this link , that's what you need
http://office.microsoft.com/en-us/outlook-help/export-calendar-data-to-excel-HP001087241.aspx
Chilexcel
2011/4/27 Susan 1 sunni...@gmail.com
Hi
Thnaks Ashish.
It is very useful but i am not getting desired output when i copy VBA code
to my actual workbook.Please suggest Where i have to make change.
Regards,
C.G.Kumar
On Mon, Apr 18, 2011 at 6:18 PM, ashish koul koul.ash...@gmail.com wrote:
try this see if it helps
On Mon, Apr 18
No file found.
On Mon, Apr 18, 2011 at 7:31 PM, Daniel dcolarde...@free.fr wrote:
Hi,
Please, attach file ;-)
Daniel
*De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
*De la part de* C.G.Kumar
*Envoyé :* lundi 18 avril 2011 10:15
*À :* excel-macros
PFA sample File.
-- Forwarded message --
From: C.G.Kumar kumar.bemlmum...@gmail.com
Date: Mon, Apr 18, 2011 at 1:45 PM
Subject: SEARCH FUNCTION
To: excel-macros@googlegroups.com
Dear All,
I intend to generate list based on search of Text String.Sample file
attached.
Regards
Dear All,
I intend to generate list based on search of Text String.Sample file
attached.
Regards,
C.G.Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http
,
C.G.Kumar
--
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel
*formula only not macro.*
Regards,
C.G.Kumar
On Mon, Apr 18, 2011 at 2:43 PM, rajan verma rajanverma1...@gmail.comwrote:
you should apply contain Filter.. i think
On Mon, Apr 18, 2011 at 2:21 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
Hello,
I have a very tricky problem. I have got
Thanks .
I have modified the formula to suit my requirement as follows;
SMALL(IF(ISNUMBER(SEARCH((Report!B1),C2:C28,1)),ROW(1:28),ROW(1:28))
Thanks buddy for giving me the direction.
Regards,
C.G.Kumar
On Mon, Apr 18, 2011 at 3:33 PM, STDEV(i) setiyowati.d...@gmail.com wrote:
plese
Sir,
I have 12 picture embedded in Sheet 1 and i intend to create a hyper link in
Sheet 2 for each picture. Is it possible to do without Macro run.
Referencing to nearby cell is not worthy.
Regards,
C.G.Kumar
Hi All,
Yes. Thank you all for the generosity displayed for me . This is working
now. But, the macro causes loss of formating i.e. Column row width . Is it
possible to avoid this.
Thanks in Advance.
Regards,
C.G.Kumar
AMW-2
On Wed, Apr 13, 2011 at 1:39 AM, hanumant shinde arsfan2
worksheet he
intend to copy.
Thanks Regards,
C.G.Kumar
On Mon, Apr 11, 2011 at 6:22 AM, ashish koul koul.ash...@gmail.com wrote:
see if it helps
change
pathbk = C:\Documents and Settings\achamanlalko\Desktop\eforms\eform
reports\test workbook\ to the destination folder
Sub
Dear all,
Following code i am using to select each worksheet (except ) to copy and
paste special values in each worksheet in same workbook. But, i am not
getting desired output .
Could you one help to rectify the following code;
Sub ConvertToValues()
Dim ws As Worksheet
For Each ws In
Application.StatusBar = False 'return control to Excel
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub
---
Regards,
C.G.Kumar
suggest me any alternative manner.
Regards,
C.G.Kumar
--
--
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 @ http
suggest me any alternative manner.
Regards,
C.G.Kumar
--
--
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 @ http
Its awesome.Hats off to Ashish.
Regards,
C.G.Kumar
On Thu, Apr 7, 2011 at 10:35 AM, ashish koul koul.ash...@gmail.com wrote:
try this
On Thu, Apr 7, 2011 at 9:10 AM, Harkesh Kumar
harkesh.kuma...@gmail.comwrote:
Hi Experts,
We required your help for creat auto mailer in excel. or any
Hi,
Pls find attached file let me know if it serve the purpose.
Regards,
C.G.KUMAR
On Sun, Apr 3, 2011 at 1:39 PM, Suryaprasad suryaprasad...@gmail.comwrote:
Hi Team / Ayush,
Need a formula about a countif criteria
See the attachment and please do the need full
Regards
prasad
Sir,
Is it possible to select two criteria. In the given case Date and Room
number and then sort by date.
Regards,
C.G.Kumar
On Fri, Mar 25, 2011 at 8:55 PM, STDEV(i) setiyowati.d...@gmail.com wrote:
1.
formula HELPER
( creating list of RowIndex )
array formula in multi cells
PFA file. Hope it serve the purpose.
Regards,
C.G.Kumar
On Sun, Mar 27, 2011 at 8:06 AM, STDEV(i) setiyowati.d...@gmail.com wrote:
oops, the attachment
On Sun, Mar 27, 2011 at 9:35 AM, STDEV(i) setiyowati.d...@gmail.comwrote:
please find attached
and see if it helps
best
Thanks Divakar. Fantastic application of logic to get the output.
Regards,
C.G.Kumar
On Tue, Feb 8, 2011 at 8:14 PM, Divaker Pandey divake...@gmail.com wrote:
hi,
Please find this one
On Tue, Feb 8, 2011 at 10:10 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
Thanks sir
have same basic and
therefore, filter criteria by unique records destroys the objective.
Objective is to generate file having records as to when basic has changed
for the concerned over the period of time.
Thanks Regards,
C.G.Kumar
On Mon, Feb 7, 2011 at 1:12 PM, ashish koul koul.ash
innovative and i would apply the same.
I once again thanks for the courteous support.
Regards,
C.G.Kumar
On Mon, Feb 7, 2011 at 10:27 PM, rajan verma rajanverma1...@gmail.comwrote:
Hi
Find attachment
Rajan
On Mon, Feb 7, 2011 at 2:26 AM, Manoj kumar
manoj.vishwakarma...@gmail.com
Thanks sir,
It works.Could you please elaborate the steps in the formula, if possible.
Regards,
C.G.Kumar
On Mon, Feb 7, 2011 at 3:56 PM, Manoj kumar
manoj.vishwakarma...@gmail.comwrote:
Hi C.G,
A little complex but hope this might help your needs...
Regards,
Manoj Kumar
On Mon
I TOO INTEND TO CONTRIBUTE.
On Wed, Feb 2, 2011 at 9:09 PM, Ayush jainayus...@gmail.com wrote:
Hello everyone,
I am glad to share that I have decided to launch an excel knowledge website
for this group.The website will be launched on 4th anniversary of this group
i.e. 17th March 2011.
The
USE THIS
=IF(A$8$:$A$14=a,1,)
If u want to use as an array use cntr+shift+enter. It will give u proper
result.
Thanks Regards,
C.G.Kumar
On Mon, Jan 17, 2011 at 1:03 AM, hanumant shinde
hanumant_5...@yahoo.co.inwrote:
Hi Friends,
I want to use IF condition like i used below but its
.
Thanks Regards,
C.G.Kumar
On Sat, Dec 18, 2010 at 10:29 PM, Bharghav Ramdas bhargha...@gmail.comwrote:
Thanx Paul.
On Thu, Dec 16, 2010 at 1:31 AM, Paul Schreiner schreiner_p...@att.netwrote:
Keep in mind that Excel doesn't know time.
It knows numbers.
Time is simply the fractional
Paul,
I must admit that you are genius as the way of you explained the thing in
such a lucid manner that a naive person like me understood at first
sight... Unbelievable ..Many Many Thanks again to you Paul as you devoted
your precious time for us...
Thanks Regards,
C.G.Kumar
On Mon, Dec
and Task
completed, in process,yet to start etc, ) i thought a macro would be handy
to accomplish my task.
Regards,
C.G.Kumar
On Mon, Dec 20, 2010 at 7:58 PM, Paul Schreiner schreiner_p...@att.netwrote:
For this to work, it must be in EACH Excel file that you wish to open!
It will not work
to low i require this macro o run whenever i
open excel file. but this is not working.Any suggestion.
Thanks Regards,
C.G.Kumar
On Sat, Dec 18, 2010 at 7:30 PM, ashish koul koul.ash...@gmail.com wrote:
write the code in workbook open module
On Sat, Dec 18, 2010 at 5:04 PM, C.G.Kumar
require this macro to run whenever i
open any excel file. but this is not working.Any suggestion.
Thanks Regards,
C.G.Kumar
On Sat, Dec 18, 2010 at 6:53 PM, Richard richard.m...@gmail.com wrote:
Create a sub called sub workbook_open in this workbook and call
your macro.
On Dec 18, 3:34 am
Use data validation and specify the exact requirement.
On Sat, Dec 18, 2010 at 4:07 AM, Richard richard.m...@gmail.com wrote:
Is is possible to require a specific entry in a cell, or nothing?
If someone makes an entry in a cell, I want it to be ABC (all upper
case) and nothing else. It's OK
I want a macro to run every time when an excel file is opened.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN
.
Regards,
C.G.Kumar
--
--
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 @ http://www.linkedin.com/groups?gid
THANKS. . BUT IT PREVENTS THE ARITHMETIC CALCULATION ..
On Sat, Dec 18, 2010 at 11:03 AM, manhar prajapati
prajapati.man...@gmail.com wrote:
1 select font of Ruppee furdine in Excel
2 Use ` symbol for Ruppee symbol
manhar
On Sat, Dec 18, 2010 at 10:38 AM, C.G.Kumar kumar.bemlmum
No attachment found.
On Fri, Dec 10, 2010 at 3:16 PM, lucky singh lucky60...@gmail.com wrote:
Hi All,
kindly help me to get the collaction date with the help of an formula...
please refer the attachment...
Regards,
Lucky
--
Solved file Attached. Hope it serves the purpose.
Regards,
C.G.Kumar
On Wed, Dec 8, 2010 at 10:10 AM, Abhidha Dixit abhidha.di...@gmail.comwrote:
Dear All,
please help me with the formula where in I should get the result
1 IF left 3 strings is ABH then B2 -200, IF DIX then B2 -400
reference.
I am an optimist and feel there is way. Hope much experienced people could
show me some light.
Regards,
C.G.Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
Yes. Cool stuff.
Thanks for the help.
Regards,
C.G.Kumar
On Tue, Nov 23, 2010 at 4:03 PM, kiran Kancharla srkira...@gmail.comwrote:
U need to change the options.
Tool --- Options -- General Zoom on roll with Intellimouse
This has to Uncheck.
please try and let me know.
On Tue
Yes cntrl button is working.
On Mon, Nov 22, 2010 at 11:44 PM, Ms-Exl-Learner . ms.exl.lear...@gmail.com
wrote:
Check whether your cntrl button is working.
Ms-Exl-Learner
On Mon, Nov 22, 2010 at 10:52 AM, C.G.Kumar kumar.bemlmum
-Learner . ms.exl.lear...@gmail.com
wrote:
Check whether your cntrl button is working.
Ms-Exl-Learner
On Mon, Nov 22, 2010 at 10:52 AM, C.G.Kumar kumar.bemlmum...@gmail.com
wrote:
Dear All,
When i am using scroll wheel
body tell me how to rectify.
Regards,
C.G.Kumar
--
--
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 @ http
You can use EDATE if using Excel 2007. Rest you can define in Macro.
Regards,
C.G.Kumar
On Sat, Oct 23, 2010 at 12:07 AM, halpie97 shal...@sterlingstamos.comwrote:
I'm a beginner with VBA and looking for some guidance in how to
establish what I'm trying to do.
Column A Column B
I could not identify whether it is a solution or your query.If this is
solution pls ignore my mail, otherwise you may please explain the objective
and problem.
Thanks Regards,
C.G.Kumar
On Sat, Oct 9, 2010 at 2:20 PM, SUMIT VYAS svyas0...@gmail.com wrote:
Thanks For all member of Excel
Use the following formulae ; IF(COUNTIF(A$1:A1,A1)=1,Unique,Dupl)
Hope it serve the purpose.
Thanks Regards,
C.G.Kumar
On Wed, Oct 13, 2010 at 8:43 PM, vinod rao vinod.ma...@gmail.com wrote:
HI
I have multipal duplicate numbers and excluding one for others it should
say duplicate
(date) = 5 and day(date) =10 then
* *your full macro*
*
end if
end sub
On Wed, Oct 13, 2010 at 12:26 PM, C.G.Kumar kumar.bemlmum...@gmail.com
wrote:
Dear All,
I want my macro to be executed only for specific day in a month based on
system date and it should not run thereafter
You explained the logic in a precise and logical manner.I really appreciate
your way of explaining.
So nice of you Mr.Paul.
Thanks Regards,
C.G.Kumar
On Wed, Oct 13, 2010 at 7:48 PM, Paul Schreiner schreiner_p...@att.netwrote:
Let's examine what you're asking:
(Now) returns the current
Dear All,
I want my macro to be executed only for specific day in a month based on
system date and it should not run thereafter.
Kindly let me know the code for it.It's urgent.
Regards,
C.G.Kumar
--
--
Some
THANKS. BUT IT SERVE THE PURPOSE PARTIALLY...IN ADDITION I HAVE TO CONSIDER
ONLY FY 2009-10 WHEREAS FORMULA TAKES BEYOND 31/03/2010.3
IS IT POSSIBLE TO REVISE THE FORMULA.
REGARDS,
C.G.KUMAR
On Fri, Oct 8, 2010 at 2:19 PM, ashish koul koul.ash...@gmail.com wrote:
check the atatchment see
Attached sample file for the problem. Hope somebody among you will be able
to solve the crux.
Regards,
C.G.Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
Attached sample file for the problem. Hope somebody among you will be able
to solve the crux.
Regards,
C.G.Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
I am looking for conditional sum i.e. sum based on criteria. But neither
Sumproduct nor SUMIFS and Pivot serve the purpose.
Attached sample file . Hope you will be able to solve the crux.
Regards,
C.G.Kumar
,
C.G.Kumar
--
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel
, Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
--
Regards,
C.G.Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
--
Regards,
C.G.Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
.
Regards,
C.G.Kumar
On Mon, Sep 13, 2010 at 12:13 AM, stuartR spa...@corbetteer.co.uk wrote:
Currently running Excel 97 on XP, everything works just fine.
I am about to buy a new computer that will arrive loaded with Windows
7
I understand the Office97 / Excel 97 will not work on Windows 7
Dear All,
I need to capture Current Market Price of given scrip in Excel.I have used
DATAFrom Web. But, it difficulty is that it captures entire data and not
only scrip CMP.
Thanks Regards,
C.G.Kumar
Congrats Dave. I wish you will continue to do this in coming months too and
enrich our group forum.
Regards,
C.G.Kumar
On Fri, Sep 3, 2010 at 10:31 AM, Ayush jainayus...@gmail.com wrote:
Hi Group,
I am glad to announce that Dave Bonallack has topped in posting for
the month of Aug'10
Follow the link;
1.http://www.homeandlearn.co.uk/excel2007/excel2007s6p2.html
http://www.homeandlearn.co.uk/excel2007/excel2007s6p2.html2.
http://www.free-training-tutorial.com/conditional-formatting.html
On Mon, Sep 6, 2010 at 8:36 AM, Pankaj Kumar rajputpanka...@gmail.comwrote:
Hi all,
Kindly attach sample file.
On Wed, Sep 1, 2010 at 12:12 AM, Kurt heislerk...@gmail.com wrote:
Can't seem to get this working.
If A1 is a calculated error (e.g., #NULL) OR If A1 = --- , make
B1 = NA
Otherwise: If A1 Y1, make B1 = !, otherwise make B1 = (i.e.,
blank).
This is what I
Dear All,
Debit note format in excel is required. If any one has kindly forward.
Thanks Regards,
C.G.Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http
On Tue, Aug 31, 2010 at 11:41 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
Dear All,
Debit note format in excel is required. If any one has kindly forward.
Thanks Regards,
C.G.Kumar
--
--
Some
may select course of action.
Hope it serves the purpose.
Thanks regards,
C.G.Kumar
On Fri, Aug 27, 2010 at 10:42 AM, Pankaj Kumar rajputpanka...@gmail.comwrote:
Hi,
I have a problem i have a lot of data i wanted to find duplicate record
is there any fourmula or command in excel
Press F1 Key and see the examples.
On Fri, Aug 27, 2010 at 10:54 AM, Pankaj Kumar rajputpanka...@gmail.comwrote:
Hi,
Can anyone help me to understand what is Vlookup Hlookup,for a short
example how to use it ,,
--
*Warm Regards
Pankaj kumar
M: 9899816107
e-mail:
Could you please attach sample file.
Thanks Regards,
C.G.Kumar
On Fri, Aug 27, 2010 at 10:21 AM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Hello Sir,
I have a data in which a column having the both numeric and alphabetically
value but i want to separate these value into two column
In my opinion, data lost.
On Fri, Aug 27, 2010 at 6:54 AM, Idhrees Mohamed idhrees...@gmail.comwrote:
Dear guys,
I have a excel sheet with big data. Its contain one date column
unfortunately I delete and save it. It’s possible to recover that
column.
Thanks in Advance.
Regards,
Please attach sample file.
On Mon, Jul 5, 2010 at 2:43 PM, Rajender Soni soni.rajen...@gmail.comwrote:
Hi
Pls revert to the issue below:
My rown no. is fixed - 5, column no. is changing, now i want that suppose i
click in column g, then i will get the cell value of G5, if i click on
consideration.
Please use other than data filter criteria and also let me know whether it
is possible to accomplished with Macro or not ?
Regards,
C.G.Kumar
--
--
Some important links for excel users:
1
You can use Mid formulae. By the way you are
On Mon, Jun 28, 2010 at 10:25 PM, Nadine S n8dine4ma...@yahoo.com wrote:
I have a cell that I'd like to write a formula that returns all but the
first 8 characters. The cell's data can be any length. Thanks.
Nadine
--
It is aimed to calculate markup.
On Fri, May 28, 2010 at 12:15 AM, markndawoods markndawo...@molalla.netwrote:
what is this formula designed to provide?
=F24/(1-F25)
where cell F24 is a dollar figure of $18.25
and cell F25 is a percent 65%
It is in a spreadsheet I use at work and am just
_
:=False, Transpose:=False
Application.CutCopyMode = False
Columns(6).Clear
Range(A1).Select
End Sub
On Fri, Mar 19, 2010 at 10:45 AM, C.G.Kumar
kumar.bemlmum...@gmail.comwrote:
Dear Masters,
File attached for your kind consideration and support.Please let me know
whether
...@gmail.com wrote:
Hi
it seems you want to create separate sheet for each value in column C,
Please find attach sheet. Is this what you looking for ?
On Fri, Mar 19, 2010 at 10:11 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
Could anyone suggest the manner i could to the following ;
1. Add
1 - 100 of 105 matches
Mail list logo