|
|
Formula for Cell address by
Elton Law[_2_]
Hi all,
Cell A1 contains a figure of 100.
Using formula =A1, it shows up 100. This is obvious.
Is there any way (formula) that it can give A1 (cell address)...
|
|
3 |
46 |
|
|
data sorting by
CAKE LADY[_2_]
I have a spreadsheet on which I have always been able to sort data. All of a
sudden the entire data tool bar is sort of grayed out and nothing can be...
|
|
1 |
55 |
|
|
subtotal function won't work by
RicBob
Hi -
I'm using subtotal to count records in a spreadsheet, which I've used
hundreds of times before. Unfortunately, this time the function continues to...
|
April 8th, 2009 05:00 PM
by RicBob
|
1 |
67 |
|
|
|
April 8th, 2009 04:51 PM
by Mark
|
0 |
57 |
|
|
indirect function with r1c1 style by
Zim
=INDIRECT("'"&R2C2&"'!R81C3",FALSE)
This is the formula I am trying to use. What I am trying to accomplish is
to return the value of Cell (R81C3) on...
|
April 8th, 2009 04:10 PM
by Zim
|
4 |
62 |
|
|
how to convert list of numbers to barcode font by
Convert numbers to barcode in spreadht
i have a spreadsheet with a column of style numbers. I want to create a
second column that convert the first column to a barcode using the barcode
font
is...
|
April 8th, 2009 04:00 PM
by joel
|
1 |
102 |
|
|
Listing multiple values in a macro by
ToddS
Can't get this macro to work. Has something to do with the way I'm listing
the values but I don't know how to do this properly. Also, I need to be able
to...
|
|
6 |
67 |
|
|
formula that advances by
JoAnn
Hello,
I have a worker who wants to put a formula in a cell that will show up on
another worksheet. But since there are several worksheets for the same...
|
April 8th, 2009 03:41 PM
by JoAnn
|
0 |
84 |
|
|
Conditional Formatting by
Hardworker
Hi,
Is it possible to "fill" only the top three cells which which is obtained by
a formula.
eg You have A1, B1, C1. If you reach the targets within each...
|
|
1 |
55 |
|
|
multiple sheets 2 work books by
capt c
workbook 1 Multiple work sites) collects all data from workbook 2 (time cards
of where individual worked & how many hours (multiple time carsd)
in workbook 1...
|
April 8th, 2009 03:03 PM
by capt c
|
0 |
66 |
|
|
|
|
1 |
49 |
|
|
Comparin data in cells by
[email protected]
Hi,
I have data in 4 cells ie cell a1, a2, a3 & a4.
I would be keying in either 3 or 1 as input data in each cell.
If all cells are keyed in as 3 then in cell...
|
|
1 |
60 |
|
|
Cell Address presents in Formula by
Elton Law[_2_]
Hi all,
A1 is a number showing 100.
Using formula =(A1) in cell A2 is equal to 100. This is obvious.
What formula can use so that it can give the cell...
|
April 8th, 2009 01:07 PM
by Stefi
|
1 |
51 |
|
|
Find certain text in a cell by
Elton Law[_2_]
Hi all,
Wanna use a formula so that it can give logical result (True or False) if
that cell contains certain words.
Say cell A1 contains a text "I love...
|
|
3 |
45 |
|
|
Paste Formula by
HZH
Excel 2007 - Can not use Paste Special, Formula, Add to copy and paste a
formula of added numbers (=24+32) to another Formula of added numbers...
|
April 8th, 2009 12:32 PM
by HZH
|
3 |
51 |
|
|
Default print layout by
Maghull Dave
I'm referring to a huge pivot table and double clicking each number to expand
into the data behind it. It creates a new page each time and I have to set
the...
|
|
0 |
59 |
|
|
Extract Formula to Text by
Elton Law
Hello,
Apologize if the question is too stupid.
In cell A4, it contains a formula =Sum(A1:B3)+A3/B2.
How to extract this formula in cell A6 as a string of...
|
|
6 |
105 |
|
|
formula setup for number combinations by
The Deacon[_2_]
I am having a problem setting up a function in Excel (not sure of the
appropriate function to use). The fundtion I use can be used for numbers or
text (no...
( 1 2)
|
April 8th, 2009 11:16 AM
by joel
|
11 |
99 |
|
|
Hierarchical outlining by
Michael.Tarnowski
Hi folks,
I have to convert a long table from Word to an Excel one.
The first column of the WORD table is a hierarchical outline,...
|
|
4 |
64 |
|
|
|
|
2 |
47 |