|
|
If conditional + Vlookups by
Jen
I am trying to return a value from two different worksheets using a unique
string attached to each rows on those two tables.
Here is my logic :
If my unique...
|
July 31st, 2008 06:11 AM
by JMB
|
1 |
51 |
|
|
Need help with an IF formula by
Wendy
I am trying to put a worksheet together for a client that I need help with.
The objective is to have all of the calculations set up for the client so
that...
|
|
3 |
52 |
|
|
|
|
2 |
80 |
|
|
|
July 31st, 2008 03:09 AM
by Max
|
5 |
91 |
|
|
Previous visible cell by
Fred
Hi,
I have a worksheet using an autofilter and I need to get the value of the
previous visible cell once the filter is applied.
Assuming my formula is in...
|
July 31st, 2008 02:44 AM
by Fred
|
2 |
53 |
|
|
Count a range of cells using an IF by
Access Joe
Hey everyone,
Excel 2000
I have a range of cells like so (each number is in it's own cell)
50 20 30 60 90 30
The FIRST cell (in this case, "50") is...
|
July 31st, 2008 12:26 AM
by Max
|
9 |
84 |
|
|
|
July 31st, 2008 12:18 AM
by Pete_UK
|
6 |
99 |
|
|
How do you Position WordArt behind data by
Kay
Inm a test I am asked to insert a wordart onto an excel Spreadsheet, then
move the wordart and position it behind the data. I click send to back but it...
|
July 30th, 2008 11:49 PM
by Kay
|
0 |
48 |
|
|
|
July 30th, 2008 11:37 PM
by Pete_UK
|
3 |
91 |
|
|
List of when functions where added by
Gary Brown[_4_]
Does anyone know if a listing exists that shows in what version a particular
function was added to Excel / VBA?
For example: in which release did SumProduct...
|
|
1 |
64 |
|
|
Decimal to Time Format. by
GEM
What function can I use to convert a decimal number to a time number?? For
example,
The decimal number "1.50" would mean 1 HOUR 30 MINUTES.
1.25 would mean...
|
July 30th, 2008 10:56 PM
by GEM
|
6 |
80 |
|
|
|
July 30th, 2008 10:56 PM
by Emily
|
4 |
79 |
|
|
|
|
2 |
85 |
|
|
Need help with this formula by
Joseph
A little background...The data is in Worksheet1 and I want to show the
results in Worksheet2. Column A=Month, Column B=Date mm/dd/yyyy format. I
want to...
|
|
1 |
57 |
|
|
Løbende nummerering by
Jens
Jeg er ved at oprettte dagsedler for mine ansatte og vil gerne have mulighed
for at tildele hver enkelt Sheet et fortløbende nummer som bliver påført hver...
|
July 30th, 2008 10:12 PM
by Jens
|
0 |
87 |
|
|
|
|
3 |
63 |
|
|
VLookup worksheet name by
lsn
I have a vLookup formula that is looking at a worksheet in a multiworksheet
workbook. I wanted to delete the worksheet and have it create the worksheet
via...
|
|
2 |
66 |
|
|
|
|
1 |
337 |
|
|
Dates And Pivot Tables by
Mike
I have downloaded abot 20,000 lines of data. One of the columns in the data
is a date field. The dates begin in 2004 and continue through 2008. The dates
in...
|
|
1 |
52 |
|
|
Conditional formula by
Mindy
I have a task spreadsheet. When my task changes to complete I want to pull
to another sheet and hide it's view from the main sheet. Does anyone have
any...
( 1 2)
|
July 30th, 2008 08:36 PM
by Mindy
|
13 |
122 |