|
|
Involved VLookup Function by
andiam24
Hello,
I'm using the following formula to pull a value from one of three worksheets
based on the criteria:
- lookup value is within the range 0.2 and...
|
|
3 |
158 |
|
|
Help on Formula by
Karthik
I've data copied from a .CSV file and pasted it to an excel sheet.
Column A-G is copied from .CSV File and Column H is calculated using formula
(=D1/F1/24) to...
|
May 20th, 2009 09:31 AM
by Max
|
5 |
310 |
|
|
|
May 20th, 2009 07:14 AM
by Max
|
4 |
214 |
|
|
|
|
3 |
242 |
|
|
|
May 20th, 2009 04:21 AM
by Bagia
|
0 |
198 |
|
|
Multiple Insert Copied Cells routine by
Matthew
Many times I find myself having to repeat the Insert Copied Cells routine,
but once you copy a set of rows, and choose the Insert Copied Cells from
Right...
|
|
1 |
223 |
|
|
Help with SMALL formula. by
Scott
I have a range of 144 rows. A1:A144 contain names, B1:B144 contain values.
I've successfully used the SMALL formula to sort the data 1 through 144, but
I'd...
|
May 20th, 2009 02:44 AM
by Max
|
6 |
215 |
|
|
Last Cell Reset Command- Built In by
Matthew
In Excel 2003, someone wrote an Add-In that cleaned up empty formatted cells
and reset the last cell. It worked pretty well. After upgrading to Excel
2007,...
|
|
0 |
216 |
|
|
How do I access the read-only box on my disc? by
How to uncheck read-only from my disc
The read-only box on my excel spread sheet is not checked. But when I save
it to my disc, then enter changes on it, I get a message that the folder is...
|
|
1 |
172 |
|
|
|
|
3 |
161 |
|
|
countif using two conditions by
NWO
Hello.
I read all of the COUNTIF , AND threads but did not find a solution to my
problem.
- I have a column of dates on one worklsheet
- I'm trying to...
|
May 20th, 2009 12:47 AM
by Max
|
1 |
164 |
|
|
|
|
1 |
295 |
|
|
How to handle something like this by
DK
I have a log at work with safety items. I log persons name, glove, safety
glass, ect. My "objective" is to create some type of excell sheet to gain
tallys of...
|
May 19th, 2009 11:40 PM
by DK
|
0 |
178 |
|
|
|
May 19th, 2009 11:26 PM
by Higgy
|
13 |
359 |
|
|
macro looping error by
pm
I have a spreadsheet that has 6 tabs and need to read the data in a specific
column (D) in each sheet...if the cell is not blank then store the data in a
new...
|
May 19th, 2009 11:24 PM
by pm
|
7 |
172 |
|
|
File size in Excel 07 by
Pip Langford
I have a report that I export from an accounting software package. The
report is not large. I have just upgraded to Office 07 and when I export the
report...
|
|
0 |
155 |
|
|
making a pricing matrix by
Aaron
To all,
I'm trying to make a formula that will compute a selling price based on my
matrix to work on a whole list of costs. THe problem is that the...
|
May 19th, 2009 10:27 PM
by Aaron
|
3 |
142 |
|
|
|
May 19th, 2009 10:03 PM
by FSt1
|
2 |
222 |
|
|
|
|
1 |
176 |
|
|
SUMPRODUCT by
ColleenK
Hi,
I am new to using the sumproduct formula, would someone be able to tell why
the following is not working:
=SUMPRODUCT('Detail...
|
|
0 |
192 |