|
|
|
May 27th, 2010 10:21 PM
by Mike H
|
2 |
295 |
|
|
VLookup by
burtlake
Your situation sounds similar to mine. See the question entitled "Two Level
Search" - about 7 "posts" below yours. I was able to use the advice prvided
(by...
|
|
0 |
264 |
|
|
Countif Formulas by
jay
I have two worksheets. I want to feed data from one to the next to tally
occurrences of key words in two columns according to month in another...
|
May 27th, 2010 10:12 PM
by jay
|
2 |
338 |
|
|
VLookup by
Jacob Skaria
Try the below formula in sheet1 say in (cell D1) and copy to the right to
retrieve Fees Billed & Hrs Billed. Format the formula cell to display as...
|
|
0 |
276 |
|
|
|
|
2 |
414 |
|
|
arquivo excel worksheet by
gege
boa noite recebi o arquivo excel worksheet e nao consigo abrir, e quando
tento abrir aparece esta mensagem: microsoft excel viewer cannot open files
of...
|
May 27th, 2010 10:06 PM
by gege
|
0 |
319 |
|
|
IF on a range of cells by
Syed Zeeshan Haider[_2_]
Hello Everybody,
I am working in Excel 2003 with two lists, dates and prices in columns A and
B respectively.
I am trying to use IF worksheet function to find...
|
|
2 |
246 |
|
|
|
May 27th, 2010 10:01 PM
by Anita
|
0 |
281 |
|
|
|
|
1 |
263 |
|
|
|
May 27th, 2010 09:51 PM
by Mike H
|
0 |
274 |
|
|
|
May 27th, 2010 09:50 PM
by Mike H
|
0 |
278 |
|
|
create overtime spread sheet by
peterbirss222
I wish to have a cumulative hours column and a date column.
So the hours are scaled upwards and the column associated with a person and
a date to show who did...
|
|
0 |
345 |
|
|
Macro to build table by
Victoria612
I think I got it - can someone confirm this is accurate?
Sub Macro()
Dim lngRow As Long
Dim intA As Integer, intB As Integer, intC As Integer, intD As...
|
|
1 |
191 |
|
|
Linking text cells between 2 worksheets by
FSt1
hi
try your formula like this.....
=IF(sheet1!B6="","",sheet1!B6)
this would not produce a zero on sheet 2 but would carry data to sheet 2 if
data exist on...
|
|
1 |
240 |
|
|
|
|
1 |
211 |
|
|
|
May 27th, 2010 09:49 PM
by Mike H
|
0 |
298 |
|
|
Fill last row down for large selection? by
msnyc07
Of found the answer, generously provided by Eduardo if anyone is interested
for future reference:
Select the cells in the column, starting in the row below...
|
|
1 |
388 |
|
|
|
|
1 |
283 |
|
|
Truth Table by
Victoria612
I stand corrected - is there a way to program a macro that can determine all
72 possible scenarios?
"Victoria612" wrote:
OK - I have 6 questions, all of...
|
|
0 |
236 |
|
|
Find and Replace by
vicktina
We are using a scanner to input a barcode number into "Find What" box in find
and replace in excel. Is there a way to make it stay highlighted for the next...
|
|
0 |
217 |