|
|
Refer to other tabs in formula by
Gary T
I have a series of tabs within a workbook labelled "April 2008", "May 2008",
"June 2008", and so on.
In cell A1 of each tab, I have entered the start date of...
|
|
2 |
571 |
|
|
Sampling by
snickerbart
I am trying to find a formula in EXCEL that I can use to extract a specific
line of information form one worksheet to another.
Here's my problem: I am give...
|
|
1 |
242 |
|
|
|
|
2 |
262 |
|
|
Editing spreadsheets in emails by
John at Work
Hi
I receive requisition spreadsheets that I want to populate and reply to the
sender or senders. Currently I need to open the sheet, enter info, save and...
|
|
2 |
194 |
|
|
|
September 23rd, 2008 06:46 PM
by T. Valko
|
3 |
225 |
|
|
Excel formula by
Alex
Hi I have this formula, please can you help me what does it menas
"=TABLE(P7,P8)"
|
September 23rd, 2008 06:29 PM
by Spiky
|
3 |
129 |
|
|
VLOOKUP and SUM by
Rebecca
I am working with a spreadsheet where I need to lookup a text value in one
column and sum the numbers appearing in another column. Is there a way to
combine...
|
September 23rd, 2008 06:18 PM
by T. Valko
|
5 |
146 |
|
|
|
September 23rd, 2008 06:10 PM
by T. Valko
|
4 |
135 |
|
|
Macro deleted but still asking to enable? by
Jane Doe[_3_]
I deleted a Macro that I decided not to use. Followed typical steps and
deleted from list of Macros. I still get the question when I open the file
to...
|
September 23rd, 2008 05:58 PM
by T. Valko
|
5 |
153 |
|
|
Insert Function in an email button by
Barb
I have an excel document that has an "email button". The insert function has
it putting the current page onto the body of the email. I would like to have
it...
|
September 23rd, 2008 05:42 PM
by Spiky
|
3 |
211 |
|
|
I need to scan a column by
Vercingetorix.XIII[_2_]
I need to scan a column on a second page and look for a name, then scan
another column on the second page and check for how many months it has been
(less...
|
September 23rd, 2008 05:23 PM
by T. Valko
|
6 |
190 |
|
|
If between 2 numbers, multiply by
Gee...
I know this will be simple, but I just can't get my head around it. I need a
formula that will calculate a percentage:
If A1 500 but 1000 then A1*.02
See...
|
September 23rd, 2008 05:18 PM
by Gee...
|
5 |
199 |
|
|
|
September 23rd, 2008 04:45 PM
by ~L
|
1 |
155 |
|
|
Using an Excel sheet for batch delete by
Colin Hayes
HI All
I have an Excel worksheet with a list of file names in column A.
I'd like to use this list to look into a named directory (perhaps built
in to the...
( 1 2)
|
September 23rd, 2008 04:38 PM
by pgarcia
|
18 |
420 |
|
|
Importing, but only certain information by
Sweetie
Hi Peeps,
I have what i would call a master list, has ID numbers and names. How do i
use a blank sheet, type in the ID number for example, and excel to...
|
September 23rd, 2008 04:35 PM
by Spiky
|
3 |
130 |
|
|
Sumif for multiple conditions by
DMcCormack
Do anyone know if it is possible to do a sumif function for more than one
condition? What I want to do is sum the items in column C that meet the
criteria of...
|
September 23rd, 2008 04:30 PM
by ~L
|
3 |
116 |
|
|
|
September 23rd, 2008 04:11 PM
by Hjuler
|
6 |
155 |
|
|
I cannot open xls document sent by e-mail by
Rose B
I am using Windows Vista Home Premium, Microsoft Works Suite 2006 and Tren
Micro Internet Security Pro 2009 - I cannot open xls documents sent in an
e-mail...
|
September 23rd, 2008 04:08 PM
by Spiky
|
2 |
164 |
|
|
|
|
4 |
144 |
|
|
filter for round numbers by
Julieeeee
Is there a way to filter or sort for only those values that have no cents? I
have a column of discount amounts, and I want to see only the flat rate...
|
September 23rd, 2008 03:45 PM
by Pete_UK
|
2 |
138 |