|
|
how to include dash within a cell by
Accounts jobs
If anyone can help me in this I would be very greatful
We receive a list of codes like "TND4567". We manually put the dash
between the text and numbers. is...
|
|
7 |
49 |
|
|
|
|
2 |
55 |
|
|
Out of Ideas, need help with Auto Fill by
acctexecutive
I work in the sales department for a computer software company and I'm
building a Territory Pipeline Tool. Currently we have 4 Inside reps that
support 9...
|
June 21st, 2005 09:16 PM
by RagDyer
|
3 |
121 |
|
|
|
|
0 |
82 |
|
|
|
|
2 |
84 |
|
|
|
|
6 |
114 |
|
|
PROPER FUNCTION by
ACE PRODUCTS
HOW DO I USE THE PROPER FUNCTION FOR MULTIPLE NAMES THAT NEED TO BE CHANGED?
|
|
5 |
63 |
|
|
Tabs by
Ace123
I would like to create multiple tabs based on information within the work
book.
Sheet 1 would contain a 3 digit number below the three digit number would be...
|
July 17th, 2008 02:13 AM
by Max
|
1 |
65 |
|
|
Cell Column Comparison by
ace21
I have six columns of part numbers (A-F) that I want to compare to each
other. The part numbers that are an exact match I want displayed in column G
and the...
|
January 16th, 2007 05:29 PM
by Max
|
3 |
64 |
|
|
Date + 365 in New Column by
ace214
I have a column of dates, F. I want to have the dates plus a year in column M.
I figured out that you can add 365 to a date but I'm not sure how to process...
( 1 2 3)
|
|
21 |
249 |
|
|
IF AND help! by
acebrown
What's the formula for:
If A1=2 or A11 then B1
If A2 then C1
If A=1 then 0
I assume it'll be an extensions of this formula which is missing the
A12...
|
|
1 |
61 |
|
|
IF Function with & by
acebrown
I'm having trouble getting the If function to work...
A B
1.5 10
4 3
If 2A1, then (A-1)*B
If not, then B
So the result for row1 above should...
|
|
4 |
61 |
|
|
Circular Reference Formula Help by
acebrown
I'm working with three cells:
-original $ amount
-new $ amount (original+change)
-change (new-original)
I would like to be able to enter a number in either...
|
|
1 |
58 |
|
|
Check box in Filters by
AceRoadRunner
Hello All,
I am using Excel 2007. In Excel 2003, whenever you would apply a filter to a
header row, you would be able to chose one criteria to filter. In...
|
|
0 |
56 |
|
|
Searching for Duplicate Text in a column by
acesandspades101
I have created a worksheet that lists identification numbers for valves and
instruments on filtration machines. Now these identification numbers are
unique...
|
August 25th, 2006 12:40 AM
by Max
|
2 |
58 |
|
|
Question about Bacaratt Tracker by
acesgamingworld
I am currently working on a bacarat tracker where you put in Banker, Player,
or tie for my company, and need to see if there is a way for excel to give a...
|
|
1 |
176 |
|
|
lunch break!! well..how to figure by
acetoolguy
I was a row that looks this..
Arrival Departure Lunch total hours
7:00 am 5:00 pm .5 9.5
I cant seem to get the 1/2...
|
|
5 |
70 |
|
|
moving entries between workbooks by
acetoolguy
I'm self employed, for record keeping I have an invoice, expence report and
balance sheet. I fill out the invoice, then the expence report moving the
invoice...
|
|
1 |
129 |
|
|
Help With If Statement by
AceWebmaster
Can anyone explain to me how to correct the following logical expression
which is designed to compare two columns. If the first column contains a
1 (indicating...
|
|
4 |
118 |
|
|
|
April 1st, 2005 03:58 AM
by JulieD
|
3 |
193 |