hi Friend,
just use this formula in C7
=SUMIFS(C1:C5,$A$1:$A$5,A6,$B$1:$B$5,B6)
make sure that your A7 and B7 must have values used in critreria.
Regards
Prince
On Wednesday, March 13, 2013 7:07:02 PM UTC+5:30, cca...@gmail.com wrote:
>
>
> I'm trying to create an employee expense form. The lo
Hi Hilary.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$B$3" Then
MsgBox "Please Enter date In dd-mmm-yy Format"
End If
End Sub
Just Paste the following Code and modify the same according to your
Requirment.
Regards
Prince
On Tuesday, Mar
Great JOb Sir..
You are truly Inspirational for us..
Regards,
Vijay Tiwari
On Friday, August 3, 2012 11:10:25 PM UTC+5:30, Ayush Jain wrote:
>
> Dear members,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> July'12. He has posted 143 posts in July
Dear David,
Pl share your file .
Warm Regards,
Gawli Anil
On Thu, Mar 14, 2013 at 5:49 AM, Bé Trần Văn wrote:
> Using Validation or Combobox.
> You upload the File to handle for convenience.
>
>
> 2013/3/14 David Grugeon
>
>> Use a pivot table. If you need detailed instructions please ask.
>>
Just Press
ctrl+~
"~" this is a tiled sign right below to Esc Key
Regards
Prince
On Wednesday, March 13, 2013 3:27:03 PM UTC+5:30, Prabhakar S H wrote:
>
> Dear team,
>
> pls help me to fix formula in attached file.
>
> Rgds,
> Prabhakar
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exc
Using Validation or Combobox.
You upload the File to handle for convenience.
2013/3/14 David Grugeon
> Use a pivot table. If you need detailed instructions please ask.
>
>
> On Wednesday, 13 March 2013, wrote:
>
>>
>> I'm trying to create an employee expense form. The logic I'm trying to
>> sol
Use a pivot table. If you need detailed instructions please ask.
On Wednesday, 13 March 2013, wrote:
>
> I'm trying to create an employee expense form. The logic I'm trying to
> solve is to auto-populate single cells based on data entered in a separate
> range of cells by merging the common entr
Hi Jayendra,
I think "Save Workspace" fulfill your requirement
please check below link
http://office.microsoft.com/en-in/excel-help/save-workbooks-in-an-arranged-workspace-HP010250051.aspx
.
Enjoy
Team XLS
On Wed, Mar 13, 2013 at 7:34 PM, jayendra gaurav
wrote:
> De
Sam's response is basically asking why you do not simply create a shortcut
on your Windows Desktop rather than an Icon in Excel.
You can even drag this shortcut to your Windows quick-start menu
or Pin it to your Windows Taskbar in Windows 7.
as far as creating a custom icon in Excel...
you can d
Rightclick on desktop, click on new then shortcut, then put the entire file
path and next... and an appropriate name for the link.
On Wed, Mar 13, 2013 at 8:32 PM, jayendra gaurav
wrote:
> how can i do it
>
>
> On Wed, Mar 13, 2013 at 7:37 PM, Sam Mathai Chacko wrote:
>
>> Why don't you just cre
Great tool, thanks.
Can it also return the latitude and longitude?
Thanks.
On Monday, February 27, 2012 1:44:19 AM UTC-6, Prynka wrote:
>
> Nice one..
>
> On Sat, Feb 25, 2012 at 6:42 PM, Maries >wrote:
>
>> *Great!!! Thanks Ashish...*
>>
>>
>> On Sat, Feb 25, 2012 at 5:01 PM, ashish koul
how can i do it
On Wed, Mar 13, 2013 at 7:37 PM, Sam Mathai Chacko wrote:
> Why don't you just create a shortcut pointing to your file?
>
>
> On Wed, Mar 13, 2013 at 7:34 PM, jayendra gaurav <
> jayendra.gau...@gmail.com> wrote:
>
>> Dear All,
>>
>> I need to open one exel file frequently .I requ
Why don't you just create a shortcut pointing to your file?
On Wed, Mar 13, 2013 at 7:34 PM, jayendra gaurav
wrote:
> Dear All,
>
> I need to open one exel file frequently .I require one icon on my tool bar
> where if I clicked then my file need to open.
>
> this feature was available in exel 20
Dear All,
I need to open one exel file frequently .I require one icon on my tool bar
where if I clicked then my file need to open.
this feature was available in exel 2003.
kindly support me.
--
J.Gaurav
Call-7838594954
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? I
I'm trying to create an employee expense form. The logic I'm trying to
solve is to auto-populate single cells based on data entered in a separate
range of cells by merging the common entries.
For example:
1) in cells A1:A5, the user will TYPE IN the following job numbers: A1=AG,
A2=Waterfron
Dear Prabhakar,
Ur formular is right just goto formula tab and click on show formula.
I think u have clicked on show formula that's why it shows only the formula.
Once angain click on show formula and see the changes.
Warm Regards,
Gawli Anil
On Wed, Mar 13, 2013 at 3:27 PM, Prabhakar S H wrote
Dear team,
pls help me to fix formula in attached file.
Rgds,
Prabhakar
--
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
Hi All,
How many Control chart / Defect chart are there in a Business to identify
Business / Process defect? I know some of them, like Pareto analysis,
Fishbone diagram, but are there any other chart is available to measure the
defect? If so, then please provide me some samples.
Thanks in advance
Dear Kannam
Can u explain it more? if possible with Example
Regards
Shrinivas
On Wed, Mar 6, 2013 at 10:33 AM, kannan excel wrote:
> PLS HELP ME
>
>
>
> -- Forwarded message --
> From: kannan excel
> Date: Tue, Feb 26, 2013 at 11:59 AM
> Subject: URGENT PLS HELP ME IN EXCEL WORK
19 matches
Mail list logo
