Extract the month name from a month Hi there, I have a month column with just a number like 1 , 7 etc. I'd like to see Jan instead of 1 and Jul instead of 7. Is there a formula for function for this. There is only one number in a column at one time. Any help would be greatly appreciated. Tx Grd ... 4 Feb 2010 12:20 Formula for adding a cell in multiple workbooks I want to add a cell from 52 different workbooks into another "Year End" workbook. Is there a formula that makes this easier than having to open all 52 workbooks at one time and going into each to select that cell for the formula? ... 3 Feb 2010 17:26 Calculating over multiple tabs I need to end up with a total of a person's expenses across multiple tabs. I do have a unique identifier. However, each person can only receive \$400 from each tab (category). But they may not be in all tabs. Thanks! ... 3 Feb 2010 14:02 Sumproduct Search, Sum Durations Hello, I have a table that I need to get information out of using Excel. Below is a sample from the detail data. systemslist severity Duration Minutes Fare System - NG 3 25 Fares System 3 25 Fare System - NG 2 15 Fares System 1 5 System Issues - PM 3 35 System Issues 2 10 Air System, Production System, Sys... 4 Feb 2010 13:29 Column total is wrong I have a column of figures which is the result of multiplied column A x Column B. Column B is a multiplier of .001665. The result is shown to two decimal places. When I total the results in Column B, using formula =SUM(B1:B2), it gives the result as 11.16 instead of 11.15. Can I fix this somehow so it give... 3 Feb 2010 17:26 Changing initials into numbers I have data that I download into Excel and initials are used for different people. I need to give those initials a number in excel for example MJ = 01, HS = 02..etc. Thank you. ... 3 Feb 2010 14:02 LOOKUP A VALUE IN A TABLE AND RETURN VALUE OF FIRST ROW IN THAT CO H1 holds criteria =INDEX(A1:F1,MAX(INDEX((A1:F11=H1)*COLUMN(A1:F11),))) "omarvn(a)gmail.com" wrote: Hi, In a table as follows, AC1 AC2 AC3 AC4 AC5 pn1 11 12 13 14 15 pn2 21 22 23 24 25 pn3 31 32 33 34 35 pn4 41 42 43 44 45 pn5 51 52 53 54 55 pn6 61 62 63 64 65 pn7 71 72 73 7... 3 Feb 2010 10:35 Advanced filter How do I include formulas from source database in the filtered results ... 3 Feb 2010 08:21 Adjust text to fit within an Excel Cell using C# I am developing a console application in which I have exported data from dataset to an Excel. I need to adjust the text to fit within the cells without using wordwrap. As my requirement is to achieve the data in every column in a single row. where my data in each column keeps varying. Below is the method code ... 3 Feb 2010 01:50 How to use two parameters in input of popup Variables - Gary's Student HI All Gary's Student kindly made some to code to allow input of variables via popup : Dim colstring As String Dim findit As Double, replacewith As Double colstring = Application.InputBox("Select Column ....", "Stage 1 of 3", Type:=2) findit = Application.InputBox("Column Selected : " & colstring & vbCr ... 2 Feb 2010 22:27