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
Fix EXACT function so it always compares in the same row. by soilcon1
I am using the EXACT function in column B to compare if information in column A is the same as column C on a spreadsheet. If it is not, I am inserting cells...
January 7th, 2008 05:45 PM
by soilcon1 Go to last post
5 75
Incorporating the first 40 out of 250 rows in column values by Hans Antlov
I have a stock ranking system based on Excel, Every week I download 250 daily quotes from some 300 funds into one long row. I then have simple formulas in...
January 7th, 2008 05:19 PM
by ShaneDevenshire Go to last post
3 95
Excel data sort by Stacyb
I need to sort data alphabetically on a speadsheet and also add new data from another excel spreadsheet. The problem is the column to sort is 4 lines (column...
January 7th, 2008 04:37 PM
by Jim Cone Go to last post
1 116
Conditional statements by james[_4_]
I have three cells a1, b1 and c1 that should indicate green, yellow and red respectively when values and range of values are given in say cell e1. The values...
January 7th, 2008 04:07 PM
by james[_4_] Go to last post
9 169
Highlight automatically a specific cell by Frances Holden
i am working on a spreadsheet and need some help, it's hard to explain what i want but i'll try my best, here goes! I have a sheet and on it i have several...
January 7th, 2008 04:05 PM
by Don Guillett Go to last post
1 58
Formula by james[_4_]
I am quiet new with excel. Please can anyone help me with writing a formular for a cell that contains a range of numbers. I the cell to for example indicate...
January 7th, 2008 03:44 PM
by Gav123 Go to last post
7 82
Trying to get total mileage for a specific month by big_chief_hutch[_2_]
I have a spreadsheet which shows the date and mileage of business journeys. I am trying to create a function that will for each month pick out the mileages...
January 7th, 2008 03:29 PM
by Ron Coderre Go to last post
5 75
If Statements & Combining Cells by Hark2k
I am trying to write a statement where if the values in column A equal a certain value then it will combine the corresponding data in column B, preferably...
January 7th, 2008 02:59 PM
by Gary''s Student Go to last post
2 58
Excel Formula Error by Griffey5
What is wrong with this formula? =SUM(IF(('Batch Log'!A2:A2001="February")*('Batch Log'!G2:G2001="530204-03")*('Batch Log'!H2:H2001="3000272.02"),'Batch...
(Multi-page thread 1 2)
January 7th, 2008 11:00 AM
by David Biddulph Go to last post
15 160
worksheet to worksheet subtotals by bernieb
I can't seem to figure out how to carry subtotals from a specific cell in each worksheet over to a grandtotal cell on the last worksheet. ie. cell O33 on...
January 7th, 2008 10:55 AM
by David Biddulph Go to last post
4 78
adding subtotals from several worksheets by bernieb
I am trying to figure out how to create a "Grand Total" on my final worksheet containing the sum of subtotals from several previous worksheets. Such as, cell...
January 7th, 2008 10:52 AM
by David Biddulph Go to last post
2 77
can i avoid repeating rows when adding calculated item in pivot ta by sophie
I need to add a calculated item for a pivot table I tried to add a caculated item to field F3. Formula1 = C + H (see below) The resulting PT has some...
January 7th, 2008 08:50 AM
by sophie Go to last post
4 103
Array extended formula - sort by yshridhar
Hello everybody The following is the debtors list Invoice Debtor Amt Date Age T001 DEF 140 11/09/2007 118 T002 BQE 0 25/12/2007 0 T003 ABC ...
January 7th, 2008 08:45 AM
by yshridhar Go to last post
3 84
Setting up Email Reminders by millpa00
Hi. I have no idea if this can be done...but I created a schedule for our team. Each person has a user id. They use drop-down lists to add their name to a...
January 7th, 2008 05:06 AM
by FSt1 Go to last post
1 51
Help on data style issues.... by golfdunwoody
Help please; when I change a data style in one cell, it changes the data type in all cells. As an example if I change one cell to a date, all the cells...
January 7th, 2008 01:52 AM
by golfdunwoody Go to last post
2 63
If Formula question Excel 2003 by Tom
What is the proper syntax in Excel 2003 for the following: If cells A6:A20="Tom" and cells B6:B20="a" then count the number of "a" in cells B6:B20. Thanks!
January 7th, 2008 01:38 AM
by BIG D Go to last post
4 82
Annuities by Chip
I need help to make a function in Excel to do an annuity table for 218 month showing each month the monthly payment divided in 2 figures: the down payment...
January 7th, 2008 01:37 AM
by joeu2004 Go to last post
3 55
Nest SumIf by [email protected]
Hello. I am trying to use a formula that will sum a colum if the criteria in one column equals a cell and the criteria in another column equals another...
January 7th, 2008 01:25 AM
by [email protected] Go to last post
3 70
Stopping reference following when rows are inserted. by dim
Hi folks, I have the following cell reference in Book 2: ='C:\Program Files\systems\My Program\Data1\Sheet1'!$A$2 I have a macro that automatically enters...
January 7th, 2008 01:01 AM
by dim Go to last post
3 83
"='sheet 1'!D4" auto fill sheet to sheet ='sheet 2'!D4 by mistewalker
how do auto fill formula ='sheet 1'!D4 to sheet 2 ='sheet 2'!D4 with out change the formula maunually I want to make one sheet with the formula and add sheets...
January 7th, 2008 12:36 AM
by Gord Dibben Go to last post
5 67
Post New Thread


Display Options
Showing threads 30041 to 30060 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 06:03 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.