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
Milenko Kindl r90er0w9ef by yuma[_2_]
NEW YORK - The economic crisis and raw politics threatened to derail the first presidential debate as John McCain challenged Barack Obama to delay Friday's...
September 25th, 2008 07:36 AM
by yuma[_2_] Go to last post
0 116
IF , match formula problems by treeroot
I have a worksheet that I am using on the first sheet "high priority" A3:A5764.. I have my master contact list. on the second sheet "bouncebacks"...
September 25th, 2008 06:33 AM
by Ashish Mathur[_2_] Go to last post
1 140
problem with number format with 2 decimals? by Brenda
I have an Excel 2007 spreadsheet for mileage & fuel gallons on the same worksheet. Mileage is formatted as a whole number. Fuel gallons I want formatted with...
September 25th, 2008 06:15 AM
by Ashish Mathur[_2_] Go to last post
5 207
Return an array based on a lookup by seanss
I need to return an array based on a vlookup for a match statement. sheet 1 Monday row1 9 10 11 12...
September 25th, 2008 06:15 AM
by seanss Go to last post
2 131
collate by bubbly_silk
How do I collate several spreadsheets into one worksheet?
September 25th, 2008 04:54 AM
by Ashish Mathur[_2_] Go to last post
2 146
multiple cell comparisons...nested if formulas? by KalliKay
I have three cells that may or may not have dates in them (all three could have dates, two could have dates or all three could have no dates: 1) Actual...
September 25th, 2008 04:53 AM
by Ashish Mathur[_2_] Go to last post
1 140
Choose and Match by Atif
Hi All, Site TV MP3 Cell Phone NY Margin ($) $338,101 $292,277 $377,098 Margin (%) 34% 29% 41% NJ Margin ($) ...
September 25th, 2008 02:08 AM
by ryguy7272 Go to last post
3 150
Why do Excel functions return the text and not run? by Bill
I am using Excel 2007. When I try a function in cell b2, like =upper(a2), it enters the function text ("=upper(a2)" and it does not return the uppercase...
September 25th, 2008 02:02 AM
by Peo Sjoblom Go to last post
1 134
Array Formula by Erin Searfoss
Can anyone tell what I'm doing wrong here? If (on another sheet) IDTest = $A$2:$A2, BegDateTest = $B$2:$B$2, and FinDateTest = $C$2:$C$2 the following...
September 25th, 2008 01:58 AM
by Erin Searfoss Go to last post
2 136
Cannot get the smart tags to work in Excel by [email protected]
Hey Guys, I'm using Excel 07 on Vista, off lately smart tags don't work anymore. I tried Excel /safe and smart tags work in the app safe mode. Can someone...
September 25th, 2008 01:22 AM
by [email protected] Go to last post
0 111
Sum from different worksheets by DSilvers
I am trying to take the numbers from worksheet AR and have it total in the worksheet YTD. It is not working for me... -- D~
September 25th, 2008 01:04 AM
by Pete_UK Go to last post
1 117
need some columns to auto add decimal pt & others to not - How to. by His child
I have a spreadsheet that in one column I enter a number that will not have decimal places. The next column are number with 2 decimal places. The 3rd...
September 25th, 2008 01:01 AM
by Bernie Deitrick Go to last post
2 122
How can I change NOW() to a date when combined with text? by djenk2
How can I get the NOW() to display a date and not a number? Cell is formated in date format. THANKS to the brain that figures this one out. ="^ ^ ^ 2008...
September 25th, 2008 12:47 AM
by Pete_UK Go to last post
7 332
Trying to avoid nested IFs by Alonso[_2_]
Here is a formula I'm...
September 25th, 2008 12:43 AM
by Pete_UK Go to last post
8 137
Inserting current date by pdaws
Hi, When cell b25 is populated by a macro, I would like for cell d25 to automatically enter the current date based on the population of cell b25. I would...
September 25th, 2008 12:37 AM
by Gord Dibben Go to last post
8 109
Signing Spreadsheets by Vercingetorix.XIII[_2_]
There used to be a way to put your name in Windows so that when a user clicked on Help and About your name and log was there, is there a way to that in Excel?
September 25th, 2008 12:24 AM
by Gord Dibben Go to last post
5 113
If cell equals a name then get data from column by JDB
I need to pull data from monthly spreadsheets that is a list of names and results. The names are not always in the same order. I need to collate the results...
September 25th, 2008 12:15 AM
by Gord Dibben Go to last post
2 123
Displaying and formatting data between tabs by Keith J.
I would like to display data on two tabs and have updates on one tab populate the other. Additionally, I would like to change the formatting on one tab if...
September 25th, 2008 12:11 AM
by Gord Dibben Go to last post
1 114
Locking a worksheet, but allowing user to add rows in a table by Ray Carter
I have been bustin my butt to find out how to allow a user to add rows (only) to a table on a locked worksheet. Can anyone help me out?
September 24th, 2008 11:51 PM
by Ray Carter Go to last post
2 129
I want to copy rows with values 0 to another worksheet automatica by Skeletor
I have a series of worksheets that contain different product lines. When I type in an amount in the "Quantity" column in each worksheet, I would like that...
September 24th, 2008 11:47 PM
by Gord Dibben Go to last post
4 120
Post New Thread


Display Options
Showing threads 19921 to 19940 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 10:30 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.