|
|
LOOKUP or Offeset by
SFrick
I did an earlier post but I guess I was not clear enough in what I
need in a formula.
In cols J through Z rows 6 through 81 is data.
Row 6, J through Z are...
|
September 17th, 2003 03:55 PM
by Will
|
1 |
350 |
|
|
barcoding by
Kevin
Please help.
I have added a font to windows to barcode documents. This
font requires an asterisk before and after the value to be
scanned. The value I am...
|
|
1 |
342 |
|
|
Personal.xls by
Frances
I believe I should have a workbook called "Personal", which I understand
would hold global macros. The equivalent of Normal.dot in word. Where is
mine?
Frances
|
September 17th, 2003 02:59 PM
by Frances
|
3 |
314 |
|
|
multiple AND conditions with IF's by
David
I have to create a column that shows traffic movement data.
I'm not really used to Excel and this is the formula I
have come up with thus...
|
|
2 |
515 |
|
|
last value in a row by
Cees Bruin
there probably is a fuction which will give me the last
value in a row, the thing is I dont know which one, i use
the max value .. but there could be a problem...
|
|
3 |
381 |
|
|
DATE by
Gary Reynolds
What function returns the date that never updates; stays
the same?
|
September 17th, 2003 02:23 PM
by Andy B
|
1 |
321 |
|
|
Counting Rows by
Buster
I tried to create a function to count rows used on a
worksheet and recieved an Overflow(Error 6) message.
Public Function UsedRange()
Dim MyRowCount As...
|
|
1 |
377 |
|
|
Table Formula by
user21
Thank you very much. It was very helpful.
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post...
|
September 17th, 2003 02:04 PM
by Max
|
1 |
417 |
|
|
concatenate question by
jr
I would like to concatenate some cells where the result
will be the first letter of one cell and the whole word of
the second cell. John + Smith = jsmith. Is...
|
|
1 |
283 |
|
|
multiple field returns by
Ian P
I have a list of around 1000 names, separated into first
name in one cell, and surname in the next, with an
employee number in the third.
I need to create a...
|
|
1 |
458 |
|
|
generating random numbers by
Roger
Is there a way (or formula) to generate a random number in
a cell? If so, can I specify the range I want the random
number to fall into, e.g., 1 through 6, 0...
|
September 17th, 2003 01:48 PM
by Roger
|
2 |
527 |
|
|
Using Sheet Name In Cells by
Paul Moles
In Excel Xp how do I get a cell to show the sheet
name,alternatively can I get the sheet name to show the
contents of a cell.
|
|
2 |
298 |
|
|
Date Format problem by
Nishant
Dear All,
Please suggest me the solution of my problem,
as i m handling data for 60,000 in no.Some body in data
entry has enter the date in a cell in gernal...
|
|
2 |
501 |
|
|
Change in time where text is involved by
Jill
I am working on a report where I am trying to show the
amount of time that passed between when we received a
completed contract and when the installlation...
|
September 17th, 2003 12:43 PM
by Michael
|
1 |
707 |
|
|
Macros in XP vs 2000 by
Peter
Having created a macro in a spreadsheet using Windows
Office Excel XP, I send it via email to my office, to
continue working on it, & macro will not run (at...
|
|
1 |
278 |
|
|
|
September 17th, 2003 12:20 PM
by Tobit
|
2 |
763 |
|
|
combined cell by
bayanbaru
I have a huge file but with only 2 column. Column A is the
serial number and column B is description. I need to
combined the all description that has the same...
|
|
1 |
324 |
|
|
lookup formulas by
Marian
I have a lookup formula working just fine as long as what
I want it to look up is there. My problem is that when
the number I want it to look for is not on...
|
September 17th, 2003 12:06 PM
by barb
|
2 |
342 |
|
|
Sharing Workbooks by
Tim Hagedorn
I have a pretty elaborate workbook set up that is keeping
track of my inventory, sales, production, etc....
My problem is that I share this workbook w/ 2 of...
|
September 17th, 2003 11:58 AM
by BARB
|
2 |
356 |
|
|
AutoFill On Inserted Rows by
Aman
When inserting rows, is there a way to autofill data from
the row above or below? I have a simple autosum formula
on each row -- if I insert another row, I'd...
|
|
1 |
346 |