|
|
Data Validation by
retired bill
I have a column in my worksheet in which I am using data validation with
V-lookup from another worksheet. When I click on the drop down list in the
column...
|
|
5 |
66 |
|
|
|
April 26th, 2009 01:58 PM
by joel
|
1 |
77 |
|
|
Excel formula help by
sam8
I'm trying to update assessment excel sheet of my college. I tried the
following formula for grades in 2007 excel and it worked fine. but the same
formula...
|
April 26th, 2009 11:26 AM
by sam8
|
7 |
124 |
|
|
|
|
0 |
103 |
|
|
link data from several speadsheets by
Sherry S[_2_]
Hi all,
I am trying to learn this as I go.
I have 31 speadsheets all in the same workbook to represent the days in the
month of January. They are exactly...
|
April 26th, 2009 09:26 AM
by AB
|
3 |
92 |
|
|
|
April 26th, 2009 06:58 AM
by Beau
|
0 |
112 |
|
|
EXCEL Help please by
Jesson
Does anyone know what formula i can use to look for specific text within a
range?
IE: i have 20 cells......... 5 have the word "orange" in them, 6 have the...
|
|
3 |
70 |
|
|
Flow Chart by
Chems23
Any ideas on how can I create a use a flowchart (from a worksheet) to create
an scenario that would give an answer to a particular process.
Example: I have A...
|
April 26th, 2009 03:57 AM
by Chems23
|
0 |
81 |
|
|
Office 2003 Excel funtion - data table by
Jolly
I often use the data table function in excel 2003 but while working on the
spreadsheet and not touching the cells with the "Table" function on adhoc
basis...
|
|
3 |
79 |
|
|
Trapping errors in a VLOOKUP function by
Blue Max
The VLOOKUP( ) function results in an #N/A error if an exact match cannot be
found when the 'range_lookup' value is FALSE. In our case, this error
taints...
|
|
1 |
81 |
|
|
How to refresh links across workbooks by
apache007
Dear all,
I have workbook A that has plenty cell references in other workbooks (about
10 workbooks approx). Currently, in order to refresh data in workbook...
|
|
1 |
77 |
|
|
Vlookup from more than one Tab by
DILipandey
Hi Experts,
Is there any way that vlookup can lookup value from more that one tabs.
Refer following formula:-
=vlookup(A1,(Sheet2!A:B,Sheet3!A:B),2,0)
So...
|
|
4 |
101 |
|
|
returning a SUM from text. by
tommyuptown
I have inserted yes/no checkboxes into a spreadsheet, I am looking for a
Sumif that will return a total for all yes' answers in the column.
|
April 25th, 2009 09:44 PM
by Mike H
|
1 |
60 |
|
|
|
|
2 |
53 |
|
|
Count Num of Unique items in col ? by
NaplesDave
I need to be able to count the number of times an item Uniquely appears in a
column. IE:
Result cell NAMED: Species
Contents of...
( 1 2)
|
April 25th, 2009 04:10 PM
by Sheeloo
|
11 |
114 |
|
|
Variable reference in a function by
Wildebraam Production
Is there a way to write an Excel function so it can read a variable and use
it as a reference?
For instance, to read a value from cell C1 in Sheet2 to A1 in...
|
|
3 |
60 |
|
|
|
|
1 |
71 |
|
|
SUMPRODUCT usage by
wild turkey no9
Hi There
Is there an easy way to configure sumproduct to do the following:
multiply col A * Col B when col B = either E or N or D
Thanks
Kevin
|
|
5 |
81 |
|
|
Extracting certain text from text string by
Haydie-lady[_2_]
I have a database list that I export into xls monthly. Once pasted in xls the
list is just one column w/ several rows a text string (see below). I need to...
|
|
2 |
76 |
|
|
Index match combination by
rhhince[_2_]
Can someone help me clarify this equation.
=INDEX(SLOPE!D507:D606,MATCH(MIN(SLOPE!BI507:BI606),SLOPE!A507:A606))
I am asking excel to go to column D of the...
|
|
4 |
80 |