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
Unprotect 2003 excel files when opening in Excel 2007 by Mayumdwl
I opened an Excel file created in Excel 2003 version in Excel 2007 the cells were protected and asking for a password to change, which I never locked with a...
April 21st, 2009 12:31 AM
by PJFry Go to last post
1 108
Unprotect a worksheet by Mayumdwl
The file I have opened was Excel 2003 version and when I open it in Excel 2007 the sheet is protected. Can you please advice how to unprotect it?
April 21st, 2009 12:30 AM
by PJFry Go to last post
1 105
Return filtered values into report worksheet based on filtered valueon the data worksheet by dicko1
I have two worksheet, one with data and one that is a report card. I would like to be able to filter the data and have the report worksheet show the results....
April 21st, 2009 12:27 AM
by Debra Dalgleish Go to last post
1 120
"Global" change Pivot Value field settings by watkincm
Other than a macro, is there a simple way to change the value field settings for an entire pivot table at once? I want to flip the report from sum to...
April 21st, 2009 12:07 AM
by Debra Dalgleish Go to last post
1 128
Step up or Down payments by chuck
How do i set up step-down and step-up lease payments in excel?
April 21st, 2009 12:05 AM
by L. Howard Kittle Go to last post
1 222
Another IF statement question by Valerie
Hello, How can I make my IF statement say "=IF(C4=B2+30,1,2)" and C4 is a fixed date and B2 is the system date (=TODAY() ). I want to add a statement that...
April 21st, 2009 12:01 AM
by Valerie Go to last post
1 96
Concatenate N cells (where N is a worksheet value) by ker_01
I have a list that includes many-to-one relationships. I need to turn this into a one-to-one relationship by concatenating the values of each of the...
April 20th, 2009 11:55 PM
by MyVeryOwnSelf[_2_] Go to last post
3 117
perpetual inventory - stock level - math flow?? by tcek
I am developing an excel spreadsheet that tell you the current inventory of an item. The inventory count is dependent on how many we receive from an order,...
April 20th, 2009 11:28 PM
by MyVeryOwnSelf[_2_] Go to last post
1 91
Mulitple value lookup by kritter286
Hello I am having trouble returning some looked up data. I have several worksheets that I want to pull data from one "User Input" sheet. I am running into...
April 20th, 2009 10:16 PM
by Roger Govier[_3_] Go to last post
5 86
Conditional formatting multiple cells from one cell to another by Loadmaster
Hi there, I am looking for a conditional formatting formula so that if C2 or C4 or C6 or C8 or C12 = $AK$2 to format cell C4 blue AND if C3 or C5 or C7 or...
April 20th, 2009 10:04 PM
by Loadmaster Go to last post
3 120
Finding an item in a list & returning a specific value by SBW
Is there a function I can use to .... - Check if Sheet 1 L1 value is listed anywhere in Sheet 2 Col A. If true, then return the corresponding value from...
April 20th, 2009 09:54 PM
by SBW Go to last post
7 58
Auto Correct Option by AlwaysQuestions
In Word 2007, I was able to add the Auto Correct option to the Quick Access toolbar but not in Excel. Can it be done in Excel? Any assistance is greatly...
April 20th, 2009 09:16 PM
by AlwaysQuestions Go to last post
0 72
Hide Rows If Condition True by wilbursj
Hi Is it possible to auto-hide a row if a condition is met. Ie If the value of a specifc cell in that row is 0, i do not want the row to show, so either...
April 20th, 2009 08:09 PM
by Gord Dibben Go to last post
2 63
Excel formula question by Bill638
I am creating an audit tool that I want to be able to automatically populate a report with recommendations. I have a Yes/No/NA cell in my checklist worksheet...
April 20th, 2009 07:44 PM
by Bill638 Go to last post
5 57
EXCEL:HOW DO I CHANGE COLOR IN CELL BY TYPING IN ANOTHER WORD? by PRECIOUS
I HAVE A SPREADSHEET THAT I HAVE IN A CELL 934T01. I WOULD LIKE TO HAVE THE BACKGROUND START AS RED AND THEN THEY TYE 934T01 AGAIN AND IT WILL CHANGE TO...
April 20th, 2009 07:42 PM
by CLR Go to last post
2 251
DCOUNT Help by Rob B.
I am using the output from a combobox as a variable in a database formula (DCOUNT). The variable is a name. My problem occurs when one name is used that is...
April 20th, 2009 06:48 PM
by Rob B. Go to last post
2 68
IF function using two worksheets and various data by nidabland
I have one worksheet that has stock numbers in one row and account numbers in one column. On my other worksheet, I have account and stock and prices in...
April 20th, 2009 06:28 PM
by nidabland Go to last post
2 83
I've forgot password in my worksheet,how to unprotect the shee by Ny bruker
Thanks a lot : ) "JE McGimpsey" wrote: Check out http://www.mcgimpsey.com/excel/removepwords.html
April 20th, 2009 06:22 PM
by Ny bruker Go to last post
0 84
how do i rearrange columns in a work sheet by JakeMc
I have a spresdsheet filled in with titles of the columns and information within each column. How can I rearrange the columns? for instance Column A is...
April 20th, 2009 06:15 PM
by Rick Rothstein[_2_] Go to last post
5 112
Value function by Dave
Hi all, XL2003. I have a fraction, say 200/7, in A1. In B1, I have: =Value(200/7), which returns the right answer. In C1, I have: =Value(A1), which returns a...
April 20th, 2009 05:54 PM
by T. Valko Go to last post
7 60
Post New Thread


Display Options
Showing threads 11961 to 11980 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.