Functions
in [Excel]
|
text change I'll try this again as I accidentally hit the enter key after typing the subject. In a spreadsheet I have all of my staff listed by their abbreviated names used to identify them on our server. I want to be able to convert there abbreviated names like "gcarls" to "Carlson, Glen". I think one of the If formualt... 19 May 2010 14:55
Sorting Cube dimension names in a Pivot Table How do I get the dimension names in the "pivot table field list" sorted by the translated names? The pivot table field list contains: - one measure-node - one dimension node for each cube-dimension. The cube-dimension-nodes are represented by their translated names. It looks like, this names are not sorte... 19 May 2010 10:28
Ref in two worksheets I have a bank statement on a worksheet and want to show the current balance in another workbook. I can copy a link for the current balance to the other workbook but do not know how to update it when the bank statement is updated (i.e. in the next row down). Example: Bank statement Date Debit Credi... 20 May 2010 17:14
How do I resort numerical info into numerical order excel currently sorting numerical info into numerical/alphabetical order as 1,10,100 etc. instead of 1,2,3 etc. Anyone know how can set to resort as 123? ... 19 May 2010 08:15
copy rows to another file Dear Experts I have following code,i need to copy desirde rows to new file (r.xls) on sheet 1. This code is able to copy desired rows from active sheet to sheet2(same file) based on values in column G. Would you please guide me? regards Sub Marine() Dim arrParts() As String Dim MyRange As Range, CopyRang... 19 May 2010 03:56
CELL IS NOT ACCODATING MORE THAN 12 NUMBRS HOW TO ENTER 15 DIGIT I AM NOT ABLE TO ENTER MORE THAN 12 DIGITS I .E. 123456789012 THE CELL DOES NOT ACCOMMODATE - AFTER ENTERING: 123456789012345678 THE RESULT SHOWN IN CELL IS : 1234567E+15 HOW TO SOLVE THIS PRIOBLEM ... 19 May 2010 03:56
Calculating Turn Around Times excluding Sunday I need to track turn-around-times, date & time, excluding Sunday. The end result needs to be the number of dates to completion. In this case the result should be 4.25. What I have currently is: D76 E76 has Formula F76 Date Started Date Completed... 19 May 2010 09:21
vlookup from multiple sheets i have data in 10 different sheets (Sheet 2 to Sheet11)with identical columns. i need to use the vlookup function in Sheet1 taking the range from column E to H from each sheet. Is there any tool whereby i can make te vookup function once for all sheets and need not to use it for 10 times. regards ... 19 May 2010 03:56
EXTENSION OF EXCEL SHEET COLUMNS BEYOND IV GRID In worksheet I want to insert more column, but I can't do d same beyond grid IV (Ato IV). Is there any way? so that I can insert more columns as I desire!! waiting for Ur immeD8 response! Jayanta Pramanik ... 19 May 2010 13:48 |