A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
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...
May 27th, 2010 09:33 PM
by Jacob Skaria Go to last post
1 392
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...
May 27th, 2010 09:33 PM
by Mary Lou Go to last post
0 235
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" &...
May 27th, 2010 09:33 PM
by Jacob Skaria Go to last post
0 298
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...
May 27th, 2010 09:30 PM
by Victoria612 Go to last post
0 199
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()...
May 27th, 2010 09:29 PM
by Jacob Skaria Go to last post
0 262
Using a COUNTIF statement with an AND operator by RonaldoOneNil
Assuming number of people is in column A and group work is in column B, use the following adjusting the range as...
May 27th, 2010 09:29 PM
by RonaldoOneNil Go to last post
0 331
Returning a value if multiple conditions are met by Jacob Skaria
Try the below in cell D1..with data in Sheet1 and query values in current sheet...
May 27th, 2010 09:28 PM
by Jacob Skaria Go to last post
0 194
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...
May 27th, 2010 09:22 PM
by Mary Lou Go to last post
0 211
Is there a way to "glue" a matrix rectangle of cells together? by Dshope
The cells would only be moved as a group, but could be detached from each other at some point.
May 27th, 2010 09:20 PM
by Gary''s Student Go to last post
2 199
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...
May 27th, 2010 09:19 PM
by Ron de Bruin Go to last post
5 249
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...
May 27th, 2010 09:16 PM
by Victoria612 Go to last post
0 154
Having info in a certain cell EXACTLY same as in cell on anoth by OnePuttJames
"Max" wrote: In your summary tab, place this in any starting cell, say in B2: ...
May 27th, 2010 09:10 PM
by OnePuttJames Go to last post
0 182
Using a COUNTIF statement with an AND operator by JTurner
AND...I'd be more than happy to pass along the actual worksheet if that would be helpful...
May 27th, 2010 09:05 PM
by JTurner Go to last post
0 193
How do I determine which data in a range add up to a fixed number? by Mray
How do i take a range of numbers and determine which numbers in the range add up to 120? or as close to it as possible? I have list of 67 numbers totaling...
May 27th, 2010 09:04 PM
by Tom-S[_2_] Go to last post
5 281
Change cell color based on another cell value by danielocope
Hi All I must be thick headed; I have looked through most of the posts here for help and some come very close to answering my question, or maybe it’s just...
May 27th, 2010 03:09 PM
by Gord Dibben Go to last post
8 427
Negative result gives #### is there a way to show the actual - num by catts22
Hi The result of a formula gives me ##### for a negative number. Is there a way to get the actual negative number (i.e. for example -9 instead of...
(Multi-page thread 1 2)
May 27th, 2010 02:57 PM
by Luke M[_4_] Go to last post
11 548
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....
May 26th, 2010 01:40 PM
by EAB1977 Go to last post
4 229
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...
May 26th, 2010 12:25 PM
by Terry0928 via OfficeKB.com Go to last post
0 194
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...
May 26th, 2010 09:44 AM
by Charles Williams Go to last post
2 195
Searching Multiple Timesheets for a project code and then.... by Saitei
I need some help on this one!! I am trying to scan multiple timesheets in excel for a project code and then capturing the hours worked for that project. I...
May 26th, 2010 08:11 AM
by Matt's Dad Go to last post
1 240
Post New Thread


Display Options
Showing threads 301 to 320 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:16 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.