|
|
|
|
3 |
140 |
|
|
Refer to a named range indirectly by
tberkom
I'm looking to refer to a named range in a VLOOKUP formula that gets its
value from another cell. In other words, the cell contains a text value that...
|
|
1 |
165 |
|
|
To Calculate the qty b/w two dates by
vmohan1978
In Sheet 1 the table is as below
SL.NO Received Dia Qty (MT)
1 29-Mar-03 20 19.89
2 31-Mar-08 10 6.51
3 31-Mar-08 10 0.63
4 11-Apr-08 10 1.43...
|
|
3 |
119 |
|
|
Renaming worksheets by
James
I have an excel 2003 Checksheet that needs to be undertaken on a daily basis.
I would like it have a copy of the original checksheet for every day of the...
|
May 12th, 2009 11:45 PM
by James
|
0 |
160 |
|
|
DSUM to pull data from Access DB by
Brian[_16_]
Howdy All,
I'm trying to sum data contained in an Access DB based on multiple criteria.
DB name = FTD.mdb
location = c:\FTD.mdb
I'm trying to sum Labor...
|
|
2 |
188 |
|
|
|
|
2 |
158 |
|
|
Format Cell by
bennetto
I need to limit a cell to 30 digits.
|
|
5 |
162 |
|
|
Linking data? by
Ron_Ron
I have one sheet with a list of ID numbers and there corresponding names. In
another sheed I have 100,000+ rows of data that contain the ID number as well
as...
|
|
2 |
153 |
|
|
SUMPRODUCT Help by
RoadKill
Here is my formula:
=SUMPRODUCT(('5-1'!$B$2:$B$1000="John Doe")&('5-1'!$D$2:$D$1000="Product
One")&('5-1'!$D$2:$D$1000="Product...
|
|
7 |
137 |
|
|
|
|
3 |
132 |
|
|
|
|
1 |
167 |
|
|
4 IFs by
Steve
How can 4 ifs give me one of 3 numbers in the following situations:
If between 1200-2000, = 3
If between 2001-2400, = 1
If between 0001-0400, = 1
If...
|
May 12th, 2009 09:41 PM
by Steve
|
4 |
135 |
|
|
excell big dilemma by
dingbat
Hi again,,,, I work for a bus company and would like to link sheets in a
workbook I have list of duties on one sheet with times they start and end.
Within...
|
|
0 |
127 |
|
|
Vlookup for multiple results by
Kris
I am trying to create a formula that will compare lists and return data for
as many times as it finds the name in a column.
For instance, I have a vendor...
|
|
3 |
140 |
|
|
|
|
3 |
129 |
|
|
Sumproduct excluding multiple criteria by
Ivano
Hi,
I'm trying to use the SUMPRODUCT formula to add up a colunm but exlude
certain values based on a criteria in another column. I have column A which
has...
|
|
4 |
141 |
|
|
sum of every 4th cell in a row. by
Monique
I am trying to set up a spread sheet where each element in a row has four
different columns of data. At the end of the row I need to do various
calculations...
|
|
3 |
134 |
|
|
New row(s) macro by
PSM
What code can I use to attach to a button whereby the user can input how many rows and which row to add them from ?
Thanks
Phil
|
|
1 |
134 |
|
|
Link changes in destination workbook by
confused
I have 2 workbooks linked - when I insert a row in the source workbook the
destination workbook does not update (even when I do an update).
ex. cell A2 in...
|
May 12th, 2009 06:06 PM
by Cindy
|
2 |
70 |
|
|
Survey Form And Tracking Results by
Joe Gieder
Can a survey form be setup in Excel and track all the results? I have seen a
few examples but these only look like they can have a form but when hundreds
of...
|
|
2 |
146 |