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
how do I clear #DIV/0!but leave the formula in cell by bc
when i was at work, i used to have an iserror formula. something like =iserror(k5/h7*100)0(k5/h7*100) , and this would leave 0 in the formula cell,...
June 23rd, 2009 01:21 PM
by Fred Smith[_4_] Go to last post
3 141
Subtotals - is there a way to include more information on the line by Acanesfan
I am using Excel 2007. I need to sort by job no and client no. Some clients have more than one no. Here is an unsorted list: Mgr Client...
June 23rd, 2009 12:50 PM
by Dave Peterson Go to last post
2 148
General Excel question by dolpandotcom
I have two columns in an excel sheet. One column shows 1 representing male and 2 represnting female. In the second column I have marks scored by males and...
(Multi-page thread 1 2 3)
June 23rd, 2009 11:59 AM
by dolpandotcom via OfficeKB.com Go to last post
24 471
How do you remove the page number watermark from an excel? by Lynnay
How do you remove the large page # watermark from displaying in the background?
June 23rd, 2009 10:33 AM
by Jacob Skaria Go to last post
1 165
Multiple sear criteria by Shah Alam[_2_]
Dear experts, in a work sheet i want four or five searching key cells with subtotal. suppose, i want to search with "StartDate and enddate" "Region",...
June 23rd, 2009 10:06 AM
by Shah Alam[_2_] Go to last post
2 162
How can I delete the rulers from my worksheet in 2007 Excel? by Dee
I would like to be able to print my worksheet with out the rulers on it.
June 23rd, 2009 10:02 AM
by Sheeloo Go to last post
1 150
select ever other line by [email protected]
is there a way to selct every other line for a copy and past pourpoe not sahde every otehr line by select
June 23rd, 2009 07:17 AM
by Ron@Buy Go to last post
1 149
SUMIF on a collection of individual cells by Fred Holmes
Excel 2000 R1C1 reference notation What is the syntax for the SUMIF function if the range to be summed is a collection of indivicual cells - separated by...
June 23rd, 2009 03:40 AM
by Fred Holmes Go to last post
9 263
counting values ignoring duplicates by matt3542
Hi there, I am trying to count the number of values in a column (A2:A217) ignoring duplicated values. As an eg, applying this to the data below I would...
(Multi-page thread 1 2)
June 23rd, 2009 03:10 AM
by Gary Go to last post
12 311
CountIf question by Stuck
I'm having an issue adding additional criteria to my formula. Here is my current formula: =COUNTIF(OFFSET($P$9,0,0,(COUNTA($A:$A))-2,1),$P3) Column A has...
June 23rd, 2009 03:01 AM
by T. Valko Go to last post
2 149
Rental yeild formula? by Scoober
Hi, Can someone help me with =IF(AND(V24="",H24=""),"",SUM(V24/H24)) H24 = Property value V24 = Rental return W24 = Answer from equation
June 23rd, 2009 02:28 AM
by Teethless mama Go to last post
1 166
extract cusotmer name from test string by Dinesh
I have long string of text that start with customer name. Immediately after the text string, it populates either the schedule # (which start with "sch") or...
June 23rd, 2009 01:27 AM
by Ashish Mathur[_2_] Go to last post
5 160
Macros by Noxzema
My office just upgraded to MS Office 2007 and I am having some problems with the macros in Excel and Word. I have recorded them correctly and most of them...
June 23rd, 2009 12:07 AM
by Noxzema Go to last post
7 136
Autopopulating formulass horizontally? by Leonhardtk
If I create the formula in A1: =Worksheet!I4 I want to drag this to the right to copy the formula to other cells to the right. By default, A2 would...
June 22nd, 2009 11:54 PM
by Bassman62 Go to last post
4 139
Last "non-blank" value in a Row... by Leonhardtk
I've found solutions for finding the last non-blank/non-zero value in a column, but I couldn't figure out how to convert for a row: Previously I had five...
June 22nd, 2009 11:12 PM
by T. Valko Go to last post
2 112
desperate.. convert to number column... by triple
I've tried this for couple hours and it's time to seek help now. I have a big chunk of data importing from Klippel, a software that I believe most people...
June 22nd, 2009 11:08 PM
by Sean Timmons Go to last post
1 141
One workbook with 62 worksheets by Colts41
I have an old Excel workbook that might have started out as a Lotus 123 workbook. The original creator of the workbook is long gone and forgotten. My...
(Multi-page thread 1 2)
June 22nd, 2009 10:38 PM
by Colts41 Go to last post
11 287
If statements refering to data validated ranges by skimark
I am creating a spredsheet where a series of questions are posed with data validated answers - such as '0-6 months' or 'over 6 months'. Then I want to add an...
June 22nd, 2009 10:38 PM
by Tom Hutchins Go to last post
2 149
Sumif based on dates by IlliniEric
I have a table that in one column lists a date and in another column a dollar amount. On the same sheet I have second table that in one column lists a date. ...
June 22nd, 2009 10:25 PM
by Teethless mama Go to last post
3 125
Formular Function by Kanmi
Please can anybody explain this formula function =VLOOKUP($C14,'WPS Detail Dates'!$B:$H,4,FALSE).
June 22nd, 2009 10:06 PM
by Teethless mama Go to last post
2 138
Post New Thread


Display Options
Showing threads 9881 to 9900 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:22 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.