|
|
Data Validation by
dinna
can anyone help me !!!! I am trying to create a drop down list in excel
with data from another tab. Is this possible, if so how can I do...
|
|
1 |
288 |
|
|
odd and even addresses by
Dino
I saw a previous post about sorting odd and even numbers, and the formula
generates an "E" or an "O". I need to sort odd and even street addresses. I
could...
|
September 30th, 2008 05:47 PM
by Dino
|
3 |
85 |
|
|
|
June 26th, 2006 07:43 PM
by Dino
|
4 |
82 |
|
|
Concatenate or "&" problem by
Dino
I have tried to concatenate or use the "&" in my database with no luck so
far. I get either the #VALUE! or #NAME? result. I have addresses that are
separated...
|
|
6 |
119 |
|
|
Removing links by
Dino
I inherited a workbook that has a link to another workbook that no longer
exists. Every time I open this workbook, a message pops up that it can't find
the...
|
October 5th, 2005 05:11 PM
by Dino
|
2 |
67 |
|
|
assigning a unique value by
Dino
I have a spreadsheet of names, and I need to assign a unique number to each
of the names. Some entries are repeated, so each duplicate should have the
same...
( 1 2 3)
|
|
27 |
356 |
|
|
footer with complete path by
DINO
Is there a way to insert the file name with complete path
in the footer of an Excel document? I see that you can
insert the file name alone, page numbers, and...
|
|
1 |
149 |
|
|
Rounding issues by
DINO
I get lists of dollar amounts that I need to sum. The
actual numbers have four or five digits to the right of
the decimal, like $25.5637 I need to sum only to...
|
|
9 |
188 |
|
|
Counting cells with specific date ranges by
Dino
How would I count cells within specific date ranges? For
example, if I have a column of cells that have different
dates in them, how would I count the number...
|
October 9th, 2003 08:00 PM
by Paul B
|
1 |
444 |
|
|
Date stamping entries by
Dino
I hope that someone can help me with this:
I am setting up a 20,000 item spreadsheet, where my staff
will put an "X" in an adjacent column when they are...
|
|
2 |
139 |
|
|
colums in uppercase only by
Dino Thomas
I am trying to create a spreadsheet where all text entered in columns A,C,
and H from row 5 to row 50 shows in uppercase
|
|
1 |
68 |
|
|
|
|
4 |
73 |
|
|
|
|
1 |
127 |
|
|
#div/0 errors and blank cells by
dinouk
Hi wondering if anyone can help me with this one...
Have 31 cells in a row which i want to get the average value from, some of
these 31 cellsmay or may not...
|
|
7 |
108 |
|
|
|
August 10th, 2006 02:03 PM
by dinouk
|
0 |
47 |
|
|
Works spreadsheet-find circular ref. by
dino[_2_]
I have a spreadsheet with a lot of data and up pops the "circular reference
in a cell" message. Is there a quick way to find it? I've spent a good
amount of...
|
|
1 |
44 |
|
|
|
|
5 |
84 |
|
|
Limitations to 2 variable data tables? by
DInwood
I'm getting an odd result with 2 variable data tables in a complex
spreadsheet - only the 1st (top left) cell returns the proper value, the rest
are either...
|
June 26th, 2007 04:15 PM
by Max
|
2 |
98 |
|
|
|
September 5th, 2007 12:32 AM
by Diogie
|
5 |
83 |
|
|
|
|
3 |
65 |