|
|
use AND in ARRAY formula by
Rakesh Gupta
I am using the below formula and it is working fine.
{=INDEX($B$1:$B$10,SMALL(IF($A$1:$A$10=$F$3,ROW($B$1:$B$10)),1))}
Now I want to check two conditions in...
|
|
3 |
88 |
|
|
|
hiding freeze pane reference lines by
Mamachugh
Is there any way to hide the vertical and horizontal lines that appear after
freezing panes? I'm using an Excel spreadsheet as a form and sharing with the...
|
|
3 |
137 |
|
|
|
* instead of value by
Kash
Hi, I need to display as * in the cell instead of value.. How to format that?
|
June 27th, 2009 11:45 PM
by smartin 
|
4 |
77 |
|
|
|
Too many characters in header by
Mike1558
I am creating a template and the text that I want in the header is more than
255 characters. How do I create a header that has all the info that I want in...
|
|
4 |
98 |
|
|
|
Duplication number with formula help by
Soth
I have a million lines. There are so many duplications number and cost and
I'd like to keep just ONE number and cost line of any duplication. The rest
of...
|
June 27th, 2009 10:26 PM
by Bernd P
|
4 |
139 |
|
|
|
Dynamically sum rows by
Akilah
I have a function that exports rows of data to an Excel spreadsheet template.
Is there a way to dynamically show the sum of each column after the last row...
|
|
3 |
132 |
|
|
|
|
|
0 |
127 |
|
|
|
Drop Down lists and condtional formating by
grissom 345
I have a spreadsheet for a 24 hour rota, i have added drop down boxes and
want to use conditional format the options, I have 5 selections on my drop
down...
|
|
2 |
97 |
|
|
|
Conditional Format: % of total by
AussieBec
Hi Not sure if this can be done, I just can't work it out at this point.
Scenario:
A1: $10000
B1: $ 7500 (this is has a sum total)
How to I colour B1 when it...
|
|
4 |
89 |
|
|
|
Copy/Fill increments by
tcidawn
I have data in cells 1 – 297 in a worksheet that I want totaled in new
workbook like so…
Row 1 @sum(A1:A5)
Row 2 @sum(A6:A10)
Row 3 @sum(A11:A15) ...
|
|
8 |
85 |
|
|
|
|
|
3 |
91 |
|
|
|
Worksheet by
Denver
Hi,
I have a worksheet in excel 2003 I have around 10 headings in that worksheet
and there are about 5 pages when I click on print preview.
I want that my...
|
|
2 |
90 |
|
|
|
|
|
3 |
89 |
|
|
|
|
June 27th, 2009 04:52 AM
by Max
|
3 |
107 |
|
|
|
Date-time updates every cell? by
Penny Miller
I have a worksheet that has a formula in all cells in row H that says if
there is a comment in row G then put the current date/time in H(current
cell). My...
|
|
3 |
80 |
|
|
|
Excel Functions - IF? by
LaDonna Brooks
Is there a formula that I could use if it says EXCL (meaning exclude) to have
it enter that amount in another cell as a minus?
msladona
|
|
3 |
93 |
|
|
Macro?? by
Connie Martin
I'm sure this can be done. Excel can do just about anything. Only wish I
could!! My spreadsheet has dates in Col. A, which are formatted as Date.
Each...
( 1 2 3)
|
|
24 |
242 |
|
|
|
MISSING PARENTHESIS by
Kanmi
=IF($I$11=(1:60). please what is the missing parameter in the formular.
trying to use conditional formating to change colour if 1:60 days different
on the...
|
|
3 |
129 |
|
|
|
Zero's by
PAL
I have this formula that works very well.
=IF(ISBLANK(E297),IF(ISBLANK(C297),TEXT((D297-B297)/30.43,"#.0")&"
(Plan-Plan)",TEXT((D297-C297)/30.43,"#.0")&"...
|
|
3 |
85 |
|
|
|
|
|
2 |
92 |
