|
|
|
|
2 |
844 |
|
|
Counting cells with conditional formatting by
AOdoc
I am trying to count the cells in a range that have a certain fill color in
Excel 2003. Is there a way to use COUNTIF? If so, how do I write the criteria
for...
|
|
2 |
1,032 |
|
|
Index Match Inconsistencies by
Office Girl J[_2_]
hi all,
I am trying to use Index Match formula on 2 spreadsheets. There is 2 text
fields and a date field which I need to match b/w the s/s.
Problem 1: when...
|
|
1 |
765 |
|
|
Trying to lookup based on a condition of two values by
Trying to lookup based on a condition of
I have three columns A, B and C.
I want too look up the value in C where A and B match different values.
Example:
A, B ,C
apple, color, green
apple , price,...
|
|
1 |
883 |
|
|
|
June 2nd, 2010 02:46 PM
by Meenie
|
2 |
834 |
|
|
Multi-Condition Formula by
Malcolm
I’m using this formula;
=IF(OR(‘Source Sheet’!C10={“”,”C”, “B”}),’Source Sheet’!B10).
This allows what I enter into the source sheet to...
|
|
5 |
925 |
|
|
Recalculate the Formula by
Malcolm
Earlier today I was given 2 formulas for a problem I was having. I started
with a formula that worked and I wanted to add 2 conditions to it. The
formula...
|
|
2 |
946 |
|
|
Drop Down Lists 2007 by
tlynn
I have followed all the steps in creating a drop down list in Excel 2007:
Created Named list on seperate sheet
goto the sheet that the drop down will be on...
( 1 2)
|
June 2nd, 2010 01:19 PM
by Max
|
10 |
1,640 |
|
|
Finding identical rows in a list by
Brian Clarke[_2_]
I have a long list in columns A to I. In some cases, all the items in
adjacent rows are identical, and I need to be able to find these as
quickly as...
|
|
6 |
959 |
|
|
|
|
3 |
906 |
|
|
Locking A Sheet Using Words & Numbers by
Mumsy[_2_]
Before I got Office 2007 I was able to lock a spreadsheet using a word
combined with numbers, i.e., locksheet123. Now I can't lock it using that
formula I...
|
|
3 |
925 |
|
|
|
|
5 |
966 |
|
|
|
|
2 |
906 |
|
|
|
|
1 |
823 |
|
|
|
|
1 |
1,022 |
|
|
|
|
1 |
1,028 |
|
|
|
|
2 |
983 |
|
|
Case sensitivity of functions in Excel by
Raj[_4_]
Hi,
Which Excel functions are case sensitive and which are not?
Can anyone shed some light or point to some resource that explains the
case sensitivity of...
|
|
2 |
823 |
|
|
|
|
3 |
972 |
|
|
|
|
1 |
836 |