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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
2007 excel autofilter back to 2003 autofilter? by jonnybrovo815
Is there anyway to get the 2003 autofilter functionality to work in excel 2007?
April 19th, 2010 08:11 PM
by jonnybrovo815 Go to last post
3 228
conditional formatting = or cell reference + 2 by Whitney
I would like to set up CF to change the font color to red if the value (b2:b7) is = or greater than the cell reference (b:8)+2. What is the formula? Ex. only...
April 19th, 2010 08:10 PM
by David Biddulph Go to last post
2 259
Why do I get two different paste special screens? by NewToExcel
Sometimes I get the paste special where I can select 'Value'. Other times I get a paste special that only gives me a list of types of files. What causes...
April 19th, 2010 07:27 PM
by NewToExcel[_2_] Go to last post
3 228
script or format to identify duplicate data by Jeremy
Is there a way I can write a script or conditional format to identify duplicate data. The data can be marked by highlight if need be. Ex Since A1 and A3...
April 19th, 2010 07:25 PM
by Bernard Liengme Go to last post
2 267
Blackberry and Excel by Jason D. Miller[_2_]
I have an excel workbook with multiple sheets - when I open it on my blackberry it opens the first sheet not the last. Is there a way to set up the workbook...
April 19th, 2010 07:22 PM
by Jason D. Miller[_2_] Go to last post
0 190
Sorting by Content by Father John
Hi I have a spreadsheet with numerous addresses in col. A 1-999 15 Smith Street Jonestown 21 George Street Blacktown etc. In col B. 1-166 I have the name of...
April 19th, 2010 07:15 PM
by NewToExcel[_2_] Go to last post
5 191
"Blank" cells showing unwanted data by Ed O'Brien
I inherited a workbook for energy usage in which the formula below was entered weekly as each week's readings were entered. Rather than do this each week I...
April 19th, 2010 06:55 PM
by Ed O'Brien Go to last post
4 177
Creating a value from a variable result by Darren
To start with I'll explain how my sheet is set up: Cells W40:W45 contain values of 40 through to 45 These are levels gained by an individual. Cells X40:X45...
April 19th, 2010 06:43 PM
by Darren Go to last post
1 203
Key Board shortcut to Status bar by Radhakant Panigrahi
Hi, can anybody help in getting know the key board short cut for Status Bar in Excel from where we know the count,max min, avg or sum of the...
April 19th, 2010 06:42 PM
by Héctor Miguel Go to last post
1 298
Offset/Index/Match ... or something? by Ken
Excel2003 ... WS1 ... contains list of all PN/Ops & Cols of other data ... WS1 ... Range A2:A10000 ... contains record count (1 thru 9,999) WS1 ... Range...
April 19th, 2010 06:31 PM
by Ken Go to last post
3 190
Displaying entire row by Chris
Hi, I would like to display an entire row based on a category selection. I´ve been trying to do this using PivotTables with no success. For example: East |...
April 19th, 2010 06:19 PM
by Chris Go to last post
2 189
2007 excel autofilter change back to 2003? by jonnybrovo815
Is it possible to change the autofilter in excel 2007 back to the way excel 2003 worked?
April 19th, 2010 05:53 PM
by Dave Peterson Go to last post
1 244
2007 excel autofilter change back to 2003 autofilter? by jonnybrovo815
Is it possible to change the 2007 autofilter back to like the 2003 autofilter worked?
April 19th, 2010 05:53 PM
by Dave Peterson Go to last post
1 238
Flashing RED before renewal date by vinu
Hi, I have some vehicle data that we update time to time. The below is an eg from the data Coolum no Heading ...
April 19th, 2010 05:37 PM
by vinu Go to last post
3 258
2007 Find_Replace - default on workbook? by faye
I know it's possible to do find and replace on a workbook by selecting "workbook" in the "within" drop-down in the find dialogue box. Is it possible to set...
April 19th, 2010 05:34 PM
by faye Go to last post
0 163
replace a negative result with a zero? by Pam2277
I have my formula entered but need it to return a zero if the result is negative. Any help is greatly appreciated. -- Pam
April 19th, 2010 05:33 PM
by Eduardo Go to last post
2 171
Change Default Auto-Fill-In month by scootr
If I format a cell as a date mm/dd/yy; If I only type in the month and date, "4/15" ,excel will automatically fill in the the current year, so the cell will...
April 19th, 2010 05:07 PM
by scootr Go to last post
5 221
Using Conditional Formatting to Pass/Fail by mrsatroy
I want to use conditional formatting to return a pass fail number based on a numeric value. However the number has to fall between 2 values. i.e A product...
April 19th, 2010 05:05 PM
by Michael_R Go to last post
2 227
Excel 2007 Saving Issue by MartekMIS
After the April Office 2007 updates, Excel 2007 is unable to save a spreadsheet to a Windows NT 4.0 Server's shared folder. Has anyone else come across this...
April 19th, 2010 04:45 PM
by MartekMIS Go to last post
1 207
Copying data from one workbook to another dependent on user select by sarahphonics
I am inexperienced with Visual Basic. I have a table in a workbook (wkbook1) which has a table similar to the following A B ...
April 19th, 2010 04:37 PM
by Pete_UK Go to last post
1 190
Post New Thread


Display Options
Showing threads 2101 to 2120 of 139764
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 01:23 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.