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
Data Validation by Tony
One a drop-down box is created for selection can it populate multiple cells with its selection. Can I create a table with 3 columns and populate 3 cells when I...
January 25th, 2005 09:44 PM
by Debra Dalgleish Go to last post
2 83
change date function format in footer by Tori
I would like to change the automatic date function in my footer to ie. January 25, 2005 instead of 01/25/05??
January 25th, 2005 08:18 PM
by Gord Dibben Go to last post
1 275
Separating data ( 1 time range) in one column by Steve
I have the following cell: 0800-1000 I need to ref 0800 in one column & 1000 in another, to ultimately subtract 0800 from 1000 to get 2 hours. What function...
January 25th, 2005 07:59 PM
by Steve Go to last post
2 107
How do I find a mode while disregarding a specific cell value? by glasskit
I would like to create a function that finds the mode of a range of cells, but does not consider a particular value in the range.
January 25th, 2005 07:47 PM
by Peo Sjoblom Go to last post
1 93
dynamic combo boxes by tjb
OK, basically what I want is one combo box with three options: "Yes", "No" and "Void and Reissue". When the user selects "Yes" from the first combo box I want...
January 25th, 2005 07:33 PM
by Tim C Go to last post
2 328
how do i calculate my mortgage payments by mike
what sort of funtions are available to assist me with my mortgage payments thx mike
January 25th, 2005 05:42 PM
by Gord Dibben Go to last post
3 211
delete all text to the left of??? by Sheila
I want to put a list in column A that will be the paths to the files I have, (ie c:\Program Files\Common Files\Microsoft\Stationery\signature.htm), but I wqant...
January 25th, 2005 05:30 PM
by Harlan Grove Go to last post
3 89
how to use vlookup formula by kirky
example of a vlookup formula
January 25th, 2005 05:23 PM
by Peo Sjoblom Go to last post
2 149
sumif and array formulas by Bruce
In the following formaula i am essentually summing a range if another range in the same row = zero =IF(SUM(CT2:CW2)=0,SUM(CW2:DH2),0) My worksheet fill this...
January 25th, 2005 05:22 PM
by Harlan Grove Go to last post
5 165
formula to combine cells using if/then by Linda G
Primary First Primay Last Secondary First Secondary Last First Last John Smith Debbie John & Debbie Carl Overstreet June Overstreet Carl &...
January 25th, 2005 02:51 PM
by Linda G Go to last post
2 126
Formulars by med211
I there a formula to be able to take the total for 12 different worksheets and put them on a different worksheet? Tks, Jeff
January 25th, 2005 02:34 PM
by JulieD Go to last post
1 87
Do you have instructions for making check boxes? by Renee Alborn
I am needing to add check boxes to a form in excel. Can someone give me the instructions on how to do this? Thanks in advance.
January 25th, 2005 02:05 PM
by Bob Phillips Go to last post
1 165
Sum If Multiple Conditions by Grant
I need help with my formula. I am trying sum data based on multiple conditions. I used SUMPRODUCT in the past to do this. Column F needs to greater than...
January 25th, 2005 02:02 PM
by JulieD Go to last post
3 296
how do I adjust working calendar (6 day work week) in excel that . by Hatem
I need to use the WORKDAY function, but adjust the working calendar to have Friday and Saturday as the weekend, and in another case to work with 6 day work...
January 25th, 2005 12:04 PM
by Bob Phillips Go to last post
1 388
I want to use Vlookup function and AND function in a single formu. by prakash
We have created excel spreadsheet. In one column we have description of the activity , 2nd column has activitiy ranges. We have to build an VLOOKUP formula to...
January 25th, 2005 07:11 AM
by prakash Go to last post
3 281
Using SUMPRODUCT...but prolly not correctly by Qaspec
I posted this a few hours ago. I know it's annoying to repost but and I apologize but I read my own post and confused myself. So I wanted to make my post...
January 25th, 2005 04:15 AM
by Biff Go to last post
1 108
Best technique to perform multiple calculations ? by [email protected]
Hi, Little help please, with best technique to perform multiple calculations. A1 FileNum Customer (TotalWorkOrders by...
January 25th, 2005 03:49 AM
by Max Go to last post
5 127
How sort dates just by day/month and NOT year if all 3 given in ce by smags
How can I sort dates in a column just by the day and month and NOT the year if all three items are given in each cell? Example, I want to sort the following...
January 25th, 2005 03:45 AM
by Peo Sjoblom Go to last post
1 201
No Gridlines by HagLight
When I bring in a converted 123 File, I can not get the worksheet gridlines to display. Any suggestions?
January 25th, 2005 03:29 AM
by Karl K Go to last post
4 140
How do I format a column to automatically make it a negative numbe by Kathy
I need to setup credit columns that will automatically be negative numbers in red and brackets without having to manually put in the minus sign. I have done...
January 25th, 2005 03:15 AM
by Roland Go to last post
1 228
Post New Thread


Display Options
Showing threads 77601 to 77620 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 04:31 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.