|
|
Sorting by
dleo
I have a long list of people extracted from a database. Some of the names are
in the format of "John Smith" or "Jane Smith" on different lines, but some of...
|
February 3rd, 2009 10:15 PM
by dleo
|
2 |
133 |
|
|
|
|
2 |
168 |
|
|
Progress Report by
[email protected][_2_]
Hi
I have 4 columns as follows Call1, Call2, Call3, Call4 and then %
Complete.
So if Call1 has a date in it then the Complete Column should show 25%,
if...
|
|
2 |
118 |
|
|
Self Calculation by
Satya
Is it possible to set a format to a cell so that if I enter a value it
returns with adding 15% to it. For example if in A1 I enter 100 it should
return 115...
|
February 3rd, 2009 12:40 PM
by Max
|
1 |
183 |
|
|
Excel and Outlook by
[email protected][_2_]
Hi
I have a spreadsheet for a mailshot we have just conducted, we dont
have the luxury of a CRM tool so wondered if it was possible to link
say A B C Comapany...
|
|
0 |
136 |
|
|
|
|
3 |
146 |
|
|
Deleting empty rows by
Felix
How can I easily delete empty rows on a huge worksheet (other than sorting)?
(Excel 2007)
Felix
|
|
1 |
111 |
|
|
Formatting a Column.... by
dawn brist
I want to do a continuous +1 in A1 thru A17 - ex. A1 = H03860, A2 = H03861,
A3 = H03862 ------ yes I feel very stupid asking this!
|
February 2nd, 2009 11:51 PM
by DB.
|
5 |
142 |
|
|
|
|
1 |
130 |
|
|
Worksheet ribbon by
Randy
I have a ribbon on a worksheet that only functions to hide and unhide hidden
columns. I do not know how this ribbon was inserted and I cannot find out
how...
|
|
1 |
118 |
|
|
Using HLookup for DV lists by
Andy
Hi
I'm building a reporting template in a workbook on one tab "Backend" I hold
all the DV List values Customer, Sector, Region, Month etc
The next tab "IT...
|
February 2nd, 2009 04:51 AM
by Max
|
3 |
140 |
|
|
|
February 2nd, 2009 01:46 AM
by Lerner
|
1 |
119 |
|
|
|
February 1st, 2009 04:52 PM
by JP[_5_]
|
4 |
146 |
|
|
"Next" button for reading NG from Internet by
Khoshravan
I am using Microsoft's site to read the posts in NG.
(http://www.microsoft.com/office/community).
There is a minor problem which wastes time.
After reading a...
|
|
7 |
198 |
|
|
|
February 1st, 2009 09:07 AM
by Stu
|
10 |
242 |
|
|
|
|
1 |
168 |
|
|
Function or Formula in Excel by
Rod
Hi
new to this.
in cell B13 I have a drop down box with 3 options
Post
Courier
Air freight
and I need function that will allow me to have a different answer...
|
February 1st, 2009 01:50 AM
by Max
|
8 |
217 |
|
|
How to automatically populate a cell? by
Khoshravan
As for your specific request, go to T1 enter"=" and click "A1".
This way upon entering a data into A1, it will be automatically entered to
T1 as well. If you...
|
|
3 |
119 |
|
|
Different colors within on cell. by
Lee
1 ; 45 ; 0
I want to change the color of each of the above numbers to bold green, 1,
then bold black 45 and finally bold blue 0. Each number in the one cell...
|
January 31st, 2009 05:01 PM
by Lee
|
3 |
121 |
|
|
If percentage is 10% when y or 0% when n by
thechooks
I am trying to apply 10%tax when tax needs to be applied (i.e. when next to
the item I have placed a y. If there is no tax to be added, (i.e. displayed
by an...
|
January 31st, 2009 02:47 PM
by Max
|
6 |
121 |