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
Add 2 days before and after birthdate by Sunflower
I have column of birthdates and need to have a date range showing 2 days before and after the Month and day (in current year) of birthdate. For...
April 8th, 2009 11:57 PM
by Sunflower Go to last post
4 73
Multiple selection drop down list by The Bon
I want my drop down list to allow selection of multiple items. How do I do that?
April 8th, 2009 11:53 PM
by ryguy7272 Go to last post
2 129
Rearranging irregular data to monthly format by [email protected]
Hi, I have a spreadsheet of meter readings for household utility usage (gas, electricity and water). The readings have been taken at irregular dates, which...
April 8th, 2009 09:55 PM
by [email protected] Go to last post
2 134
Seperate Name, Street Address & City, State Zip by anna f
Hello! I have thousands of entries in Excel where there is a First and Last Name, followed by a street address, City State and Zip all in one cell. I'd like...
April 8th, 2009 09:04 PM
by Ron Rosenfeld Go to last post
4 92
Conditional Indexing by Rob
I'm using the below Indexing w/ matching function to find entries that meet a criteria. But now I find that i have to take it one step further... I have to...
April 8th, 2009 08:45 PM
by Domenic[_2_] Go to last post
2 99
Comparing text and then adding numbers if the text matches by rotor11
Hello folks, I'm a very basic excel user. I'm trying to create a spread sheet for adding flight times. Here's how the table looks: Aircraft Type ...
April 8th, 2009 08:38 PM
by Gary''s Student Go to last post
2 53
AUTO HIGHLIGHT ONLY ROW WORKING IN by Tracy
IS THERE A WAY TO HAVE A AUTO HIGHLIGHT AS I'M WORKING IN A ROW...IF I MOVE TO NEXT ROW...THE HIGHTLIGHT FOLLOWS?
April 8th, 2009 08:31 PM
by Tracy Go to last post
2 123
April 8th, 2009 08:25 PM
by Susan Go to last post
1 81
formula to work in a 3-d reference with 2 work books by capt c
I originally had a sumif formula working with 2 work books however when i attempted to apply it to more than one sheet in the one work book it would not...
April 8th, 2009 08:04 PM
by Luke M Go to last post
1 45
How can I calculate equivalent annualized cost by CA_stateworker
I have the capital cost, interest rate, project lifetime and O&M costs - how can I calculate the equivalent annualized cost? -- stateworker
April 8th, 2009 08:00 PM
by CA_stateworker Go to last post
0 59
Add $1 to a long row of #'s by Par
I have 150 numbers in a row C22 to C172. How do I add $1 to all those numbers without creating a new row?
April 8th, 2009 07:36 PM
by David Biddulph Go to last post
3 55
Link format along with contents of another cell by Claudia
Say the formula in cell C1 is simply =A1. Is it possible to also link the format of cell A1 to cell C1 so that if A1 is filled red, C1 will also be filled...
April 8th, 2009 07:24 PM
by Sheeloo[_5_] Go to last post
1 53
How can I protect a sheet so the rows/columns can't be deleted? by Dani
I'm setting up a workbook for continual shared use. Several of the other users, rather than just deleting the data, highlight the row in question and delete...
April 8th, 2009 07:22 PM
by Luke M Go to last post
1 47
Can Excel 2007 copy and add worksheets based on population a cell by new user
I am trying to set up a global worksheet that would add a copy of a worksheet that exists in my workbook when I populate a certain cell in the global...
April 8th, 2009 07:21 PM
by new user Go to last post
0 54
Using IF to compare ranges by [email protected]
This seems like it should be a simple task, however, I have entered the following formula: =IF(A4:I4=K4:S4," ","CHECK") to compare a range of cells to another...
April 8th, 2009 06:47 PM
by T. Valko Go to last post
5 79
How to save a blank excell sheet by gloria J
to use each month to send data of hours volunteered to an organization that sent the blank to me
April 8th, 2009 06:46 PM
by Francis Go to last post
1 56
I do not want the letters and numbers on the border to show by MAGGIE F
how do I remove the numbers column and the letter row shown on the excel worksheet borders
April 8th, 2009 06:28 PM
by Sheeloo[_5_] Go to last post
2 51
Weighted Averages for Rankings by katie
I have a spreadsheet where we rank performance of 9 groups with 13 categories of items. I want to put certian weight on certian items. Is there a way to do...
April 8th, 2009 05:33 PM
by Bernie Deitrick Go to last post
1 72
Multi-Worksheet Sumproduct & Listing by Rob
I'm hoping someone would be able to help me solve a quandry of what I am trying to do. In Excel 2003 I have four worksheets; Worksheet 1 has unique values...
April 8th, 2009 05:28 PM
by Sheeloo[_5_] Go to last post
3 47
Vlookup with part of cell text by Madiya
I need to use vlookup but the problem is that my cell contains a bigger text string. For e.g. cell text is CL BW 205 I want to use vlookup with BW which will...
April 8th, 2009 05:25 PM
by Jarek Kujawa[_2_] Go to last post
3 64
Post New Thread


Display Options
Showing threads 12361 to 12380 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 12:26 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.