|
|
calculations by
I have a file like
Dept PayType Amount
2312 OT 500
reg 1000
vac 10
ss 5
2566 ot 5522
reg 42
vac ...
|
|
4 |
213 |
|
|
|
|
4 |
459 |
|
|
how to change a number to name by
I have a bowling league schedule that looks like this:
Lanes 1 2 3 4 5 6 7 8 9
Teams1-2 3-4 5-6 7-8 9-10 11-12 13-14...
( 1 2)
|
|
10 |
171 |
|
|
Changing Numbers by
Hi
In a blank cell type 1.15. Copy it (Ctrl+C). Select the range you wish to
change and go to Edit|Paste|Paste Special|Multiply.
Make sure you take a copy...
|
|
4 |
123 |
|
|
|
|
1 |
100 |
|
|
Consolidating sheets by
Hi
We are buying a company and I need to create a stock spreadsheet from their
workbook. I would like a single sheet containing the information from about
25...
|
July 7th, 2005 08:57 PM
by
|
3 |
374 |
|
|
|
|
1 |
92 |
|
|
Depreciation Formula by
I don't expect to get any bites on this one, but, "Hey, it's Friday -- it
could happen!"
Just got this one dropped on my lap -- we have a spreadsheet with...
|
|
1 |
103 |
|
|
|
August 8th, 2006 06:04 PM
by
|
0 |
83 |
|
|
|
|
2 |
318 |
|
|
No Subject by
ssage-ID:
Date: Mon, 21 Mar 2005 15:13:14 -0500
From: Debra Dalgleish
User-Agent:...
|
March 21st, 2005 12:00 AM
by
|
0 |
144 |
|
|
Need help with formula by
Hi!
I need to create a formula that will count unique
(duplicating/repeating)values. I have numeric data in one
column and text data in another.I want to...
|
|
2 |
170 |
|
|
Filling drop down box by
hi,
I have a drop down box in a cell. Based on a value of
anohter cell I have to fill my drop down box. what i mean
is, say if
GreeNPackage is "No" then I...
|
November 26th, 2004 12:54 AM
by
|
3 |
129 |
|
|
|
January 11th, 2005 04:22 AM
by Max
|
2 |
369 |
|
|
vlookup data hidden within worksheet by
Hi,
Can anyone explain why it is that a vlookup table
automatically 'hides' itself within a worksheet that
utilizes the vlookup function but the vlookup table...
|
January 26th, 2005 12:09 PM
by
|
0 |
580 |
|
|
Formula returning #N/A by
In Sheet1 I have the following formula in B149:
=IF(VLOOKUP(A149,MyClinics,3,FALSE),"Yes","No")
MyClinics is a named range on my sheet - Reference List
In...
|
|
4 |
135 |
|
|
Conditional formating by
Can I use conditional formatting so as to look at Column A
A1 a2 A2 Turns
EA 1.00 red
CS 100 Blue
BX 50 ...
|
|
1 |
335 |
|
|
No Subject by
ssage-ID:
Date: Fri, 11 Feb 2005 21:00:43 -0500
From: Debra Dalgleish
User-Agent:...
|
|
1 |
110 |
|
|
lookup tables in cells by
Hi all. I was wondering how to error trap inported data
that uses one column as a lookup. i.e., that column has
imported part numbers and the column next to...
|
|
5 |
330 |
|
|
Hi and function help please by
My worksheet looks likes this:
A B
1 Name Fruit
2 Sam Apple
3 Sam Apple
4 Sam Apple
5 Sam Orange
6 Jane Orange
7 Jane ...
|
August 17th, 2006 05:57 AM
by Biff
|
4 |
85 |