|
|
|
|
2 |
121 |
|
|
|
|
8 |
178 |
|
|
Search for Employee Names by
DaveMoore
Good Evening.
My spreadsheet contains data imported from an Oracle database. This
data is in text form in a single column and can run to many thousands
of...
|
|
2 |
90 |
|
|
Excel Formula and Variance Analysis by
Mur
Cell A1 is 10 an input
Cell B1 is 5 an input
Cell C1 is 5 a formula of A1 - B1
I want to only see variances that are greater than 25% of cell A1 and I can...
|
January 6th, 2010 06:57 PM
by Mur
|
0 |
108 |
|
|
dates in VLOOKUP by
MBG
Trying to use Vlookup to copy dates for a series of records (rows) from one
file to another. The result in the placed file (where the formula resides)
is 4...
|
|
3 |
88 |
|
|
Consolidating Redundant Text by
Brad Autry
My issue:
I've a worksheet with 17 columns of data.
Total is roughly 10,000 rows.
Of those 10,000 rows, I am dealing with roughly 1000 different items.
That...
|
|
2 |
146 |
|
|
Create a button to insert a new row. by
Sharon
I know Excel can do it; I just don't know how. In addition, once the new row
is inserted, I need the formulas to carry into it.
Any help is greatly...
|
|
2 |
84 |
|
|
|
|
2 |
117 |
|
|
|
January 6th, 2010 05:38 PM
by klmiura
|
5 |
153 |
|
|
|
|
3 |
191 |
|
|
Help by
Steve
Howdee all.
I was just presented with a problem that has got me curious.
While it's something I have thought about before, I never knew where to
begin with...
( 1 2)
|
|
14 |
199 |
|
|
|
|
4 |
145 |
|
|
matching data in 2 worksheets by
tabylee via OfficeKB.com
Hi,
We have started entering our membership in an Excel workbook of about 500
names with names, age, birthday, address, tel no., mobile nos.
2 of us were...
|
January 6th, 2010 05:30 PM
by John
|
3 |
147 |
|
|
Count based on date criteria by
Erich
I Want to create a formula that will tell me based on any given day how many
tickets were unresolved. I have the date fields "Call Taken" (Column B) and...
|
|
1 |
138 |
|
|
print area Excel 2007 by
CraigJ
I have a pivot table in a worksheet that is updated each month. When I
update the pivot table and try to drag over the print area to cover the new
data,...
|
January 6th, 2010 04:36 PM
by CraigJ
|
0 |
140 |
|
|
|
|
3 |
113 |
|
|
vlookup help linking data between worksheet by
tabylee via OfficeKB.com
hi,
I have a master list of students (about 200+ )in one worksheet. On the
succeeding worksheets are the attendance for seminars. We have more than...
|
|
3 |
124 |
|
|
How to use the search in an if statement by
trinamariem
I have a spreadsheet with numbers in column B and letters in column C. I
need to search for "J" in Column C and if there is not a J there and there is
a...
|
|
3 |
94 |
|
|
|
January 6th, 2010 01:44 PM
by Brenda
|
0 |
126 |
|
|
how do i create a divisible formula by
Tim
I use a xl doc that has numbers in the cells that need to be divisible by 15.
Can i incert a formula that will check the number in B5 and display an error...
|
January 6th, 2010 01:41 PM
by Huber57
|
3 |
88 |