|
|
Count Products by
Jen[_7_]
I have worksheet that I have mulitple types of Billing Issues, lets say 20
types. I have been asked to shorten this list and come up with subtypes and
add...
|
|
1 |
117 |
|
|
Identify the row with specific criteria by
Billy L[_2_]
Hi
I have a database where column A - D contain country, product, etc, column E
- Q contain Jan - Dec and full year volume while column E contain Jan - Dec...
|
January 8th, 2008 02:06 AM
by CLR
|
5 |
113 |
|
|
format a cell by
Ray
I want to put in text and split in half in a cell like
values
actions but with a line seperating them in two parts, I was able to use the
borader but the...
|
|
2 |
96 |
|
|
How do I combine text from adjacent cells? by
Qegmag
I'm trying to combine three adjacent cells. The first cell has a name, the
second cell has the, @, symbol and the third cell has the e-mail signature.
How do...
|
|
2 |
72 |
|
|
IF statements by
Dwain Kincaid
How do I use an IF statement to look at a column of data and if the current
value or text is repeated in that column to return a null or NA value?
|
|
6 |
56 |
|
|
Sum of digits in a number by
Bob Ptacek
Example: a number 1234 would sum individual dighits to a value of 10.
I thought there would be a function in Excel that would do that but can't
seem to find...
|
|
3 |
78 |
|
|
New workbook from template on ftp site by
pdberger
Good afternoon --
I've created a template for our company users, and have posted it to our
corporate ftp site. Before releasing it, I'm testing to make sure...
|
|
0 |
69 |
|
|
|
|
1 |
77 |
|
|
|
|
2 |
114 |
|
|
|
January 7th, 2008 09:24 PM
by dim
|
3 |
73 |
|
|
If not, then populate. by
LiveUser
Anyone know how to do this or a formula that will help me accomplish this?
If information within Column C of Worksheet 1 is not within Column B of
Worksheet...
|
|
2 |
62 |
|
|
AutoFit function by
Donos
Is there a AutoFit C API function in Excel which i can use to set a
column to auto fit?
THanks
|
|
2 |
91 |
|
|
Date Calcuation with Blank Cells by
PT40
Hello,
I am looking to see if this is possible. I have my present formula below.
What I would like to do is that if the date in E2 is blank then to default...
|
|
5 |
75 |
|
|
Greater Than formula by
ginasucasa
I'm in need of the following:
a1=9
Formula: If a1 is greater than 8, I need b1 to show 8 only. If it is less
than 8, I need it to show the amount that is...
|
|
5 |
55 |
|
|
|
|
2 |
61 |
|
|
Autofill in Various Tabs by
Ann
I am a little new to formulas in excel and I need some help.
I have a large spreadsheet with about a hundred tabs. The first 30 or so
tabs are individual...
|
|
1 |
55 |
|
|
|
|
2 |
91 |
|
|
|
January 7th, 2008 06:03 PM
by bernieb
|
4 |
101 |
|
|
Help with workbook procedure by
CC
I am trying to automate a workbook to compile a weekly report. The workbook
is made up of a control sheet which the end user will use to run the various...
|
January 7th, 2008 05:37 PM
by CC
|
0 |
62 |
|
|
|
|
3 |
90 |