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
Basic Formula rules by Stan
How does a complete beginner go about creating a formula? Is there a list of what each letter & symbol represents and how & where to use them? So far I have...
January 25th, 2005 01:28 AM
by Bob Phillips Go to last post
2 98
Increase the number of the invoice by John B
Hello to everybody, I have an invoice template almost finished and I would like to add a button that increase the numer of the invoice of 1. How may I do...
January 25th, 2005 01:43 AM
by Gord Dibben Go to last post
1 240
timesheet with running totals of overtime by kimmyrt
Hi, I'm trying to create a very simple time sheet by weeks, not days. column A is employees name, B is the week worked, C is total hrs. for that week, D is...
January 25th, 2005 01:45 AM
by Gord Dibben Go to last post
2 184
How do I auto fill formulas by dorheldav
In the past, I could create tables where I entered formulas in 2 cells then dragged the handle down and Excel would autofill the formula in the...
January 25th, 2005 02:48 AM
by CLR Go to last post
1 83
Adding values for prior date intervals by Qaspec
In cells d7:D36 I have dates. In cells e7:E37 i have corresponding point values. I can use sumproduct to provide a value for the last month from today. I'd...
January 25th, 2005 02:49 AM
by Qaspec Go to last post
1 89
Weekend days other than Sat Sun by rkk
I need one more argument in Networkdays function after Startdate and Enddate, weekend day or days in form of 1,2,3,4,5,6,7 before holdays Any solution Thanx
(Multi-page thread 1 2)
January 25th, 2005 03:31 AM
by Myrna Larson Go to last post
15 214
CONVERT HEXADECIMAL CELL TO DECIMAL NUMBER by JAY
I USED THE HELP AND THE EXAMPLE BUT IT DIDN'T WORK, ANY HELP??? THE EXAMPLE IS GOOD IF I WANT TO PUT ONE NUMBER BUT NOT A CELL. I'M USEING OFFICE 2003
January 25th, 2005 03:45 AM
by Harlan Grove Go to last post
4 243
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 04:15 AM
by Roland Go to last post
1 222
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 04:29 AM
by Karl K Go to last post
4 140
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 04:45 AM
by Peo Sjoblom Go to last post
1 197
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 04:49 AM
by Max Go to last post
5 127
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 05:15 AM
by Biff Go to last post
1 108
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 08:11 AM
by prakash Go to last post
3 266
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 01:04 PM
by Bob Phillips Go to last post
1 382
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 03:02 PM
by JulieD Go to last post
3 291
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 03:05 PM
by Bob Phillips Go to last post
1 165
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 03:34 PM
by JulieD Go to last post
1 87
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 03:51 PM
by Linda G Go to last post
2 126
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 06:22 PM
by Harlan Grove Go to last post
5 165
how to use vlookup formula by kirky
example of a vlookup formula
January 25th, 2005 06:23 PM
by Peo Sjoblom Go to last post
2 149
Post New Thread


Display Options
Showing threads 10161 to 10180 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 11:15 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.