|
|
Excel open NOT in compatability mode by
yoshimarine
When I go to open a new Excel application I want it to be in the xlsx file
format. However, everytime I open Excel it is in the 97-2003 file format. I
go...
|
|
0 |
120 |
|
|
|
|
1 |
146 |
|
|
Sumif comparing dates in criteria by
sdjsage
I'm trying to use SUMIF
=SUMIF(L6:L8,"=and(B20,=C20)",K6:K8)
where column L has dates in it, column K has dollar amounts and the criteria
is looking at a...
|
|
1 |
131 |
|
|
|
|
0 |
127 |
|
|
worksheet change question by
Tonso
I want to be able to enter a time, using "." instead of ":", so that
when I enter the number, then press "Enter", the number changes from,
say, 13.27.33 to...
|
April 2nd, 2010 05:46 PM
by Tonso
|
2 |
132 |
|
|
vlookup + if formula help! by
sross002
I have a list of names on sheet2 (a1:a69) and if the name in cell a1 (sheet1)
matches any of those names then I want it to say "NO" in cell a2 (sheet1).
if...
|
|
7 |
124 |
|
|
|
|
0 |
111 |
|
|
spreadsheet layout changes by
Ursula
I use Excel 2000 to create my spreadsheet. I change the print layout for a
HP 960C printer. When I send this file to a friend who uses Excel 2003 and a
HP...
|
|
1 |
114 |
|
|
Formula help--lookup? by
BeckyB
I have various items in a spreadsheet. Some of these items are repeated in
various rows, but have a different text description for it. They all have the
same...
|
April 2nd, 2010 03:48 PM
by BeckyB
|
4 |
127 |
|
|
|
|
1 |
141 |
|
|
|
|
4 |
133 |
|
|
combining text by
Jeanette
Does anyone know how to combine 2 columns of text into 1? For instance if
you have an address that is in column A1 & A2 and you want all of it in
column A1?
|
April 2nd, 2010 02:50 PM
by James
|
3 |
103 |
|
|
|
April 2nd, 2010 01:52 PM
by Mike H
|
1 |
173 |
|
|
Formula help please by
shallowz
i am a noob when it comes to excel formula's
this is what i want i hope it can be done
if in cell A1 i have the word New York i would like to have cell A7...
|
|
9 |
147 |
|
|
|
|
2 |
179 |
|
|
sharing workbook by
nordiyu
I want share my workbook but to some user only, than others for read only.
How to setting that selected user for sharing.
|
|
2 |
152 |
|
|
Macro passwords by
JLatham
That sounds really odd to me. Can you contact me via email (remove spaces) at
HelpFrom @ JLatham Site.com
and I'll send you a workbook with a form in it that...
|
April 2nd, 2010 01:31 PM
by JLatham
|
0 |
86 |
|
|
Pivot Table by
Judi
I have a spreadsheet which is about 1500 rows long. There are about a total
of 150 people on it, with duplicates. Each person had a listing for each
piece...
|
|
2 |
110 |
|
|
Vlookup based on a unique "Text" occur by
Narnimar
My vlookup range starts based on a unique "Text" occur once in a cell in B:B
and end when the same occur once in a cell in A:A
Within this target range of...
|
|
0 |
87 |
|
|
|
|
0 |
119 |