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
How do I remove the #div or N/A and make it 0 when using VLookup? by JeaneIsaac
I have a very large worksheet that I am using the following vlook up...
(Multi-page thread 1 2 3)
February 10th, 2010 06:15 PM
by Flcnmech Go to last post
27 482
Set "ALWAYS CREATE BACKUP" Option by Abradaxis
In Excel, I keep setting the "always create backup" in the "save as" toolsoptions menu, but it keeps on getting erased. How can I automatically produce and...
February 10th, 2010 05:43 PM
by Abradaxis Go to last post
5 175
How format SUMIF formula for matching date range and column value? by Kane
Here is my current SUMIF formula. How would I modify this to add the selection of a date range from the same data columns? Example, start date of 2/1 and...
February 10th, 2010 05:40 PM
by Fred Smith[_4_] Go to last post
4 161
Multiple lookup between two dates by Ales
Hi, I have a ratesheet in excel like e.g. Carrier FromDate ToDate Rate A 01.02.10. 28.02.10. 100 A 01.01.10. 14.01.10. 99 A ...
February 10th, 2010 05:32 PM
by Ales Go to last post
2 91
formula help by Soth
Hi- Issue: 211 310 410 569 Would like to accomplish: 2211
February 10th, 2010 05:26 PM
by Glenn[_6_] Go to last post
3 117
how do I convert date format yyyymmdd to mm/dd/yyyy by Datahead
how do I convert date format yyyymmdd to mmddyyy I have rows of dates displayed as yyyymmdd (ie 20100131) I want them displayed as regular dates (ie...
February 10th, 2010 05:14 PM
by Ms-Exl-Learner Go to last post
2 131
Custom views in Excel by Flipper
Is it possible to have a custom view for multiple worksheets with the same name within the same workbook? As an example, I have a workbook that has 10...
February 10th, 2010 05:07 PM
by Flipper Go to last post
0 125
How to count cells that are highlighted by conditional formatting by jngbutler35
How do I return a count of how many cells in a range are highlighted (via conditional formatting) without using VBA in Excel 2007?
February 10th, 2010 04:35 PM
by Pete_UK Go to last post
1 104
TransferSpreadsheet to colored fields by alex
TransferSpreadsheet to colored fields Hello, I have an MS Access file that transfers data to Excel using the TransferSpreadsheet method… It works fine, but...
February 10th, 2010 04:34 PM
by alex Go to last post
0 100
In excell 2003, increasing number of items shown in drop down list by Sekani
I am trying to increase the number of lines to be displayed in the drop down list, using MS office 2003, excell. I have read contributions to the question...
February 10th, 2010 03:44 PM
by Teethless mama Go to last post
1 116
Data Validation Lists by Sue
Thanks for the response. I am very new to all of the coding. I have some more questions related to my first posting. I have a "Lists" spreadsheet that has a...
February 10th, 2010 03:18 PM
by Sue Go to last post
0 82
Stock control question by Rocket
Although I have used Excel for years I have never had the need to use a complicated formula. I am trying to set up a stock control spreadsheet where multiple...
February 10th, 2010 10:21 AM
by FSt1 Go to last post
4 119
Button apperance by ndobbo
I am using ActiveX option buttons in my spreadsheet and the apperance of the buttons is pixelated and distorted. Is there a way to make the buttons look...
February 10th, 2010 09:28 AM
by Garreth Lombard Go to last post
1 101
auto highlighting x#of days prior to & after any given date by Moovysheek
I have a 2010 calendar on 1 8.5x11 pg. i want to be able to click on any given day and have the 15 days prior to & 30 days after automatically highlight. How...
February 10th, 2010 07:34 AM
by Moovysheek Go to last post
0 123
Conditional Formatting by Moovysheek
I have a 2010 calendar on 1 8.5x11 pg. i want to be able to click on any given day and have the 15 days prior to & 30 days after automatically highlight. How...
February 10th, 2010 07:18 AM
by Moovysheek Go to last post
0 85
how to vlookup of one cell by starting 2 digits of another cell? by Uday
how to vlookup of one cell by starting 2 digits of number in another cell?
February 10th, 2010 05:58 AM
by Fred Smith[_4_] Go to last post
1 140
SUMIFS by Kristin
Can SUMIFS be used with formulated cells? or does that formula only work with straight values in the cell?
February 10th, 2010 04:58 AM
by David Biddulph Go to last post
6 203
How do I find how many of a certain day are in a given month by Paris2459
I need to find out how many of a certain day are in a given month. Ex: I need to know how many Thursdays are in each month for a calendar year so I would need...
February 10th, 2010 03:43 AM
by T. Valko Go to last post
6 172
Calcs & Data Validation by Andrew
Looking for an easy way to complet the following. I imagine their must be a quick & easy method. Cell A5 has a drop down list which corresponds to a range on...
February 10th, 2010 02:56 AM
by T. Valko Go to last post
3 94
Find Last Item Entered in Row by Ron
Hi, I am hoping I can get some help on this. I have a spreadsheet that has an item # in column A, and has a place to enter prices for the next 52 weeks in...
February 10th, 2010 02:54 AM
by T. Valko Go to last post
4 150
Post New Thread


Display Options
Showing threads 3081 to 3100 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:16 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.