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
If 3 If's, then sum by Steve
I need to add hours if 3 critera match. In the below, if there is a 90 in the G column AND a 10 in the J Column, AND a 100 in the D column, then add the H...
(Multi-page thread 1 2)
April 19th, 2010 04:51 PM
by Steve Go to last post
13 231
How to lookup multiple values and summing them up in one cell by Amr Abul Laban
I'd like to combine a sumif and vlookup function. Basically I want to lookup a "Name" in a table and sum up the corresponding grades (multiple cells)...
April 19th, 2010 02:57 PM
by Jessejames Go to last post
7 241
i dont know if sumif ,,,,, please help by Jessejames
i have 2000 rows and 2000 columns in one column, after searching for this product x. this value of all the product x will be summed up on below , for every...
April 19th, 2010 02:14 PM
by Eduardo Go to last post
2 160
COUNTIF PROBLEM by manfred3
Hi, I am using the countif formula in my spreadsheet to count the number of times "DPRS" appears in say column G. for some reason it keeps givong me the wrong...
April 19th, 2010 02:10 PM
by manfred3 Go to last post
6 99
Automatically insert rows/copy formula by JStiehl
I need to have the formulae in row 4 on the totals page be automatically copied and inserted in a new row underneath it if a 1 is entered in cell G21 on...
April 19th, 2010 01:55 PM
by Bernard Liengme Go to last post
1 107
Formula assistance please . . by J.Scargill[_2_]
Hi people, Had a query passed to me about a formula and despite my efforts, have reached the decision to seek help from your good selves! Worksheet looks like...
April 19th, 2010 10:59 AM
by Mike H Go to last post
3 105
Check the lasta character by Manos
Dear All i have a range of coding where some of them are ending in letter I. There is any way to group all of them? Or is it possible to create an if function...
April 19th, 2010 09:35 AM
by Mike H Go to last post
2 111
Compare two columns with different codes by Manos
Dear all I have two columns with codes. The first column include the main coding (ie: ab1, ab101, ab10101,...) The second column include the same codes, but...
April 19th, 2010 09:14 AM
by Manos Go to last post
2 129
excel 2007 macro recorded pivot table by getting old
I record a macro in excel 2007 in which i create a pivot table. when i try to run the macro i get "invalid procedure call or argument". the same process...
April 19th, 2010 09:06 AM
by Roger Govier[_8_] Go to last post
2 100
Function to seacrh for a word across multiple columns by Vibeke
Hi, I have four columns of data (C-F) I need to search for a particular word. The data is addresses, i.e. it combines text and numbers and the word I'm...
April 19th, 2010 09:01 AM
by Steve Dunn Go to last post
2 102
hiden cells copied automatically to another workbook, can I stop . by Fred
I have selected data from a workbook that is automatically updated to another workbook. It also copies the hiden cells, can I stop the hidden cells from...
April 19th, 2010 08:40 AM
by ozgrid.com Go to last post
2 105
need help with formula by Jay
Hi all, I am in a tricky situation. i have a table which basically includes 6 Columns. Date, Location,Location 2, No. of pieces, Weight,...
April 19th, 2010 05:42 AM
by ozgrid.com Go to last post
1 99
How do I match 3 different workbooks information for similar data? by dlh
I am working with 3 different workbooks that contain some similar data. I am trying to find a way I can match up that data in a separate workbook. The first...
April 19th, 2010 02:21 AM
by JLatham Go to last post
2 169
Conditional Copy from one worksheet to another by John Duich
Hello, I'm trying to do a conditional copy, for example: if H2 = ok copy B2 to G2 and paste in sheet 2. Not sure how best to do this... any help would be...
April 19th, 2010 02:10 AM
by JLatham Go to last post
1 115
compare 2 columns, enter data from other column by cap1816
I have been struggling with a formula - help! I want to copy data from one sheet to another but only if there is an exact match of data. I need help with...
April 19th, 2010 02:00 AM
by JLatham Go to last post
2 110
Deleting Row by BMP
I am using two worksheets (in the same file), each containing a vertical list of names. Worksheet B pulls a list of these names from from Worksheet A using...
April 19th, 2010 12:12 AM
by Max Go to last post
1 98
Validation of UK VAT Number by Rob
Hi, I want to check a number of VAT numbers using a formula, the first check is to ensure the number is 9 digits (may need to remove spaces to ensure clean...
(Multi-page thread 1 2 3)
April 18th, 2010 10:24 PM
by Rick Rothstein[_2_] Go to last post
22 516
how do I perform an interpolation analysis using Excel? by Nancy
I am trying to perform an interpolation analysis report for my physical chemistry lab class. We have to use Excel, but I have no idea how to do it there, any...
April 18th, 2010 09:36 PM
by Billns Go to last post
3 167
Complex functions by JP Ronse
Hi All, Suppose you have a very complex and long function that is also subject to a condition, then you will/can have something like: =if(condition(complex...
April 18th, 2010 06:23 PM
by Bernard Liengme Go to last post
1 129
Vlookup and Data Validation Q by Seanie
I am trying to use a DataValidation cell value to do a lookup and I get #N/a Cell N101 = a Data Validation list value Lookup formula in O101 =...
April 18th, 2010 04:33 PM
by Sheeloo Go to last post
2 119
Post New Thread


Display Options
Showing threads 1181 to 1200 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 01:10 AM.


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