|
|
Lookup reference help by
DubboPete
Hi Folks,
I have a sheet, where the contents of cell A1 is a result of other
criteria being met. For the purpose of this example, the result in A1
is "Oral...
|
|
3 |
250 |
|
|
Can I stop the footer from indenting? by
Michelle
The footers in my spreadsheet seem to be indented differently from the main
spreadsheet margin.
Does anyone know a way to get the footers to align to the...
|
|
4 |
345 |
|
|
table lookup by
dksaluki
Let's say i have a table. I can use MATCH() to know that I want to
look in column 13 for a certain value. Now I just need to figure out
what row a certain...
|
|
2 |
298 |
|
|
2003 Keeps the default workbook open by
Michelle
When I start Excel, it starts up with a blank workbook. If I immediately
open a saved file, it closes the blank workbook... All good...
except mine has...
|
|
1 |
254 |
|
|
Searching from one list in another by
Brian[_12_]
I have a workbook which has one tab (“Shortlist”) with about 150 rows of
data, and a tab (“Longlist”) with about 20,000 rows of data. I need to
be able to...
|
|
3 |
308 |
|
|
excel separation by
Kevin
Question
Here is a problem I have:
123456789
134567890
135678901
1456789012
157890123
this group of numbers is in my Sheet and each line is in a row by...
|
|
1 |
267 |
|
|
Countifs and date comparison by
KennyD
Okay, trying to figure one out here (although Dave Peterson could probably
do it in his sleep :D).
I have two sheets, Sheet_2 and dB_File. I want to use an...
|
|
3 |
296 |
|
|
compare 2 columns and select the lowest by
Delya
Hi
I have simple question
I have 2 coumns A and B
A1 is text and B1 is numbers and so on.. depending of B columns numbers , i
want colums C to show alway...
|
|
2 |
298 |
|
|
date by
Rubem
Hi,
I have a table if several columns. One of them is Invoice Date. I am using
Pivot Table to compile the data. I am trying to find out how many invoices...
|
|
2 |
229 |
|
|
FIND ERROR PROBLEM by
Dan
hi, I have pieces of formula's that might help to figure out how to find
where an error is located (by column & row). thanks in advance.
examples include:
a...
|
May 8th, 2010 06:20 PM
by Dan
|
0 |
210 |
|
|
|
|
3 |
278 |
|
|
SUMPRODUCT by
Tmt
Hello,
I've used this formular to find work piece that gets done per department.
=SUMPRODUCT(('Q2'!E13:E150="Done")*('Q2'!G13:G150="14532"))
Department 14532...
|
|
3 |
271 |
|
|
Automatic display positive or negative by
tran1728
Dear All, pls help me.
when I type $ 52.00 on C1, I want C1 display positive $52 or negative ($ 52)
, if B1 is positive or negative, I want the entire column...
|
|
3 |
254 |
|
|
|
|
1 |
292 |
|
|
validation by
ganga
hi,
I have a workbook with 2 sheets. In one sheet I have a calender and other
sheet just list of names. what i want to do is: In the calender sheet if i...
|
|
3 |
228 |
|
|
Movement of the cursor by
tran1728
Dear All, i need your help pls,
This is really basic but I could not find a thread. I want to control the
movement of the cursor. move direct at A6 after...
|
|
4 |
275 |
|
|
|
May 8th, 2010 05:03 AM
by FSt1
|
1 |
297 |
|
|
Excel 2007 Selection Tool Broken? by
Quin
I am using Excel 2003 at work and Excel 2007 at home. I have a file that
uses hundreds of text boxes and images. At work, using Excel 2003 I can use
the...
|
May 8th, 2010 04:53 AM
by Quin
|
0 |
252 |
|
|
Command Button by
WLMPilot
I am unable to locate the section I need to add a commandbutton to excel
worksheet. Where can I find this at?
Thanks,
Les
|
|
1 |
321 |
|
|
Missing question by
khaled shaheen
Dears,
How can i find my question that i have sent to you but unfortunately can't
remember the question's subject? and also i haven't received replies in my...
|
May 8th, 2010 04:03 AM
by FSt1
|
1 |
280 |