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
simple function by
Hi, I have a simple function to figure out but without much experience. I hope someone will answer. Let's say I have two columns A & B. I want a formula...
October 15th, 2003 08:40 PM
by Go to last post
7 73
data validation & formulas by
Hello great folks who have saved me more than once: I have a data validation list (drop down list) in one cell, which offers a choice of 3 different...
June 16th, 2004 08:10 PM
by Go to last post
8 139
Excel if formula maybe by
I want a formula to do this if c2 = Holiday or Bank Hol then display 8 (in the cell im typing the formula) if not do another formula (on the info in c2)
July 7th, 2004 12:07 PM
by Aladin Akyurek Go to last post
1 38
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 67
#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 54
mistake by
August 8th, 2004 09:46 PM
by Go to last post
0 91
Trim leading zeros by
How do I trim leading zeros from a cells? 000000023 000000003 000000010 Thanks!
August 12th, 2004 03:28 PM
by sulprobil Go to last post
2 112
Conditional Cell Formatting by
I am trying to point the conditions of 'conditional formatting' to a formula in another cell. Is there an easy way to do this?
August 25th, 2004 08:25 PM
by Frank Kabel Go to last post
2 45
excel formula by
I have a spread sheet in which column A has Account numbers and also Salary. So A1=Smith and A2=5,000. and so on. In another sheet, I would like to have...
September 10th, 2004 06:35 PM
by Frank Kabel Go to last post
1 61
EXCEL Help Please by
When i do my accounts like so 150.00 and press enter to add the total the decimal point changes to a square.
June 1st, 2004 05:19 PM
by Go to last post
3 66
variable reference in hlookup array by
Hi, I have many Hlookup functions in which the array is in one of many sheets, all named with a number (say 1000). Since there are many of these numbered...
May 10th, 2004 10:13 AM
by Harlan Grove Go to last post
4 100
finding the date in a sheet by
First, Name your data range B2:H5202 as DATA Then, insert the formula =Today() in an unused cell and name that cell TODAY Switch to VBA and insert a module...
December 2nd, 2003 10:20 PM
by Dale Hymel Go to last post
1 82
printing several sheets as one by
I have several sheets, but not all sheets fill one page when printed. I would like to append those sheets that fill less than a page together, so when I print...
December 31st, 2003 04:58 PM
by Dan C. Go to last post
1 102
Locking other cells based on values in a cell by
| A| B| C| D| ------------------------------------------ 1|Task |Desc |Hrs |Date | 2|Stucco | 3|Paint | 4|Plumb | Lets say above is my sample spread...
January 13th, 2004 01:53 AM
by Dave Smith Go to last post
3 293
Countif Formula by
I am using a formula in cell C1 =3Dcountif(B9:B500,"500") This formula will look in column B (which is a column with=20 values in =A3's) and tell me how...
January 13th, 2004 05:17 PM
by Bob Phillips Go to last post
5 76
Formula not updating by
I entered a SUM formula and when I change the contents in its range the total is not updated. Any ideas?
January 14th, 2004 03:00 PM
by Bingo Go to last post
1 63
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 205
Excel XP (2002) Auto Filter problem by
I turn on autofilter to limit my view of data in my list, I then try to change the contents of the viewed data; but the underlining hidden data will also...
February 29th, 2004 08:21 PM
by Ken Wright Go to last post
1 115
Per Diem Caculation by
I am writing a spreadsheet to figure Travel Vouchers for myself and my Army classmates. I've everything except for Meal payments on weekends. Got the date...
March 7th, 2004 01:38 AM
by Peo Sjoblom Go to last post
4 53
Cell by
I type account number in cell and it turn into 2.50021e+12. I check the format o cell and it just gernral. The 2.50021e+12 is underline. I not sure wy the cell...
September 20th, 2004 06:35 PM
by Lady Layla Go to last post
2 75
Post New Thread


Display Options
Showing threads 261 to 280 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 05:56 PM.


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