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
excel formula by Angie
Does anyone have an excel formula for working out a loan that has a balloon payment at the end?
April 2nd, 2005 04:55 PM
by bpeltzer Go to last post
1 70
How do I get excel to carry over info from one cell to another? by Angie
Ho do I get excel to carry over information from one cell to another one at the end of the month?
February 7th, 2008 05:19 PM
by Bernard Liengme Go to last post
1 126
FORMULA NEEDED by Angie
IF Q1 CONTAINS THE WORD "OK", I NEED THE CELL TO READ "YES" iS THERE ANYWHERE I CAN GO TO GET A BASIC HOW TO FOR CONSTRUCTING FORMULAS? iF i JUST HAD A LIST...
(Multi-page thread 1 2)
November 3rd, 2008 11:05 PM
by Pete_UK Go to last post
13 113
Vlookup when have 2 or more criteria to meet by Angie
I have a huge database with the sales of different product lines and regions and I need to extract the key lines by region for the corresponding period....
May 15th, 2008 10:15 PM
by Angie Go to last post
5 103
Sumproduct with If by Angie
I hope someone can help me. How can I sum the products of columns A and B, but only if the value in column C meets a certain criteria (like = 51)?
(Multi-page thread 1 2)
July 16th, 2008 09:42 PM
by Marcelo Go to last post
17 82
Timesheets by Angie
Im really hoping someone can help me on this. I have created a timesheet that records hours worked no problem. But with also have flexi time in our job so I...
October 3rd, 2008 09:19 PM
by Sean Timmons Go to last post
3 70
sum function by angie
i want to sum only filtered records in my worksheet. is that possible? with the sum function this does not work. could i use another function?
February 6th, 2009 09:21 PM
by Marcelo Go to last post
3 70
Hyperlink button is greyed out. by Angie
I am working in Excel 2003 and I have a worksheet that is a table of contents with links to PDF's and Word documents. I opened up the worksheet and now some...
September 3rd, 2009 02:45 PM
by Shane Devenshire[_3_] Go to last post
1 81
Excel worksheets won't all print by angie
I have an inventory that starts with a summary page and is followed up by the individual inventory types. I have always been able to print all the...
January 6th, 2010 06:29 AM
by ryguy7272 Go to last post
1 170
Unsorting after save by Angie
My co-worker sorted the "client #" column, without sorting the rest of the worksheet; then freaked and saved it. Without having to re-enter all of our...
November 8th, 2007 09:26 PM
by ilia Go to last post
5 70
Macro Help by Angie
Can anyone please help with writing a macro to check the following: If sheet1!a4:af4 sheet2!a4:af4 then msgbox("error") Thanks
June 9th, 2007 03:21 AM
by Stan Brown Go to last post
2 63
Equal to or less than formula by Angie
I have filter media that I need to order every week and some filter medias I have too much of. I need a formula that can tell me the exact date I need...
October 10th, 2005 10:58 PM
by Bob Phillips Go to last post
3 112
Active windows "overlapping' by angie
I would like to have all my active window shown separately instead overlap in one active window ?Any clue?thanks
October 24th, 2005 04:00 PM
by Vacation's Over Go to last post
1 63
lock only one cell by angie
I'm trying to lock only one cell by first unlocking the entire sheet, then locking only the cell, and then protecting the worksheet. However, when I do...
July 21st, 2006 06:08 PM
by angie Go to last post
4 66
Formulas with multiple IFs by Angie
I have an excel file used to track specific personal information for a group of people who work for me. I have a column for date of birth and in a separate...
May 2nd, 2007 10:52 PM
by Ron Coderre Go to last post
3 66
Data Validation by Angie
Is there a way to copy data to a sheet and retain the data validation criteria for the cells in that sheet? When I copy the data into the sheet it overrides...
June 1st, 2007 03:13 PM
by Angie Go to last post
2 84
Writing IF Statement by Angie
Is there anyway to write an if statement for a range without identifing each cell? Ex: If cells A1:AA1 = "test","proceed to next sheet","stop". ...
June 5th, 2007 10:10 PM
by Angie Go to last post
4 59
Copy data from multiple sheets into new sheet by Angie
I would like to automatically feed data beginning with Row 4 from Sheet 1 and 2 into another sheet, but the number of rows may change each time. Any...
June 5th, 2007 10:53 PM
by Angie Go to last post
0 62
Consolidate multiple worksheets into new sheet by Angie
I would like to automatically copy data from 2 sheets into a new sheet. Row 4 will be the same in each sheet but the range may change. Any...
June 6th, 2007 03:43 PM
by Peo Sjoblom Go to last post
1 66
How do i use sumproduct if my lookup table is alpha or alpha num? by Angie
Can I use sumproduct formula if my table is as follows ? Yr End Rating Mid Yr Rating A B C D A same 1 down 2 down 3 down B 1 up same 1 down 2 down C 2...
January 23rd, 2010 03:07 AM
by David Biddulph Go to last post
1 136
Post New Thread


Display Options
Showing threads 4181 to 4200 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 08:36 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.