|
|
delete all text to the left of??? by
Sheila
I want to put a list in column A that will be the paths to the files I
have, (ie c:\Program Files\Common
Files\Microsoft\Stationery\signature.htm), but I wqant...
|
|
3 |
89 |
|
|
|
|
3 |
211 |
|
|
dynamic combo boxes by
tjb
OK, basically what I want is one combo box with three options: "Yes", "No"
and "Void and Reissue".
When the user selects "Yes" from the first combo box I want...
|
January 25th, 2005 07:33 PM
by Tim C
|
2 |
328 |
|
|
|
|
1 |
93 |
|
|
|
January 25th, 2005 07:59 PM
by Steve
|
2 |
107 |
|
|
|
|
1 |
275 |
|
|
Data Validation by
Tony
One a drop-down box is created for selection can it populate multiple cells
with its selection. Can I create a table with 3 columns and populate 3 cells
when I...
|
|
2 |
83 |
|
|
Custom Number Format... by
whitmore0112
I have a number/text that I want to apply a custom format to, but am not sure
if it is possible. The number/text starts as 12K52E1, and I would like to
apply...
|
|
2 |
169 |
|
|
Need a Macro by
denwah73
Would anyone have a macro (or suggestion) that can decipher which numbers in
a list will calculate to a specified total?
|
|
1 |
139 |
|
|
|
|
1 |
203 |
|
|
Lookup names to get data by
Ed Wesemann
I have two name and address lists. List A is the larger list (13,000 rows)
and has names and telephone numbers along with other data. List B is smaller
(5900...
|
|
1 |
72 |
|
|
Does the cell have a number? by
Fletcher
I want a formula that will tell me if a given cell has a number in it, so it
evaluates the type of data. I looked in the help files and couldn't figure
this...
|
|
7 |
155 |
|
|
Calculate time difference to the half hour by
Ken Ivins
I am creating an employee time sheet that the put in their starting time and
ending time (From a drop down list). I would like Excel to calculate the
amount of...
|
|
5 |
342 |
|
|
Multiple Work Sheets by
Daniell
I have a project that involves 6 worksheets all in the same workbook. What I
need to do is get data from all the worksheet by a part number which is
common...
|
|
4 |
248 |
|
|
text and numbers by
sam
I have a text and number string that I use to link my excel worksheet to a
PLC for extracting values. The string is: =RSLinx|demo2!'gauge_offset_y',
where 0 is...
|
January 26th, 2005 11:05 AM
by sam
|
0 |
65 |
|
|
|
|
1 |
74 |
|
|
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 |
579 |
|
|
Vlookup not returning correct value by
Mandy Brookes
We have a file which is updated monthly containing 'Vllookups' combined with
'IF, ISNA' formulae. This has worked successfully for many months but
suddenly...
|
|
1 |
189 |
|
|
|
|
0 |
218 |
|
|
How to : SUM - IF formula by
bruno
Can anybody help me out here ?=20
Maybe a little example to explain a bit ...
Let's say I have the following data...
|
January 26th, 2005 01:54 PM
by Bruno
|
2 |
100 |