In cell F5 try the following formula:
=CHOOSE(MONTH(E5),"January","February","March","April","May",
"June","July","August","September","October","November","December")
On Wed, Feb 2, 2011 at 2:39 AM, solomon raju wrote:
> Hi All,
>
> How can we extract month in text. Can someone define some
Jay
Try putting the following formula in cell C3:
=LEFT(B3,FIND(" ",B3,1))
Norman
On Wed, Aug 25, 2010 at 4:56 AM, lucky singh wrote:
>
> Hi,
>
> Need help in formula...
>
> I just need the only the first name to be extracted without space or gap...
>
> Regards,
> Jay S
> 8108932708
>
> --
>
> -
Colvert,
Try downloading P O Master from the following link:
http://www.scribd.com/doc/5443728/PO-Master-06-25-09
You will have to be a member to download.
Membership is free.
Norman
On Mon, Mar 22, 2010 at 5:05 PM, lecolvert wrote:
> Good Morning all,
> I want to create a macro that can gen
Try the following attached file
This is a left lookup
On Thu, Mar 18, 2010 at 5:01 AM, Venkatesan c wrote:
> Dear All,
>
> Any one can Assist me attached file query It's something like reverse
> Lookup
>
> --
>
> --
In cell G2 enter the following array formula:
=INDEX($C$3:$C$14,MATCH(E3 & F3,$A$3:$A$14&$B$3:$B$14,0))
Remember to press Ctrl+Shift+Enter when entering an array formula.
Then copy down.
Norman
On Mon, Mar 15, 2010 at 4:02 AM, OSAVentures Calamba wrote:
> dear helpful experts,
>
> how to find
Venkat,
If 8:59:44 is in cell A1, try the following formula:
=SUM((HOUR($A$1)*3600),(MINUTE($A$1)*60),(SECOND($A$1)))
Norman
On Wed, Mar 10, 2010 at 9:02 AM, Venkatesan c wrote:
> 8:59:44 into Decemical seconds is there any formula anyone help me
>
> Thanks & Regards
>
> Venkat
>
> --
>
> -
In Excel 2003 go to Tools/Options/Edit then remove the check mark from "Move
selection after enter".
Norman
On Mon, Jan 25, 2010 at 6:38 PM, Wilbur Kush wrote:
>
>
> I have a scale that inputs data into excel via rskey, a keyboard
> emulator that comes with the scale. No problems getting the data
The following might be helpful:
http://www.scribd.com/doc/5401866/Account-Register-12-10-09
To download this document you will have to become a member, but it's free.
Use the filters to get desired totals.
Norman
On Tue, Jan 26, 2010 at 1:45 AM, Robinson Boreh wrote:
> Hi guys,
>
> I am doing
This might help you:
http://people.hofstra.edu/Stefan_Waner/RealWorld/Excel/tuts/ExcelPivot.xls
Norman
On Mon, Jan 11, 2010 at 4:15 PM, larry wrote:
> I am trying to use the Gauss/Jordan method as a subrouting in my code.
> This is code that lets you put linear equations into a matrix and then
;
> Thanks a lot bro
>
> Cheers!
>
> Hems
>
> On Thu, Dec 17, 2009 at 6:26 AM, Norman May wrote:
>
>> Hopefully this is what you wanted.
>>
>> Norman
>> On Tue, Dec 15, 2009 at 12:56 PM, Hems wrote:
>>
>>> Hello All,
>>>
&g
Try the following formula in cell C11
=IF(ISNA(VLOOKUP(A11,E2:F6,2,0)),"Not Found",VLOOKUP(A11,E2:F6,2,FALSE))
On Sun, Nov 29, 2009 at 10:15 AM, mahesh parab wrote:
> Dear All
>
> In attach sheet i want to find matching text from another column, Can
> anyone help for
> formula.below mention for
Jitesh
Try formatting the cells as TEXT
Norman
On Fri, Nov 27, 2009 at 5:40 AM, Jitheesh Vazhapully <7jit...@gmail.com>wrote:
> Good Evening Excel Gurus,
>
> I have a data in this format 01-01-01, however as soon as I enter them in
> the excel sheet,excel picks it up as date and stores it in d
The workbook is protected with a password.
Norman May
On Thu, Nov 12, 2009 at 11:09 AM, mahesh parab wrote:
> Dear All
>
> In attach sheet when i try to unhide sheet i am getting caption error.
> steps are mention on below mention link
>
> http://www.ehow.com/how_2132122_work
Pooja,
Try the following formula in cell D6, then copy down:
=IF(ISERROR(FIND("e",B6)),"",RIGHT(B6,((LEN(B6))-(FIND("e",B6)))+1))
Norman
On Sat, Oct 31, 2009 at 10:55 AM, Pooja Sharma wrote:
> Hi All,
>
> I need your help in extracting some words (having defined format) from one
> cell in anoth
Try looking at the DATEVALUE function in Excel.
On Fri, Oct 30, 2009 at 8:00 AM, manni...@nationwide.com <
manni...@nationwide.com> wrote:
>
> I'm using a access macro to export access crosstab query results to
> excel. Everything works
> great, except that the column names are dates that expor
Tommy,
Just after the beginning of you macro:
Application.ScreenUpdating = False
And just before the end:
Application.ScreenUpdating = True
Norman
On Thu, Sep 17, 2009 at 10:10 PM, Tommy wrote:
>
> I have a rather long macro, which when running causes distractful
> fluttering of the screen,
Pooja,
Here is a couple of websites that accomplish this with a user defined
function (UDF).
http://www.exceltip.com/st/Count_by_color_using_VBA_in_Microsoft_Excel/518.html
http://www.ozgrid.com/Excel/count-sum-cell-color.htm
Norman
On Tue, Sep 15, 2009 at 1:45 AM, Pooja Sharma wrote:
> Hi Fri
Enter the following array formula in cell G14 then copy it down to G22:
=RANK(E14,$E$14:$E$22,0)-SUM(IF(FREQUENCY($E$14:$E$22,$E$14:$E$22)>0,0,1)*IF($E$14:$E$23>E14,1,0))
This formula must be entered as an array formula using (Ctrl + Shift +
Enter).
This formula came from the website below:
htt
Enter the following formula in cell J7 and copy it down:
=INDEX($C$6:$G$6,MATCH(I7,C7:G7,0))
Norman
On Tue, Sep 8, 2009 at 2:46 AM, gyanesh jain wrote:
>
> Hi friends,
> I have some Query related with Lookup. its in attachment.
>
> can any provide the solution?
>
> --
> Thanks,
> Gyanesh Jain,
You can select the first sheet tab, hold the shift key then select the last
sheet tab.
This will activate all sheets.
Enter the desird content of the any cell
On Mon, Sep 7, 2009 at 5:53 AM, rmullan wrote:
>
> Hi.
>
> I have been using Excel for years but never really needed to get into
> VBA to
Eric,
If your Begin Date is in cell A2 and cell B2 has the Number of years.
To calculate the Renewal Date try the following formula in cell C2:
=A2+(B2*365.25)
Begin DateYearsRenewal Date
-
10/25/2005410/25/2009
Norman
This might be helpful.
http://www.cpearson.com/excel/TimedClose.htm
Norman
On Thu, Aug 27, 2009 at 7:50 AM, Jack wrote:
>
> i need some vb to check if the time is greater than eg IF Application
> TimeValue > ("08:00:30") Then
> activeworkbook.close
>
> Any ideas
>
> Many thanks
>
> >
>
--~--~
Suresh,
This might help you
http://www.mrexcel.com/hof001.php
Norman
On Thu, Aug 27, 2009 at 7:21 AM, suresh k wrote:
> Hi Guyz,
>
> Whenever we use conditional formatting it will be applied for current cell
> only.
>
> Is there anyway that if the condition is true the entire row should be
> co
Michael,
I'm not sure if this is what you want:
51556 is the number that calculates $500
=IF(A11>51556,500,IF(A11<=6000,IF(A11<0,#VALUE!,ROUND(A11*0.012,2)),72+ROUND((A11-6000)*0.009+18,2)))
Norman
On Fri, Aug 21, 2009 at 4:36 PM, Michael484 wrote:
>
> I am trying to set up a formula to cal
I'm not sure if this is what you want...
Example:
="The amount in cell A1 is "&A1&" and this will change daily."
On Tue, Aug 4, 2009 at 11:48 AM, Jaspal Rehal wrote:
>
> Hi,
>
> I have to delete so many cell entries in my daily job and input those
> cell entries in the comments with some text
Rajesh,
Try the formula below:
=INDEX(B1:B12,MATCH(9.99E+307,B1:B12))
Norman
On Mon, Aug 3, 2009 at 1:01 AM, Rajesh Janardanan wrote:
>
> Dear All,
> Need an urgent help , please refer the attached file , I need a formula
> which will read YTD (B13) as the last cell entered , in the
A Hakim,
I have an invoice workbook at the website below, it might be helpful.
http://sites.google.com/site/normay/excel-files
Norman
On Thu, Jul 30, 2009 at 10:53 AM, Abdul Hakim Khan wrote:
> Dear All,
>
> I want to develop an excel template to automate invoicing jobs.
>
> The problem is as
This modified code seems to work
Public Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
'Application.EnableEvents = False
On Error GoTo Errorhandler
Target.Offset.Offset(0, 13) = Now()
'Application.EnableEvents = True
End If
Errorhandler:
Attached is a solution.
Subtotal is not what you want to use.
This is done with dynamic named ranges and data validation.
Norman
On Wed, Jul 15, 2009 at 6:07 AM, Rabindra Thapa wrote:
> Hello Guys,
>
> can somebody help me on attach file.
> --
>
> Regards,
> Rabindra Thapa
> ¨`·.·´¨) Always
> `·
Manoj,
In the find and replace box precede the asterisk with a tilde.
Example: ~*
Norman
On Wed, Jul 8, 2009 at 6:06 AM, Manoj S Negi <
manojsnegi.uttranc...@gmail.com> wrote:
> Hi Friends,
>
> Please help meas my query is as follows...
> In the attached sheet in column there is s
Is this segment of code in a looping macro that cycles through the entire
workbook?
Norman
On Sun, Jul 5, 2009 at 10:54 PM, Norman May wrote:
> Try this:
>
> ActiveSheet.Cells.Replace What:="1234", Replacement:="", LookAt:=xlWhole, _
> SearchOrder:=xlByRows
Try this:
ActiveSheet.Cells.Replace What:="1234", Replacement:="", LookAt:=xlWhole, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False
Norman
On Sun, Jul 5, 2009 at 9:14 PM, Ritland wrote:
>
> I know this must be a simple quesiton but I'm stumped. I wanted to
Try this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Value = 0 Then
MsgBox "000"
'Sheets("Parametervalg").Select
Columns("G:K").EntireColumn.Hidden = True
End If
If Target.Value = 1 Then
MsgBox "111"
Columns("G:K").EntireColumn.Hidden = False
End If
End Sub
Can you simply format the cells to SPECIAL then choose PHONE NUMBER?
Norman
On Tue, Jun 9, 2009 at 7:38 AM, amrahs k wrote:
> Dear Harmeet and Team,
>
> I have attached a sample file for your reference with my simple query.
>
> Could you please look into this and advice me to proceed further.
>
There is an account register at:
http://scribd.com/ncmay
Norman
On Sat, Jun 6, 2009 at 11:36 PM, Ashish Jain <26may.1...@gmail.com> wrote:
>
> Hi Ryan,
>
> Did you tried templates on Microsoft website? Here is the link, plz
> reply with your feedback.
>
> http://office.microsoft.com/en-us/templ
The attached workbook will display the sum of column A in a message box
whenever there is a change in column A.
Norman
On Fri, May 29, 2009 at 10:47 AM, Ramesh Katta wrote:
>
> Hi Gurus,
>
> I am Ramesh, new to vba programs. I need a macro to calculate sum for
> range of column. The should be
Try the link below:
http://www.ozgrid.com/News/excel-validation-tips.htm
Norman
On Thu, May 28, 2009 at 12:09 PM, Ahmet Yalcin wrote:
> Hello Paul,
>
> Thank you. What I am trying is to gather data from same address on many
> sheets in my workbook. The name of the file is 2008-04 BIL.xls and
I'm not sure if this will work.
Try replacing the + with &
Norman
On Thu, May 28, 2009 at 10:19 AM, Ahmet Yalcin wrote:
> Hello,
>
> Please help me with the right syntax writing the below
> ActiveCell.FormulaR1C1 = "='[2008-04 BIL.xls]+Company(x)'!D7" line. I wish
> to insert the Sheet name as
Paste the following formula on sheet 2 cell B5:
=SUMPRODUCT((Sheet1!$C$5:$C$5)*(Sheet1!$B$5:$B$5=A5))
Norman
On Wed, May 27, 2009 at 7:47 AM, venkat sudhakar wrote:
> Dear Friends,
>
> Please find sample file attached.
>
> Regards,
> Venkat.
>
>
> On 27/05/2009, Dave Bonallack wrote:
>>
Try the link below:
http://www.mrexcel.com/archive/Formatting/12054.html
Norman
On Tue, May 19, 2009 at 1:50 PM, Balla wrote:
>
> Hi,
>
> M using excel 2003, and say i need to have this below rule for a cell
> if value is "india", background color blue
> if value is "aus", background color yel
gt; 1 final Question Norman,
> Sorry.
>
> If for example instead of a number I am using a word, how would i do the
> same,
>
> i.e. if i want when A1 is showing 'other'... i want "Please State Below" to
> display
>
> Thanks again for all of your help so
If the exposure cell is A1, try the following formula:
=IF(A1>501,"Urgent Action Required",IF(A1>300,"Action Required","No Action
Required"))
Norman
On Fri, Apr 17, 2009 at 10:47 AM, healthandsafetysupp...@googlemail.com <
healthandsafetysupp...@googlemail.com> wrote:
>
> Hi,
>
> Im a bit stuck
Steve,
You can do it with a simple formula if you want:
If you have data in cell A2 and B2 you want to join, the following formula
will work:
=A2&" "&B2
Then you can copy and paste special (Values)
Norman
On Mon, Apr 6, 2009 at 4:55 PM, Steve wrote:
>
> Hi,
>
> I could really use some help
Try using the Subtotal function.
Norman
On Thu, Apr 2, 2009 at 12:43 PM, Dave wrote:
>
> I am currently using a SumIF function that works fine, hoever, I
> applied a series of custom views with filtered row items and the
> Totals remain the same (i.e., still grabing the data from the "hidden
>
Ankur,
Here is a link to an attendance sheet I made.
I'm not sure it will do what you want.
http://www.scribd.com/doc/6078466/Attendance-History-091708
Norman
On Mon, Mar 30, 2009 at 2:42 PM, ankur lodha wrote:
>
> hi everyone
>
> i've a task to prepare an attendance register of 10 candidates
Sachin,
Attached is your solution.
It is done by using conditional formatting.
Regards,
Norman May
On Wed, Mar 25, 2009 at 6:47 AM, Sachin Shukla wrote:
> Dear All,
>
> Please help me on said subjects . I attached sheet for same problem.
>
> Thanks in Advance
>
>
>
I'm not sure if his would help you?
Download Personnel Timesheet 08-12-07.xls at http://normay.741.com/
Norman May
On Sat, Jan 10, 2009 at 1:44 PM, How Do you? wrote:
>
> I'm using excel to do weekly time sheet and I created another page/tab
> with in the same workbook and
Sathish,
Try ownloading the following file:
http://www.scribd.com/doc/5402351/Personnel-Timesheet-081207
Let me know if this helps.
Norman
On Sat, Nov 22, 2008 at 9:16 AM, Sathish Jalendran <[EMAIL PROTECTED]>wrote:
>
> Anand thanks for the help but the condition is if it should not consider
>
PRADEEP
If it is the last 6 characters you need, place the following formula in cell
C4. =RIGHT(B4,6)
Then copy the formula down as far as you want.
Norman
On Sun, Oct 19, 2008 at 9:45 AM, Mattathil M. Pradeep
<[EMAIL PROTECTED]>wrote:
> Dears..
>
>
>
> How to copy particular data from one c
49 matches
Mail list logo
