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
Help needed urgently by AndyW
Hi, Im trying to check that one row of data satifies a criteria, then if it does it counts an entry in another column adjescent to it. Example: - Column A...
May 30th, 2010 05:07 PM
by T. Valko Go to last post
4 810
CONVERT function for Excel 2003 by Chandrahas
I was trying to format time in decimals to days:hours:mins format. While using microsoft excel 2003 help, they said to use CONVERT funtion for the same. But...
May 30th, 2010 04:51 PM
by Gord Dibben Go to last post
2 807
Conditional formula yeilds non-number result by RichM
Hello, I made conditional formulas but with the numbers that result I am unable to calculate their average. I get the #DIV/0! error. They are formatted as...
May 30th, 2010 04:36 PM
by Teethless mama Go to last post
6 855
Password to open excel file by Suresh Lohar
How a password is set in excel sheet. When double click an excel file, first of all you see protected and a window appeared, asking for password to open...
May 30th, 2010 03:32 PM
by JP Ronse Go to last post
2 754
copy and past cells found by SUMPRODUCT by Tromal
I have colum A and B. I use SUMPRODUCT to calculate the sum of values in column B with a criteria. What I would like to do is copy the cells from column A...
May 30th, 2010 02:03 PM
by Bernard Liengme Go to last post
1 860
countblank with sumproduct? by Rene
Hi, SUMPRODUCT(--(S3:S44="A"),--(E3:M44100),--(E3:M44=200))/SUMPRODUCT(--(S3:S44="A"),--(E3:M44"")) doesn't work unless it is E3:E44 Looking to modify...
May 30th, 2010 02:21 AM
by Brad Go to last post
1 717
Active Cell Border Color by Linda Oshkosh WI
I know this can be done, I just can remember how or seem to be able to find it under help. I would like the border around my active cell to be a different...
May 29th, 2010 09:12 PM
by Steve Iommi Go to last post
2 1,926
Conditional formula by RichM
Hello, I want to make all the conditions occur in cell b1: if cell a1 = 1 then cell b = 7 if cell a1 = 2 then cell b = 6 if cell a1 = 3 then cell b = 5 if...
May 29th, 2010 06:45 PM
by RichM Go to last post
3 723
Latest Taxation Books available at jain book depot LATEST BOOKRELEASES by JACK ANDERSON
Dear Sir/ Madam NABHI is NABHI We are pleased to inform you that the 39th complete Revised Edition of the book NABHI's Income Tax Guidelines & Mini Ready...
May 29th, 2010 01:25 PM
by JACK ANDERSON Go to last post
0 872
Pivot from multiple sheets by Radhakant Panigrahi
hi, i have the below data and i need to make pivot from multiple sheets.i have tried to make by selecting multiple consolidation ranges, bbut it is not...
May 29th, 2010 05:20 AM
by Herbert Seidenberg Go to last post
1 940
Header Information by Belin
I am doing a spreadsheet for my school. I am trying to put a title up top like where the letters A, B C D are. How do I go about doing that??? Thanks
May 29th, 2010 03:31 AM
by Dave Peterson Go to last post
1 676
macrio soft exel by dheeraj sharma
sir i want to find that ,in the row of an exel sheet if i hilighted one or more one cell then i want to count that cell how?i can found ?
May 29th, 2010 03:11 AM
by Ashish Mathur[_2_] Go to last post
2 687
Returning a value if multiple conditions are met by Joel
I am trying to develop a method which will return a value if each of three conditions are met. The three conditions, each with a differing number of...
May 29th, 2010 03:05 AM
by Ashish Mathur[_2_] Go to last post
2 725
averageif with 3 crieteria by Rene
SUMPRODUCT(--(S498:S534="a"),--(G498:G534=100),--(G498:G534=200))/SUMPRODUCT(--(S498:S534="a"),--(G498:G534"")) I searched questions already answered but...
May 29th, 2010 12:38 AM
by Ashish Mathur[_2_] Go to last post
2 694
Calculating date/time intervals?? by JJ
I have multiple sets of date/time value combinations. For each start time (date/time) and finish time (date/time), I need a formula that calculates the...
May 29th, 2010 12:24 AM
by Ashish Mathur[_2_] Go to last post
1 757
Hold a cell range for an "average formula" by Wendy Akers
I add a column every week to my work sheet and want the formula to always calculate the current 5 column range.
May 29th, 2010 12:14 AM
by Ashish Mathur[_2_] Go to last post
2 799
Need to do a data check - not sure the best way. by cmjat
Okay, I'm working with a team that does QC checks. One person does the work, another QC's the work and a third QC's the QC. To further complicate matters...
May 29th, 2010 12:02 AM
by Dave Peterson Go to last post
1 671
I can't input anything I type on Excel. What can I do? Nothing p. by nakalkn
I can't use Excel worksheet. I can't type anything on my Excel worksheet. What can I do to clear this and be able to work with the go-to command?
May 28th, 2010 11:40 PM
by Gord Dibben Go to last post
1 671
zero value in cell by Arthur
I have a table of engineering calculations. The same formula in each cell operation on variables in the row and column headers. i use the MIN function to...
May 28th, 2010 11:06 PM
by Arthur Go to last post
2 658
export data between spreadsheets by scott
Hello, how do I setup an excel file that each time when I enter data in one file it will export to another file in the same column of subsequent rows?...
May 28th, 2010 10:11 PM
by Gord Dibben Go to last post
1 709
Post New Thread


Display Options
Showing threads 181 to 200 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:02 AM.


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