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 Reverse Sort Order Last Post Replies Views
Set column function to round to nearest hundredth by
How do I get an entire column to round to the nearest one hundredh dollar?
September 25th, 2003 03:25 AM
by Ron Go to last post
2 402
Leading zero's in text join by
if it is formatted as text, it should not strip off the leading 0. -----Original Message----- I have 4 colums a,b,c,d I use A1&" "&B1&", "&C1 in colum d...
March 26th, 2004 10:35 PM
by Go to last post
0 441
Adding a column of numbers by
I have a large worksheet and have entered numbers in a column. Numbers range in value from 255 to 300. When I perform the +sum(a1.a12) function my result is...
April 27th, 2004 05:36 PM
by David Go to last post
3 348
Lookup returns N/A by
I have a worksheet with the following columns: Client Number Client Name These two columns are the result of a query that is pulled from an accounting...
June 8th, 2004 07:57 PM
by Michael Malinsky Go to last post
2 227
locking spreadsheets by
is it possible to lock my spreadsheet so that the formulas can only be changed by me with a password or something, so that if someone else is using my...
June 18th, 2004 06:11 PM
by Go to last post
2 154
color format by
Why can't I color part of a cell?: ="The month is " & TEXT(TODAY(),"Mmmm")
June 18th, 2004 07:07 PM
by Earl Kiosterud Go to last post
1 79
nested functions by
I would like to nest a function that would first filter the data in a column and then look for all of the "y" in that filtered column. I thought this would...
July 15th, 2004 12:05 AM
by Juan Sanchez Go to last post
3 223
excel locks on first cell I click by
the first cell i click locks and it acts like the starting point of a range but i cant unclick from that cell. I have to end task to get out help
July 15th, 2004 05:49 AM
by Norman Harker Go to last post
1 108
Header by
Is there a way in the custom header menu to use only the YYYY format for the date rather than the entire date.
July 17th, 2004 08:16 AM
by Frank Kabel Go to last post
1 114
Help by
Normally column C in my workeet is an eqaution eqault to a minus B, where A is an equation and B is a value. Occasionally, I have a user who wants to override...
February 14th, 2004 11:15 AM
by Frank Kabel Go to last post
3 117
rounding formula by
Is there a way to round a number to the nearest .5 - ie .5, 1.0, 1.5, 2.0, 2.5, 3.0, 3.5 etc TIA
February 6th, 2004 12:05 AM
by Go to last post
3 155
Sumif cell has a boarder by
Hi, I have a spreadsheet with a column that has cells with totals and cells with just numerical data. Each cell that I want to total has a boarder around it....
October 20th, 2003 03:08 PM
by Don Guillett Go to last post
2 299
auto open specific worksheet by
How can I set a workbook to automatically open to the specific worksheet I want when I open the workbook?
October 21st, 2003 09:55 PM
by Felipe Go to last post
2 195
auto filter macro by
I want to use auto filter or some other device to hide those rows whose first column has a zero in it. I would like to come up with a macro that automatically...
November 23rd, 2003 10:16 PM
by Don Guillett Go to last post
4 423
Solver by
When i ask solver to create a sensitivity report, solver only prints up half of the langrange multipliers. Does anyone know how to get the others printed up. I...
December 11th, 2003 01:12 AM
by Tushar Mehta Go to last post
1 133
Formula needs more than 256 columns by
I want to calculate a MMULT formula and I need a table of 319x319 cells. Can I divide the table over 2 sheets or in two parts on the same sheet and still use...
December 9th, 2003 07:40 PM
by Harlan Grove Go to last post
2 119
Counting items in one column based on another by
Hello, Working on a spreadsheet which will take information from a daily variable .xls down load, check the information, and then return values based on the...
January 16th, 2004 12:01 AM
by Sam Mitchell Go to last post
2 335
Relative vs. Absolute Values in Formulas by
I understand the concept of absolute and relative formulas. But what I can't seem to make happen is this scenario: A B C D E F 1...
January 23rd, 2004 12:59 AM
by Go to last post
0 510
formula needed by
Hello, I have a spreadsheet that calculates our attendance, time off, overtime etc. and I need to count the following: If ST1 OR ST2 OR ST3 (this stands for...
January 28th, 2004 10:22 PM
by Biff Go to last post
5 250
#VALUE by
I'm using the below formula and keep getting #VALUE as a result when D20 is 0 or D20 is blank--what I'm trying to achieve is if D20=0 OR D20 is blank, the...
July 26th, 2004 02:12 PM
by Go to last post
2 108
Post New Thread


Display Options
Showing threads 121 to 140 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 02:21 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.