Hi ,
Please help..
On Tue, Aug 27, 2013 at 11:53 AM, Smitha S R wrote:
> Hi,
>
> Please suggest option to prevent copy paste in cells with data validation .
> Please suggest other than macros
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
Hi,
Please suggest option to prevent copy paste in cells with data validation .
Please suggest other than macros
--
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
* **Thats All (^.^)*
>
> After we know the main concept of that formulas, we can solve your next
> question with this formula
> *
> =SUM(IFERROR((Sheet1!$A$3:$G$6=$A4)*(Sheet1!$C$3:$I$6),0)) => *Red Value
> Shifted 2 Column*
> **
> *Rgds,
> [dp]
>
>
> Pada 18/07/20
function for
> filtered range with help of subtotal
>
> =subtotal(109,D2:D7)
>
>
>
> On Thu, Jul 18, 2013 at 5:33 PM, Smitha S R wrote:
>
>>
>> Hi,
>>
>> PFA the attachement, I have applied the formula suggested by De Premor,
>> but
Hi premor,
Please help
On Thu, Jul 18, 2013 at 5:33 PM, Smitha S R wrote:
>
> Hi,
>
> PFA the attachement, I have applied the formula suggested by De Premor,
> but after including one more column. Now the formula is not working.
> Please help.
>
>
> On T
>
> On Thu, Jul 18, 2013 at 4:11 PM, Smitha S R wrote:
>
>> Thanks a lot Vijay,
>> Applying the formula suggested by Premor works. but if I insert one
>> column in between before values. values becomes zero.
>> Please help out.
>>
>>
>> On Th
ormulas-excel.php.
>
> There are also many other sites just google for array formulas or CSE
> formulas.
>
> Regards,
> VijayKumar
>
>
>
> On Thu, Jul 18, 2013 at 3:36 PM, Smitha S R wrote:
>
>> Hi Premor,
>>
>> Thanks for the support, how the {,
Hi Premor,
Thanks for the support, how the {, braces appear there? and by removing
that formala is not working
On Thu, Jul 18, 2013 at 1:46 PM, De Premor wrote:
> Is like attached ?
>
>
> On 18/07/2013 14:52, Smitha S R wrote:
>
> Hi Team,
>
> Any one please hel
Hi Team,
Any one please help on this, as I am stuck with one report and can move
forward only after solving this.
On Thu, Jul 18, 2013 at 12:57 PM, Smitha S R wrote:
> Hi Team,
>
> PFA the work book, I have to get the total values in all the column in
> another sheet wherever t
Hi Team,
PFA the work book, I have to get the total values in all the column in
another sheet wherever the same name appears.
Please see the attachment and help it at the earliest.
Assume that the values are there for 30 columns.
Thanks Smitha
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
Hi,
I am sure that this is possible, but don't know how to work out.
On Tue, Apr 23, 2013 at 1:39 PM, priti verma wrote:
> Hi Smitha,
> This is not possible.erma
> thanks
> Priti v
>
>
>
> On Tue, Apr 23, 2013 at 1:25 PM, Smitha S R wrot
what is the option for the same in Excel 2007
On Mon, Apr 22, 2013 at 1:13 PM, ravinder negi wrote:
> you can use auto corrrect feature which will replace off into Office
> Supplies.
>
> Just go to file->option->proofing->autocorrect, type off in replace box
> and office Supplies in with box.
>
Hi,
Please help..
-- Forwarded message --
From: Smitha S R
Date: Mon, Apr 22, 2013 at 5:08 PM
Subject: Fwd: $$Excel-Macros$$ selecting the word from a list with the
first letter.
To: excel-macros@googlegroups.com
Hi,
Anyone please help in this regard.
-- Forwarded
Hi,
Anyone please help in this regard.
-- Forwarded message --
From: Smitha S R
Date: Mon, Apr 22, 2013 at 3:54 PM
Subject: Re: $$Excel-Macros$$ selecting the word from a list with the first
letter.
To: excel-macros@googlegroups.com
Hi,
PFA the updated list, where in one
his
>
>
> On Mon, Apr 22, 2013 at 3:34 PM, Smitha S R wrote:
>
>> Hi.
>>
>> Please help me in selecting the word from a list as soon as I start
>> entering the first letter.
>>
>> I have a list of Stationery items. PFA the list.
>>
>>
&g
Hi.
Please help me in selecting the word from a list as soon as I start
entering the first letter.
I have a list of Stationery items. PFA the list.
Please solve this without a macro if possible.
Thanks
Smitha
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIM
>>> You can use:
>>>
>>> =COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,B2)
>>>
>>> Aamir Shahzad
>>>
>>> On Thu, Feb 7, 2013 at 1:36 PM, Smitha S R wrote:
>>>
>>>> Hi,
>>>>
>>>> Please help me in findi
Hi,
This formula does not suit my requirement. I have to count the names
matching the product and ID.
On Thu, Feb 7, 2013 at 2:09 PM, Aamir Shahzad wrote:
> You can use:
>
> =COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,B2)
>
> Aamir Shahzad
>
> On Thu, Feb 7, 2013 at 1:36 PM, Smith
Hi,
Please help me in finding the count of unique values matching criteria as
in the attachment.
Regard
Smitha
--
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
))-INDIRECT("'sheet1'!"&"C"&MATCH(B2,Sheet1!$B$1:$B$5,0)))"
> or check attachment.
>
> On Sun, Jan 13, 2013 at 2:21 PM, Smitha S R wrote:
>
>> Hi,
>>
>> PFA the statement and correct the formula I have used.
>> Its showi
why we have to press CTRL+SHIFT+ENTER.
Its taking a lot of time to process the same.
On Sun, Jan 13, 2013 at 2:46 PM, ashish koul wrote:
> try attached workbook
>
>
> On Sun, Jan 13, 2013 at 2:31 PM, Smitha S R wrote:
>
>> HI,
>> Tried but returns #VALUE
>>
&
Congrats Prince.
I too want to learn excel in depth, advance, want to become excel expert.
I always search net for excel materials, but cannot make a step by step
study.
Please help me and advice me to complete my wish,
also suggest any materials so that I can buy from the shop, which is useful
a
)
>
>
> press CTRL+SHIFT+ENTER
>
>
> On Sun, Jan 13, 2013 at 2:21 PM, Smitha S R wrote:
>
>> Hi,
>>
>> PFA the statement and correct the formula I have used.
>> Its showing sum errors
>>
>> --
>> Join official Facebook page of this for
;
> Rows.Count).End(xlUp).Row).PasteSpecial
> End With
> Application.CutCopyMode = False
> End If
> lbl:
> Next
> End Sub
>
> note: please insert 1 sheets in ur workbook "OutPut" output sheet will
> hold all the data of
Hi,
PFA the statement and correct the formula I have used.
Its showing sum errors
--
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,
Urgent, Need Help, Formula Problem,
thanks a lot
On Sat, Jan 12, 2013 at 8:55 PM, >>Excel Beginner<< wrote:
> Hi,
>
> Please find the attachment.
>
>
>
>
> --
> *Regards,*
> *
> *
> *Excel Beginner*
> On Thu, Jan 10, 2013 at 2:52 PM, Smitha S R wrote:
>
>>
chin/excel-macros/merge/excel-macros/8T3EPECvA10/Y3vwNk6wM-YJ>
>
>
> On Friday, January 11, 2013 12:20:39 PM UTC+5:30, Smitha S R wrote:
>
>> NO,PLEASE send it once more
>>
>> On Fri, Jan 11, 2013 at 12:14 PM, Prince wrote:
>>
>>> dear
>>
Hi,
Any one please help me in combining the data in two different work sheets
in to another worksheet.
Its really urgent.
On Fri, Jan 11, 2013 at 12:30 PM, Smitha S R wrote:
> It not working, run time error 1004 appears
>
> On Fri, Jan 11, 2013 at 12:23 PM, Prince wrote:
&
NO,PLEASE send it once more
On Fri, Jan 11, 2013 at 12:14 PM, Prince wrote:
> dear
>
> have you seen that lik i have provided
>
>
>
> On Friday, January 11, 2013 11:58:33 AM UTC+5:30, Smitha S R wrote:
>
>> HI,
>>
>> is this possible..
>>
>&g
HI,
is this possible..
On Fri, Jan 11, 2013 at 11:28 AM, Smitha S R wrote:
> Hi,
>
> Please help
>
>
> On Fri, Jan 11, 2013 at 11:14 AM, Smitha S R wrote:
>
>> HI,
>>
>> Is this possible without macros
>>
>> On Fri, Jan 11, 2013 at 11:12
Hi,
Please help
On Fri, Jan 11, 2013 at 11:14 AM, Smitha S R wrote:
> HI,
>
> Is this possible without macros
>
> On Fri, Jan 11, 2013 at 11:12 AM, ashish koul wrote:
>
>> Try this
>>
>> Sub merge1()
>> Dim i As Long, z As Long
>> ' add ne
Sheets("Merge").Range("a" &
> Sheets("Merge").Range("a1048576").End(xlUp).Row + 1)
> End If
> Next
> End Sub
>
>
>
> On Fri, Jan 11, 2013 at 11:05 AM, NOORAIN ANSARI > wrote:
>
>> Hi Smitha,
>>
>> can shar
HI,
Data for the first jan is in one sheet and data for second jan is another
sheet.
I have to get data in another worksheet for both dates.
On Fri, Jan 11, 2013 at 11:05 AM, NOORAIN ANSARI
wrote:
> Hi Smitha,
>
> can share a sample with group.
>
>
>
> On Fri, Jan 11, 2013
Hi,
How to merge data in two excel worksheets to another work sheet
--
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,
Urgent, Need Help, Formula Problem, Code Problem,
Hi Noorain
Can you please help me on this.
-- Forwarded message --
From: Smitha S R
Date: Thu, Jan 10, 2013 at 5:18 PM
Subject: Re: $$Excel-Macros$$ Probability
To: excel-macros@googlegroups.com
Hi,
I need mix of all the places with the kms derived from the data table
for eg
C
> A D
> B A
> B C
> B D
> B Ending Place
> C A
> C B
> C D
> C Ending Place
> D A
> D B
> D C
> D Ending Place
>
> Regards,
> Lalit Mohan
>
>
> On Thursday, 10 January 2013 16:04:59 UTC+5:30, Smitha S R wrote:
>
>> Hi,
>>
>
Hi,
Can any one help on this
-- Forwarded message --
From: Smitha S R
Date: Thu, Jan 10, 2013 at 2:52 PM
Subject: $$Excel-Macros$$ Probability
To: excel-macros@googlegroups.com
Hi,
PFA the file which shows distance in KMS between different places.
First Table 'Data'
Hi,
PFA the file which shows distance in KMS between different places.
First Table 'Data' mentions the kms from one place to another and total kms
from starting place to ending place.
Is it possible to get all probabilities of places in the second table with
the kms derived from the first table
Hi,
Anyone please send me some good excel template to maintain the office
stationery items, their consumption, opening stock , closing stock, and
reports on monthly basis and daily basis
On Sun, Jan 6, 2013 at 1:40 PM, Smitha S R wrote:
> Hi,
> Anyone please send me ome good excel templ
no attachment found
On Sun, Jan 6, 2013 at 2:09 PM, wrote:
> **
> Google.com
> Sent from BlackBerry® on Airtel
> --
> *From: * Smitha S R
> *Sender: * excel-macros@googlegroups.com
> *Date: *Sun, 6 Jan 2013 13:40:51 +0530
> *To: *
&g
Hi,
Anyone please send me ome good excel template to maintain the office
stationery items, their consumption, opening stock , closing stock, and
reports on monthly basis and daily basis
On Sun, Jan 6, 2013 at 9:30 AM, Smitha S R wrote:
> HI,
>
> Can anyone send some good excel te
HI,
Can anyone send some good excel template to maintain the office stationery
items, their consumption, opening stock , closing stock, and reports on
monthly basis and daily basis
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise,
please help me
On Mon, Aug 20, 2012 at 1:59 PM, Smitha S R wrote:
> Hi Ashish,
> I apply the said formula, its counting 'Not Ok" also and filling the same
> colour.
>
>
> On Mon, Aug 20, 2012 at 12:40 PM, ashish koul wrote:
>
>>
>>
>> select ra
>
>
>
> On Mon, Aug 20, 2012 at 12:36 PM, Smitha S R wrote:
>
>> HI,
>>
>> some one please help me on this.
>>
>> On Mon, Aug 20, 2012 at 12:20 PM, Smitha S R wrote:
>>
>>> Hi,
>>>
>>> If one cell contain a specific Text
HI,
some one please help me on this.
On Mon, Aug 20, 2012 at 12:20 PM, Smitha S R wrote:
> Hi,
>
> If one cell contain a specific Text "On", the whole row from A2 to D2
> should be filled with yellow colour. How can it be?
>
> --
> Join official facebo
Hi,
If one cell contain a specific Text "On", the whole row from A2 to D2
should be filled with yellow colour. How can it be?
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate
Hi,
If one cell contain a specific Text "On", the whole row from A2 to D2
should be filled with yellow colour. How can it be?
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate
gt; Kuldeep Singh
> Phone.: +91-120-4763789, Extn.: 789
> naukrikuld...@gmail.com || www.naukri.com
> *Please* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>
> On Thu, Jul 26, 2012 at 11:44 AM, Smitha S R wrote:
>
>> Hi,
>
Hi,
Please help in conditional formatting or use of if formula in the following
case. Excel attached.
Closing Stock Verification stock required 1 1 if closing
Stock=Verification Stock blue colour should be filled in cell B3 5 4 if
closing Stock>Verification Stock green colour should be fille
ase* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>
>
> On Wed, Jun 20, 2012 at 5:40 PM, Smitha S R wrote:
>
>> How to merge cells in a table.
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>
How to merge cells in a table.
--
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
Hi,
PFA my vlookup table. If I select the nature of expenses, corresponding
expenses main head should come from the second worksheet anemd data2.
But the main head coming in the first work sheet is wrong. Please help on
this.
Regards
Smitha
--
FORUM RULES (986+ members already BANNED for violat
n P*
>
>
>
>
>
> On Fri, Jun 15, 2012 at 11:27 AM, Smitha S R wrote:
>
>> Hi,
>>
>> Any one please help me in deleting all blank columns in a data report
>> with many filled rows and columns.
>>
>>
>> On Fri, Jun 15, 2012 at 11:1
Hi Noorain,
Can you please tell me how to delete blank columns in data sheet?
On Fri, Jun 15, 2012 at 11:27 AM, Smitha S R wrote:
> Hi,
>
> Any one please help me in deleting all blank columns in a data report with
> many filled rows and columns.
>
>
> On Fri, Jun 15, 201
Hi,
Any one please help me in deleting all blank columns in a data report with
many filled rows and columns.
On Fri, Jun 15, 2012 at 11:11 AM, Smitha S R wrote:
> How to delete all blank columns arising between various rows and columns?
>
> --
> FORUM RULES (986+ members alread
How to delete all blank columns arising between various rows and columns?
--
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
quic
, Smitha S R wrote:
> Thanks Noorain. Its working.
>
> Shall I get the codes or basics to study on these codes so that I can use
> the controls in excel and make them working in a simple way.
> Please do send me any material with the basics of codes, so that I can
> understand the u
x27;t have any experience in programming or else...
On Thu, Jun 14, 2012 at 3:13 PM, NOORAIN ANSARI wrote:
> Hi Smitha,
>
> Check this one..
>
>
> On Thu, Jun 14, 2012 at 3:09 PM, Smitha S R wrote:
>
>> Hi,
>>
>> Its not working.
>>
>>
>
Hi,
Its not working.
On Thu, Jun 14, 2012 at 3:01 PM, NOORAIN ANSARI wrote:
> Hi Smitha,
>
> Please see atached sheet.-
>
>
>
> -
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Thu, Jun 14, 201
Is it possible to include the items in one sheet to a combo box in other
sheet.
For example, if in sheet 1 there is names and in the second sheet there is
combo box with the heading names. Shall I get the names of other sheet in
the combo box as and when I go on adding the names in the first She
Hi Noorain,
How did you make the Home page for this .
I too want to make a similar one for showing reports.
If I click on one tab, it show the details of the item shown in the tab.
Please help me in doing such a similar home page.
On Wed, Jun 6, 2012 at 10:54 PM, NOORAIN ANSARI wrote:
> Hi Poo
ma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Smitha S R
> *Sent:* 05 June 2012 3:25
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Graph
>
> ** **
&
Please help on the graph preparation
On Tue, Jun 5, 2012 at 3:25 PM, Smitha S R wrote:
> Hi,
>
> Please help me in drawing the graph, as per the attachment.
> Need a graph , month wise where the employee growth, cost wise growth and
> team could be identified .
>
>
Hi,
Please help me in drawing the graph, as per the attachment.
Need a graph , month wise where the employee growth, cost wise growth and
team could be identified .
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
How we can place a combo box in excel work sheet?
--
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 b
Hi anil,
How you placed the combo box in Excel?
On Fri, May 25, 2012 at 1:27 PM, Smitha S R wrote:
> Is this possible in dropdown list as you have prepared using combo box?
>
>
> On Tue, May 22, 2012 at 10:05 AM, Anil Gawli wrote:
>
>> your attached file is corrupte
Hi,
I have a drop down list which is created using menu 'data validation'.
Is it possible to get the items in the first line in the drop down while
start entering the letters of the items.
Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start
entering P itself Pen and pencils
t;>
>>
>> 2012/5/21 Anil Gawli
>>
>>> with data validation i don't think so, i have prepared in combo box
>>> control.
>>> Is it Ok?
>>>
>>>
>>>
>>> On Mon, May 21, 2012 at 3:53 PM, Smitha S R wrote:
>>>
start
entering P itself Pen and pencils should come in the first line.)
On Mon, May 21, 2012 at 2:28 PM, Anil Gawli wrote:
> File attached FYI
>
>
> On Mon, May 21, 2012 at 1:50 PM, Smitha S R wrote:
>
>> Hi,
>>
>> I have a drop down list which is created using me
Hi,
I have a drop down list which is created using menu 'data validation'.
Is it possible to get the items in the first line in the drop down while
start entering the letters of the items.
Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start
entering P itself Pen and pencils
How can we add so many conditions in IF function?
--
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
Hi,
Please correct my formula on this attachment.
On Wed, May 16, 2012 at 2:31 PM, Smitha S R wrote:
> Hi,
>
> Please suggest a formula on this attachment.
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles.
Hi,
Please suggest a formula on this attachment.
--
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 b
Hi
PFA the stock statement where I need help in the Dashboard. If I select,
the item I need the relevant closing stock in the next cell.
My formula is not working. Please help.
Thanks
Smitha
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
Thanks alot
On Wed, May 9, 2012 at 3:25 PM, Maries wrote:
> I think MACRO IS NOT ENABLED. When you open file, Security warning show
> under Ribbon. Click options ==> Select Enable this content ==> Press ok.
>
> Try now...
>
> On Wed, May 9, 2012 at 11:57 AM, Sm
Or Target.Column <> 2 Then Exit Sub
> If Target.Value = "Opening Stock" Then
> Target.Offset(0, 3) = "=VLOOKUP(RC[-1],'Closing St n Utlzn-Apr
> 2012'!R2C1:R65C3,3,FALSE)"
> Else
> Target.Offset(0, 3) = ""
> End If
> End Sub
>
> R
ing datas...
>
> =VLOOKUP(D2,'Closing St n Utlzn-Apr 2012'!$A$2:$C$65,3,FALSE)
>
> Regards,
>
> MARIES.
>
>
> On Tue, May 8, 2012 at 9:31 PM, Smitha S R wrote:
>
>> Hi,
>>
>> PFA the attachment.
>>
>> Office stock consumption statement is
Hi,
PFA the attachment.
Office stock consumption statement is attached where I need the help on
solving the explained below:
..
I need the closing stock of the relevant items from the other work sheet
'closing st n Utlzn-Apr 2012' in the column 'Qty' of the work sheet 'May
2012' if the particul
On Sun, May 6, 2012 at 2:37 PM, Smitha S R wrote:
> Hi,
>
>
>
> Any one please help:
>
>
>
> PFA the attachment of office stock.
>
>
>
> One sheet shows the closing stock of stationery items.
>
>
>
> In the second sheet, if I select particulars
Hi,
Any one please help:
PFA the attachment of office stock.
One sheet shows the closing stock of stationery items.
In the second sheet, if I select particulars as Opening stock I need toe
get the closing stock of that Particular item, else for Purchase and Issue
I have to manually ente
80 matches
Mail list logo