ndow. Now go to Tools, Protect Sheet and
> protect the worksheet. Only those cells will be protected which has been
> locked using format cells window. Hope this helps'
>
> Sent from my iPhone
>
> On 21-Jan-2013, at 1:23 PM, सुनिता पौडेल wrote:
>
> Thanks but that way i
I have tried to explain what I want it to be in comment box. I hope I am
able to explain.
Thanx
On Fri, Aug 3, 2012 at 12:09 PM, अनिल नारायण गवली
wrote:
> pl share a data with groups.
> Regards,
> Gawli Anil
>
> On Fri, Aug 3, 2012 at 11:52 AM, सुनिता पौडेल wrote:
>
>>
Dear all,
Is there any possibility to create a small table where data can be put to
clarify the reason of the amount of one certain cell instead of inserting a
comment box? I mean if we can insert a table instead of only text like in
insert box.
If it is possible then it will help me on my work a
le that automatically makes a drop down in range d9
>> when you activate the sheet and when you select the date from the drop down
>> will populate the cells.
>>
>>
>> Don Guillett
>> Microsoft Excel Developer
>> SalesAid Software
>> dguille...@gmail.c
Thank you soo much
I will try it
have a nice weekend
Sunita
On Fri, Jul 20, 2012 at 5:16 PM, Deba Ranjan wrote:
> Hi Sunita Ji,
>
> PFA... might help you out your Query.
>
>
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
>
>
>
> On Fri
Dear all,
In this attached file there is data in one sheet 1, I want the same account
head amount from the sheet 1 to appear in sheet 2. Is it possible?. I tried
manually but takin time so if you all could help me on this.
Thank you very much for the cooperation.
Regards,
Sunita
--
--
FORUM
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelvbaclinic.blogspot.com
>
>
> On Thu, Jul 19, 2012 at 3:08 PM, सुनिता पौडेल wrote:
>
>> it shows 1:0
>>
>> thnx
>>
>> On Thu, Jul 19, 2012 at 2:57 PM, NOORAIN ANS
quot;/"),LEN(TEXT(A1/B1,"/"))
> -FIND("/",TEXT(A1/B1,"/"
>
>
> On Thu, Jul 19, 2012 at 2:07 PM, सुनिता पौडेल wrote:
>
>> not working .is it because add-ins blah..
>> thnx
>>
>> On Thu, Jul 19, 201
not working .is it because add-ins blah..
thnx
On Thu, Jul 19, 2012 at 1:58 PM, Krishnaraddi V. Madolli <
krishnaraddi.mado...@asia.xchanging.com> wrote:
> http://spreadsheetpage.com/index.php/tip/a_formula_to_calculate_a_ratio/*
> ***
>
> ** **
>
> ** **
>
> Regards,
>
> ** **
>
> Krish
Dear all,
Please do me one favor. I tried to find out the ratio between two numbers
but seems the formula isn't working. So can you please help me.
Thank you
Sunita
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
gt; paste in Cell *E2*
> *=SUMPRODUCT(--($E$10:$E$46=$E$1)*($D$10:$D$46=C2))*
>
>
> On Fri, Jul 13, 2012 at 1:22 PM, सुनिता पौडेल wrote:
>
>> Hi,
>>
>> Still not working :(
>> its 2010
>>
>> On Fri, Jul 13, 2012 at 12:04 PM, NOORAIN ANSARI <
>
Thank you so muck Krishnaraddi ji. Still wondering where it went wrong.
Anyway thanks heaps.
Sunita
On Fri, Jul 13, 2012 at 1:53 PM, Krishnaraddi V. Madolli <
krishnaraddi.mado...@asia.xchanging.com> wrote:
> "CONFIDENTIALITY NOTICE: This message and any attachment are confidential
> and may al
;> Hi Sunita,
>>
>> Please Try it..
>> =COUNTIFS($E$10:$E$46,$E$1,$D$10:$D$46,C2)
>>
>>
>>
>>
>> On Fri, Jul 13, 2012 at 11:31 AM, सुनिता पौडेल wrote:
>>
>>> Dear all,
>>>
>>> however this is not working out , c
Dear all,
however this is not working out , can you please solve this where i went
wrong/
thnx
On Thu, Jul 12, 2012 at 3:36 PM, सुनिता पौडेल wrote:
> wohoo so may options thnx guys ..it really worked out
>
> thank you so much
>
> Sunita
>
> On Thu, Jul 12, 2012 at 3:
ARI
> wrote:
>
>> Hi Sunita,
>>
>> You can also *try..
>>
>> =SUMPRODUCT(--($E$10:E49="GIRL"))*
>>
>> On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल wrote:
>>
>>> Dear all,
>>>
>>> Can you please help me to find ou
wow thnx...
is there any way to find out like in certain grade how many girl or boy
studies??
Thank you
On Thu, Jul 12, 2012 at 3:11 PM, Rohan Young wrote:
> just correct your answer
>
> =COUNTIF($E$10:E49,"GIRL")
>
> On Thu, Jul 12, 2012 at 2:54 PM, सुनिता प
Dear all,
Can you please help me to find out the total number of boy and girl ? I
used countif for their grade and it worked. However, for girl and boy
seggregation it isnot working.
Thank you very much for the support you all have been providing.
sunita
--
FORUM RULES (986+ members already BA
it the same.
>
>
>
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
> ****
>
>
> On Wed, Jul 11, 2012 at 2:32 PM, सुनिता पौडेल wrote:
>
>> Dear Deba ji,
>>
>> Can you please check where I went wrong? Sorry for giving you trouble
>> again
m/excel-vba/assign-hotkey-to-smartdel-macro.shtml
> http://www.mrexcel.com/archive/VBA/3401b.html
>
>
>
>
> On Tue, Jul 10, 2012 at 4:22 PM, सुनिता पौडेल wrote:
>
>> Dear all,
>>
>> This is very useful information and I have been trying to use it at my
>&
Dear all,
This is very useful information and I have been trying to use it at my
work. Since, I am in beginner phase can you please teach me as to how to do
it from the scratch?
Thank you all,
Sunita
On Tue, Jul 10, 2012 at 12:02 PM, NOORAIN ANSARI
wrote:
> Dear Amit,
>
> Try it..
>
>
> *Appli
Wow congratulations to both experts !! :)
On Mon, Jul 2, 2012 at 1:40 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
> congratulation both of you
>
> Regards,
>
> Sanjib
>
> On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain wrote:
>
>> Dear members,
>>
>> I am extremely happy to inform yo
B$2:$B$15,$A$2:$A$15),2,0)
>> *
>> Through Lookup
>>
>> *=LOOKUP(2,1/((LARGE($B$2:$B$15,1)=$B$2:$B$15)),$A$2:$A$15)
>> *
>> Through Indirect
>>
>> *=INDIRECT("A"&MATCH(LARGE($B$1:$B$15,1),$B$1:$B$15,0))
>> *
>>
>> See
Thanx :)
On Mon, Jun 25, 2012 at 1:08 PM, Shaik Waheed wrote:
> Hi Sunita,
>
> In my case, I have used filters since it becomes more easier
>
> On Mon, Jun 25, 2012 at 12:49 PM, सुनिता पौडेल wrote:
>
>> did you filtre the column?
>> thank you
>>
>>
Can you please little explain about 1 in last
=INDEX($A$2:$A$15,MATCH(I2,$B$2:$B$15,0),1)
Thank you,
On Mon, Jun 25, 2012 at 12:51 PM, Anil Gawli wrote:
>
> Pls find attached sheet FY Ref.
> On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल wrote:
>
>> Dear all,
>&g
did you filtre the column?
thank you
On Mon, Jun 25, 2012 at 12:47 PM, Shaik Waheed wrote:
> PFA
>
>
> On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल wrote:
>
>> Dear all,
>>
>> It has always been previlege to query on this group whenever needed and
>> t
Dear all,
It has always been previlege to query on this group whenever needed and
thanks from heart.
I need one help regarding finding out maximum number and their name in one
cell ?
Have a wonderful day !!
Thank you!!
Sunita
P.S: in case if file not attached(having probs)
name amount*
Thank you very much for the prompt action. It works as per my requirement.
Have a wonderful day!
On Fri, Jan 20, 2012 at 2:56 PM, PrIyAnKa wrote:
> Dear Sunita
>
> Kindly find the attached file
>
> Hope this is as per your req
>
>
> 2012/1/20 सुनिता पौडेल
>
>&g
ng format as per your requirement takes a
> lot time
>
> So kindly provide one output example in output format
>
>
> 2012/1/20 सुनिता पौडेल
>
>> Dear all,
>>
>> Can you please help me on resigned staffs statistic? I need the
>> information as below:
&g
Dear all,
Can you please help me on resigned staffs statistic? I need the information
as below:
the number of resigned staffs in 2006 and ratio of resigned staffs
> male:female
>
Like wise till 2012
>
Your help will be highly effective for my work.
Regards,
Sunita
--
FORUM RULES (986+ mem
29 matches
Mail list logo