|
|
|
|
0 |
135 |
|
|
|
February 9th, 2010 02:30 PM
by Bernd P
|
2 |
149 |
|
|
Extract portions of text by
Lupe
Hi,
I have a list of names comprised like this:
Cook, Mr. M.S.
Marty, Miss M.S.R.
Constant, Mrs. R.G.L.
We only have Mr., Miss and Mrs.
I need to extract...
|
|
2 |
108 |
|
|
|
|
4 |
259 |
|
|
Stock control spreadsheet by
Rocket
I thought I had posted this previously but ommited the subject and I don't
think it did post.
Although I have used Excel for years I have never had the need...
|
February 9th, 2010 12:42 PM
by Rocket
|
0 |
166 |
|
|
Stock control formula by
Rocket
Although I have used Excel for years I have never had the need to use a
complicated formula.
I am trying to set up a stock control spreadsheet where multiple...
|
February 9th, 2010 12:15 PM
by Rocket
|
0 |
117 |
|
|
How convert Numeric number in words by
Imran Murtaza[_2_]
Is there any easy formula or way to convert numeric values in words? For
example in cell A1 there is an amount 19549. How could it will be
automaticaly...
|
February 9th, 2010 10:59 AM
by Mike H
|
2 |
154 |
|
|
Function needed? by
Annie
I need to learn how to compare two spreadsheets in Excel to identify
differences between the two. For example, if I have one spreadsheet with a
list of staff...
|
|
1 |
112 |
|
|
|
|
4 |
111 |
|
|
If count by
js20217075
start date end date
01/01/2010 01/01/2010
01/01/2010
01/01/2010
01/01/2010 01/01/2011
01/01/2010
01/01/2010
I want...
|
|
6 |
104 |
|
|
Weeknum in 2010 incorrect by
Paul Janssen
Hello, we encountered a faulty weeknumber generated by MX Excel for all dates
in 2010 as of Jan 3d, 2010. This should be weeknumber 1 until January 9th,
2010...
|
|
6 |
191 |
|
|
Another SUMPRODUCT Question by
enna49
Hi
Not certain whether this can be done. What I am trying to do is count the
No of Accounts, the report could have many rows of the same Account No and I...
|
|
5 |
134 |
|
|
|
|
2 |
133 |
|
|
5th Char in a cell by
enna49
Hi
I know this is simple, and I know I should know it, but I cannot get it to
work and I have searched Help and the answers seem more complicated than what...
|
February 9th, 2010 05:01 AM
by enna49
|
3 |
139 |
|
|
|
|
1 |
128 |
|
|
If,Then Statement by
Lizz45ie
How do I write a If statement that compares the next row and then divide a
number that is in another column. Here is an example of my data:
sales order ...
|
February 9th, 2010 03:35 AM
by Sheeloo
|
1 |
109 |
|
|
Date minus work days by
HK[_2_]
In A1 i have: 29-May-2010
In A2: 20 (workdays)
In A3: 13-May-2010 (holiday)
In A4: 24-May-2010 (holiday)
I need to find the date of A1 minus number of...
|
February 9th, 2010 02:52 AM
by HK[_2_]
|
8 |
134 |
|
|
Dependent dropdowns by
Dave
Hi,
XL2003
I have many named ranges in my workbook. Relevent ones a
"Components" "ResTH" (without the quotes).
On my worksheet:
Cell A2, Data Validation...
|
|
4 |
155 |
|
|
|
|
29 |
306 |
|
|
retrieve data from different workbook by
jat
good day,
I have workbook A and workbook B;
in workbook A cell C9 has a value (31); in workbook B, there is a worksheet
named 31; regardless of the...
|
|
1 |
115 |