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
IF THEN Statement by barbara h
I need to do a calculation based on a cell. If cell B12 = 0, then I need to calculate a formula (B13*.40). If cell B12 0, then value = 0. Can anybody...
February 11th, 2010 05:48 PM
by Eduardo Go to last post
1 88
Function updating all worksheets in workbook by PK
I have a function in VBA as detailed at the end of my text and it is updating all worksheets in a workbook rather than just the active one. I have 12...
February 11th, 2010 04:59 PM
by Mike H Go to last post
8 164
Calculate days help by Kim K
I am needing to calculate dates. What I need to accomplish, is according to a school calendar, which has weekends, holidays and other specified dates off...
February 11th, 2010 04:39 PM
by Fred Smith[_4_] Go to last post
2 93
can I autopopulate from a long drop down list in Excel? by seve
I have a very long list of referring physicians in a drop down list for data entry people to populate. I would like them to type in the first 3 characters...
February 11th, 2010 03:48 PM
by Otto Moehrbach[_2_] Go to last post
2 141
Number of days by HK[_2_]
I connection with some (simple) interest calculation (where interest rate is fixed every 1st July and 1st January and where interest calculation is based on...
February 11th, 2010 03:44 PM
by HK[_2_] Go to last post
2 101
Lookup / Index/Match by Joe
My spreadsheet is setup as follows: Column A B C D E County Road ...
February 11th, 2010 02:12 PM
by Joe Go to last post
3 87
Vlookup formula by Vijay
Iam using vlookup formula and the ce;ll which has no value gives me #N/A. I want 0 there.How can I do that. Thanks Vijay
February 11th, 2010 01:46 PM
by Gary''s Student Go to last post
3 91
Extracting elements of a string cell by PK
I have various cells some of which hold an alpha-number field, some hold an alpha-number-alpha-number field, some are blank. These range for example from...
(Multi-page thread 1 2)
February 11th, 2010 12:58 PM
by PK Go to last post
11 208
Comment Box by pipinghotxx[_2_]
I have an existing spreadsheet (that i didnt set up) that when you click on a cell it automatically comes up with what looks like a comment box but there no...
February 11th, 2010 12:37 PM
by Gary''s Student Go to last post
1 80
Hightlight cells that contain special characters by Gareth_Evans (InterCall EMEA)[_2_]
Hi there, I have a spreadsheet containing first & last names (columns A & B), up to 10,000 rows and some of the names contain 'foreign' characters - such as...
(Multi-page thread 1 2)
February 11th, 2010 11:45 AM
by Stefi Go to last post
12 147
Excel - Calculate age from DOB in years, months days by Polly
Might seem obvious but I can't find an answer in Excel Help. I am trying to calculate age in years, months and days by subtracting cell containing date of...
February 11th, 2010 11:21 AM
by Polly Go to last post
7 121
how do i set up a user prompt at the start of an excel workbook ? by Mark
I need to create a security feature which requests the users agreement prior to entering into a worksheet. How do I do that?
February 11th, 2010 11:04 AM
by Mike H Go to last post
1 82
How can I define date range criteria in SUMIF formula? by LisaR
Hi, I am trying to use excel to forecast payments owing in each month. If column A is a list of dates and column B the amounts owing how can I set up the...
February 11th, 2010 09:13 AM
by Bob Phillips[_3_] Go to last post
1 83
Excel formula help by Pags10
I work for a temporary housing company and would like to create a calendar where all i have to do is put the clients name and dates they are staying in a...
February 11th, 2010 06:47 AM
by Ando Go to last post
1 95
Data Validation Lists by Sue
I have a question regarding the drop downs lists created using Data Validation. Is there any way to make them so that when I type something new into the box...
February 11th, 2010 04:58 AM
by WallyWallWhackr Go to last post
5 113
Empty Cell-conditional formatting by smack
I have a column where I enter a date when a document arrives. If it is left blank for more than 7 days I need an alert. I also have a start date in A1 to...
February 11th, 2010 04:07 AM
by Fred Smith[_4_] Go to last post
1 79
Sorting data field by Bill C[_2_]
I would like to sort the data in a sheet that is 6-9 columns wide so as to find the event(s) when 3 consecutive horizontal cells in a row have the same info....
February 11th, 2010 04:05 AM
by Fred Smith[_4_] Go to last post
1 75
Calculate # of years by JT
I need to be able to calculate the estimated age of a piece of equipment beginning at it's construction date. For example: Air Handler "A" was built in...
February 11th, 2010 03:43 AM
by Fred Smith[_4_] Go to last post
6 108
Using the Icon Set for Conditional Formatting by Gino59
Hi! I have a column of currency values that I'm trying to conditionally format with the arrow icon set (red, green, yellow). What I'm trying to do is...
February 11th, 2010 03:12 AM
by Herbert Seidenberg Go to last post
1 101
'Reverse' Concatenate by msnyc07
By which I mean removing part of a string. Basically I want do something like If Column A Contains String X then Remove Character A from end of Column B
February 11th, 2010 02:36 AM
by FSt1 Go to last post
5 118
Post New Thread


Display Options
Showing threads 3041 to 3060 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 03:28 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.