|
|
|
April 16th, 2008 05:45 PM
by Pete_UK
|
1 |
89 |
|
|
Removing Digit Separator by
Daze
I've string of digits like this 111/2222/33333. How can i change it to
111222233333?
--
Daze
|
July 23rd, 2008 08:42 AM
by Dennis
|
2 |
50 |
|
|
Cells are not sorting correctly by
Daze3Daze
Hi...I'm trying to sort a column of percentages from highest to lowest
I unhide and highlight all the columns (so they stay together) and then hit...
|
|
2 |
93 |
|
|
Concantenate columns with dates and text by
Dazed and Confused
The first two columns in my spreadsheet are dates. The third is text. When
I try to concantenate, the dates turn into numbers.
Any advice would be greatly...
|
|
2 |
57 |
|
|
transferring files by
DAZED AND CONFUSED
I SENT A FILE FROM THE OFFICE USING EXCEL, AT HOME I HAVE XP HOME, HOW CAN I
READ IT WITHOUT BUYING FURTHER SOFTWARE.
|
|
2 |
104 |
|
|
|
|
1 |
82 |
|
|
List top five by
Dazed&Confused
Hi there,
I've searched this site looking for an answer for this but no luck
What I have is imported list of invoices thousands of rows long with about
450...
|
|
4 |
221 |
|
|
Insert Current Date when cell is empty?? by
Dazed&confused!
HI
Apologies for this - I just seem to have left my brain at home today.
Essentially I'm calculating the time difference in hours between IssueLogged
and...
|
|
4 |
60 |
|
|
Update of cell values after insert row? by
dazman
Hi,
I have a worksheet where using VBA I am inserting a new row and setting
cell values
in the new row to values specified in other worksheets. I can...
|
August 23rd, 2005 07:07 AM
by dazman
|
2 |
162 |
|
|
Real Value of .UsedRange.Rows.Count by
dazman
Hi,
In VBA I'm setting a variable as follows:
NumRows = Sheets("Summary").UsedRange.Rows.Count
and NumRows is subsequently used to make sure a chart has the...
|
August 25th, 2005 03:24 PM
by dazman
|
2 |
106 |
|
|
Implied Compound Interest? by
dazman
Hi,
I've just checked all the Excel Compound Interest functions but I can’t
seem to find the exact one for calculating implied compound interest.
I have a...
|
|
4 |
97 |
|
|
If Formula by
dazoloko via OfficeKB.com
Dear All
I have two columns (A and B) that Contain a "Y" or "N" in column A and a Date
or Blank in Column B.
If A = "Y" and B has a Date in the Result is...
|
|
6 |
99 |
|
|
Formula by
dazoloko via OfficeKB.com
Dear All
Im wandering if someone can assist.
I have two columns each containing a Monetary Value
Amount Chargeable and Potential Charge
Im after an If...
|
|
3 |
69 |
|
|
|
September 10th, 2005 01:17 PM
by Ian
|
2 |
71 |
|
|
Conditional formating for text by
dazp1970
I am using conditional formatting to change the colour of cells that contain
text.
What I am trying to do is format cells so that those that do contain text...
|
April 27th, 2007 07:10 AM
by Max
|
1 |
56 |
|
|
converting a decimal to time by
dazp1970
I want to be able to convert a decimal into time, and am completely stuck!
As an example, I have in cell A1 4.9 (this number represents 4.9hrs).
I want a...
|
|
3 |
55 |
|
|
EXCEL FUNCTIONS by
DAZZER
I WANT TO SORT NUMBERS, ODD FROM EVEN, AND THE MOST PREFERRED IN A GROUP OF
23 NUMBER. HELP?
|
|
2 |
67 |
|
|
Fast fourier transforms by
dazzler2058
Can anyone tell me how to use the the output from the fast fourier analysis
tools?
|
|
0 |
84 |
|
|
45 Day Count Down Timer by
da_bigone
I am creating a worksheet to track a 45 day window. I need the worksheet to
count down in days from 45 to 1 in column L from any date entered in column K.
45...
|
August 30th, 2009 11:43 AM
by Joel
|
1 |
129 |
|
|
Mathematical elimination by
da_big_k
how could i use excel to eliminate certain feilds
like how leagues are able to eliminate certain teams for playoff...
|
|
2 |
79 |