First  |  Prev |  Next  |  Last
Pages: 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113
Formula for counting frequency then sorting
Hi guys, Need some help with this one. My worksheet looks a little like this; Col F Col X Barcode Round Number 14 1234123412341234 12341 15 8687686876868686 86876 16 7543275432754327 75432 17 24824... 7 Apr 2010 12:23
Using Worksheet Name
I am having multiple worksheets in an Excel file and now I want to use the name of each worksheet in a new worksheet in the same file. Is there a formula which can copy the name of worksheet into a Cell of another worksheet ... 7 Apr 2010 10:07
Disabling "cut" function - version 2003/2007
Hi there wlam, Paste this code in the "ThisWorkbook" VBA code module of the workbook you want to protect. Code is below. ----------------------- Const DisableCutOperations As Boolean = True Private Sub Workbook_WindowActivate(ByVal Wn As Excel.Window) If DisableCutOperations = False Then Exit Sub ... 7 Apr 2010 06:47
How to convert 115:14 into hours? ( 115 stands for hrs, 14 is
Chinared, Please use this formula to get a more accurate answer to indicate the hours and minutes. However, if you want to display the :14 as seconds then you should use a "." instead of a ":" in your question. =INT(A1/60)&":" &MOD(A1,60) -- Thank you and Regards Garreth Lombard "Fred Smith" wrot... 7 Apr 2010 04:37
Need to copy and match data from one workbook to another workbook
I have one workbook that has book information such as book code, title and author. I have another workbook that has the ISBN Number and the amount of revenue that it has made I need to look up the revenue by ISBN number on the one sheet copy and paste it to a different sheet that has the rest of the book infor... 6 Apr 2010 18:45
Inserting a calculated field in a Pivot Table in Excel 2003
In the past I know I have done this but I can't see the option now to insert a calculated field. Does someone know where this is located? Thanks so much. ... 6 Apr 2010 18:45
H and V lookup or match?
If I have the following data A B C D E NY MO IL NJ KS 1 Jim x x x 2 Joe x x x x 3 Amy x ... 6 Apr 2010 19:53
my paste special function won't let me copy formulas
I am using Excel 2007 and I can't seem to copy and paste formulas from one workbook to another. Instead I get a dialogue box asking me if I want to use paste or paste link and to chose from a list of formats. Does anyone know if there is something that I can change in Excel to fix this problem? ... 6 Apr 2010 19:53
Leading zero's trail Number
We use Excel for our memebrship data, on our zip code entires for NJ and Y which have a leading zero we get a blank. On last number in CC entry we only are able to display, 0, 1, or 2 -- How do we over come these issue? C-Ya GC ... 7 Apr 2010 01:22
Sumif across a table
I am looking for a function that works using a =sumif function to add things that are not in a range that are next to each other as seen below the letters in () are the columns that the values are in... so I am looking for a sum in column A "X" of the total work out time if the appl column is "Y" total wor... 6 Apr 2010 22:05
First  |  Prev |  Next  |  Last
Pages: 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113