|
|
Complex Array sorting issue by
Tubster
I have a range of Question responses from a survey that I'm seeking to find
the most common response combinations from. Simply sorting the data doesnt...
|
|
5 |
95 |
|
|
|
July 10th, 2008 11:33 PM
by Toria
|
6 |
103 |
|
|
Excel, how to edit by
Tluna kKangen water is you body
I used Excel to create a Web Page, I also inserted pictures and saved as Web
Page, question; when I edit with Microsoft Office Word, from my experienc in
the...
|
|
0 |
62 |
|
|
password protected workbook by
Ann
help! i have a workbook that i've password protected and can't get into now.
i've tried everything i know and it won't work. this is 2003. any possible...
|
July 10th, 2008 10:47 PM
by Ann
|
4 |
127 |
|
|
Replacing a Range of Numbers by
Peter Herman
Hi there,
I have a column of numbers which I am looking to change. ie..all numbers
between 1-10 should be replaced with a certain value and then all numbers...
|
|
1 |
93 |
|
|
IF STATEMENT by
charlie
I need a formula that looks at a cell and if it's not empty it preforms the
following function:
=IF(B17=B2,1,SUM(MONTH($B$2)-MONTH(B17))
B2 is set for...
|
July 10th, 2008 09:39 PM
by charlie
|
6 |
72 |
|
|
|
|
2 |
75 |
|
|
leave cells blank until formula applied by
Rita
I have a spreadsheet with simple calculation formulas in the columns and one
of the columns with the same formula copied and pasted into each cell is
driving...
( 1 2)
|
July 10th, 2008 09:19 PM
by Rita
|
10 |
148 |
|
|
|
July 10th, 2008 07:49 PM
by simon
|
2 |
89 |
|
|
Conditinal Formation by
WT
Is there any way to have more that 3 condition in conditional formating?
--
Thank you
|
|
1 |
52 |
|
|
Formula by
Cazumel
Hi
I have the following situation:
94101 How do i add a (.) ( Period at the end of each number in each Cell)
94101
94101
93001
93001
|
July 10th, 2008 07:27 PM
by Cazumel
|
2 |
50 |
|
|
multipying a cell by a percentage by
jjbits4u
I want to know how to multiply a single cell by a percentage.
ie: 2000.00 x 17.5% or 2500.59 x 30%
Does anybody know how to do this, appreciate your...
|
July 10th, 2008 07:19 PM
by Zumble
|
4 |
77 |
|
|
OLD PROBLEM without SOLUTION by
ytayta555
A good day !
I have this function :
=AND(COUNT(B1;B3;B5)=1;COUNT(C1;C3;C3)=1;COUNT(D1;D3;D5)=1;COUNT(E1;E3;E5)=1;COUNT(F1;F3;F5)=1) ;
this function...
( 1 2)
|
|
19 |
166 |
|
|
|
|
2 |
85 |
|
|
|
July 10th, 2008 07:00 PM
by Pete_UK
|
5 |
113 |
|
|
Date Formula by
charlie
I need a formula that will subtract March from June returning only the number
of months. For example:
6/1/08-3/1/08=3
6/1/08-3/15/08=3...
|
|
4 |
62 |
|
|
|
July 10th, 2008 06:52 PM
by BB
|
4 |
89 |
|
|
lookup by multiple parameters by
NatashaS
Hi,
I wondered if there is a function in Excel that allows you to look up a
value by two or more columns. (e.g. I want to ask for "column 1 = 1" AND
"column...
|
|
2 |
71 |
|
|
move or copy by
jaz
hello there
when i try to copy a sheet into new or the same work book it looks like its
done but it hides somewhere somehow and i cant find it anywhere
have...
|
July 10th, 2008 06:48 PM
by Pete_UK
|
1 |
52 |
|
|
|
July 10th, 2008 06:39 PM
by Zumble
|
2 |
92 |