|
|
Merge Cells? by
msnyc07
I need to remove duplicate cells but besides specifying which cells
constitute a match I want to specify what to do with conflicting values in
the...
|
|
2 |
127 |
|
|
Arrange Footer by
MAX
I have a file with 31 sheets and every sheet has a footer ABC 6/1. How can I
arrange this footer in all sheets to ABC 6/0.
Thanks in advance.
|
|
2 |
157 |
|
|
Lookup a value that fits two (2) criterion by
Carlos R
I need to find a value that is identified by 2 criterion. For example, I need
to identify the profit of brand y in store 91 (7.0). A vlookup only considers...
|
|
4 |
120 |
|
|
|
|
6 |
122 |
|
|
Index and Match by
carl
I use this formula:
=INDEX($B$6:$B$255,MATCH(1,--ISNUMBER(FIND(AE7,$C$6:$C$255)),0))
I appears to be returning the value in $B$6:$B$255 that corresponds to...
|
February 8th, 2010 09:09 PM
by Luke M
|
2 |
117 |
|
|
|
February 8th, 2010 09:06 PM
by Luke M
|
1 |
101 |
|
|
stop view and lock columns by
Psychokitten
Hi,
I need to hide two columns on my worksheet such that when I send it to a
user, they cannot "unhide" the columns to see salary data. Is there a way to...
|
February 8th, 2010 09:05 PM
by Luke M
|
2 |
93 |
|
|
FORMULA by
attyshane
I have a hodge-podge list of numbers and letter-number combinations. I need
excel to tell me when any of those values appear in collumns J-N . can this
be...
|
|
6 |
96 |
|
|
|
February 8th, 2010 08:25 PM
by swest
|
3 |
98 |
|
|
Conditional format on adjacent cells by
Simon
Hi All,
what am I doing wrong??
I want cells A1 to G1 to conditionally format (to red) if they are ALL
empty, but if ANY one (or more) of them contain data...
|
February 8th, 2010 08:08 PM
by Simon
|
4 |
125 |
|
|
General question by
Rookie User
I want to have a master list I work from and then have parts of it
transferred to different worksheets. I have been changing the data in 7
different tabs...
|
|
2 |
99 |
|
|
|
February 8th, 2010 07:33 PM
by jaz
|
0 |
105 |
|
|
|
February 8th, 2010 06:33 PM
by Mirella
|
7 |
350 |
|
|
Where was I??? by
silver5
Last week I joined this site and asked for help because I opened a document
in Excel and couldn't see it. A nice man answered me and it worked! I'm
trying to...
|
February 8th, 2010 06:15 PM
by Paul C
|
3 |
82 |
|
|
Hyperlink not working by
sanket
Hi
I am trying to create an hyperlink.It is getting created.When i am
trying to click on the link a message is coming on screen:
The operation has been...
|
February 8th, 2010 05:58 PM
by sanket
|
2 |
96 |
|
|
Conditionally Formatting a Range by
Anita
I want to use a variable cell (let's say cell H1) to format a range (let's
say A1:c10).
Example: If cell H1 = "block" then shade cells A1:C10 red.
|
February 8th, 2010 05:46 PM
by Andri
|
1 |
105 |
|
|
|
February 8th, 2010 05:06 PM
by Max
|
2 |
82 |
|
|
|
|
2 |
125 |
|
|
|
February 8th, 2010 04:39 PM
by LizG
|
2 |
93 |
|
|
Removal Date by
Andri
Dear Experts,
Please help for the following condition:
1. I have one sheet "A" which contain of database, the field structure as
follows:
Field A =...
|
February 8th, 2010 03:48 PM
by Andri
|
3 |
99 |