|
|
Searching for the nearest value by
Abidan
I have created a spreadsheet containing several rows and columns each
with
a numerical value to 3 decimal places. The values in each cell
correspond to...
|
August 9th, 2006 06:11 PM
by Ian
|
1 |
233 |
|
|
Enquiry Form by
Abidan
I would appreciate some guidance as to the best way to create an enquiry
form linked to a database for my sales dept. to enable them to enter
customer...
|
August 15th, 2006 11:35 AM
by Abidan
|
0 |
42 |
|
|
|
|
1 |
54 |
|
|
|
April 11th, 2007 09:44 PM
by abie26
|
9 |
143 |
|
|
linking cell colors by
abielo
How can I link the color in one cell to the color in another cell?
Thanks in advance.
|
August 17th, 2006 06:16 AM
by Max
|
3 |
58 |
|
|
Logic Statement by
abierly
Hello. I'm trying to have one cell look at two other cells to determine
its entry.
This what I'm stuck on:
=If(E4=1 and E7=1, 60, if(E4=1 and E7=2, 50,...
|
|
3 |
145 |
|
|
Multiple pivot tables by
[email protected]
Hi is there anyway that I can combine separate pivot tables onto the
same sheet. I have tried to create a pivot table in the same sheet as
another one I have...
|
|
2 |
80 |
|
|
|
December 16th, 2008 07:45 AM
by Ron@Buy
|
2 |
99 |
|
|
|
October 3rd, 2003 04:57 AM
by Dennis
|
1 |
118 |
|
|
Multi-sheet issue by
Abir
I have several sheets of budget numbers that are linking
from one sheet to another. In linking several sheets by
pulling totals from one sheet to create other...
|
October 3rd, 2003 05:05 AM
by Abir
|
2 |
82 |
|
|
|
|
2 |
77 |
|
|
|
October 8th, 2003 12:56 PM
by FDDavis
|
1 |
415 |
|
|
How to get a blank cell instead of a "0" by
ABlevins
I used (various and many) spreadsheets at www.contextures.com to create a
2-tier dependent drop-list for addressing invoices. The third, fourth, and
fifth...
|
|
2 |
95 |
|
|
Dependent DropLists - Using Validation by
ABlevins
I am trying to use dependent droplists to input addresses on invoices. I
need to create a series of five dependent lists. There are a total of 68
items in...
|
|
1 |
89 |
|
|
Piviot Table Setup by
ABN
Hi,
I have a piviot table setup with the information below.
Count of Incidents, by year, by month, by system, by
problem type (request)
What I am trying to...
|
August 4th, 2004 06:31 PM
by ABN
|
0 |
138 |
|
|
count the no of specific position by
aboiy
Hi,
Our company have more than 900 workers with approx. 35
different position. I need to count the total no. of each
respective position that attended the...
|
|
4 |
289 |
|
|
Sort dates dd.mm.yy by year by
aboiy
Hi Hayley,
Try also this tips i got from the groups before;
You'll need a helper column. with your dates in column A
put the formula in column B, C, D.
A ...
|
January 28th, 2004 12:28 AM
by 2rrs
|
3 |
285 |
|
|
computing numeric with text by
aboiy
Can you help me make a formula for column c without
separating the text? Everyday were receiving report with
this kind of formatting, it would be time...
( 1 2)
|
May 4th, 2004 09:18 PM
by Aboiy
|
10 |
150 |
|
|
|
May 5th, 2004 07:03 PM
by Aboiy
|
5 |
389 |
|
|
|
October 25th, 2003 08:24 AM
by
|
5 |
473 |