|
|
Compile data from several workbooks by
Space Elf
I have multiple workbooks for different projects. they are all in separate
sub folders. Within each wookbook is a worksheet I call Bug. The Bug sheet
pulls...
|
|
1 |
396 |
|
|
VLookup by
Mary Lou
nevermind my last question. i think i was looking at a different response.
going back to the drawing board.
"Jacob Skaria" wrote:
Try the below formula...
|
|
0 |
238 |
|
|
Macro to select last row by
Jacob Skaria
Try this one liner
Range("I2:I" & Cells(Rows.Count, _
"A").End(xlUp).Row).Formula = Range("I2").Formula
OR
Sheets("Sheetname").Range("I2:I" &...
|
|
0 |
302 |
|
|
Truth Table by
Victoria612
Thank you Jacob:
OK - I ran the macro and it resulted in a three column table of 27
rows....My apologies if I did not explain my intentions correctly..
I have...
|
|
0 |
202 |
|
|
Two Level Search by
Jacob Skaria
When you have multiple criteria use SUMPRODUCT()
=SUMPRODUCT((A1:A10=criteria1)*(B1:B10=criteria2),E1:E10)
If you are using Excel 2007 you can use SUMIFS()...
|
|
0 |
268 |
|
|
|
|
0 |
335 |
|
|
|
|
0 |
199 |
|
|
VLookup by
Mary Lou
I almost have it but am getting an error. If i am interpreting the formula
correctly, it says to give me the value in Sheet2 column c when both column a
and...
|
|
0 |
217 |
|
|
|
|
2 |
225 |
|
|
How to I combine excel worksheets? by
msnyc07
I have a large worksheet with about 200 sheets all with the same field layout.
I want to combine into one worksheet and pull the sheet name into columnX so
I...
|
|
5 |
269 |
|
|
Truth Table by
Victoria612
WAIT! 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...
|
|
0 |
160 |
|
|
|
|
0 |
187 |
|
|
|
|
0 |
196 |
|
|
|
|
5 |
303 |
|
|
|
|
8 |
430 |
|
|
|
|
11 |
554 |
|
|
Hour function equivelent help by
EAB1977
If I want to find out how many minutes there are for times that I have
summed, I know I can use the hour function if the compiled time is
less than 24 hours....
|
|
4 |
253 |
|
|
Compare between 2 worksheet by
Terry0928 via OfficeKB.com
Hi,
Could any one show me how I can compare two worksheet to find out if there
are any difference. The 2 worksheet might contain data like Name in column
A...
|
|
0 |
215 |
|
|
Array formulae do not recalculate by
Thanks
I have a large number of array formulae in my sheet. I update the supporting
data and the formulae do not recalculate. The only way i can get a recalc is...
|
|
2 |
214 |
|
|
|
|
1 |
263 |