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
automaticely highlight the row that I am working on by Cindy
Is there any function for me to set up color change for the row that I am working on, so, I won't mistype row for my worksheet?
April 19th, 2010 05:02 PM
by Luke M[_4_] Go to last post
5 201
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 352
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 407
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 233
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 168
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 206
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 186
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 201
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 219
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 202
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 177
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 227
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 193
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 243
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 197
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 180
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 172
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 921
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 277
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 191
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 10:29 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.