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
copy drag financial years by Ben
Hi i use financial years a lot and was wondering if there was a simple way to copy, paste/drag the years down a column so they expand? For example when i...
March 8th, 2010 08:26 AM
by Ed Ferrero[_3_] Go to last post
4 200
IF Function with Dates by Bagia
Hello, I hope someone can help me. I would like to create an IF function for dates in my worksheet. I have a Start Date column and End Date column. If the...
March 8th, 2010 06:45 AM
by Vijay Go to last post
9 154
cell reference by Peter
I have several sheets in a work book that need a range of cells deleted before inputting more data. The range to delete is A15 to D540. Then I need it to go...
March 8th, 2010 06:12 AM
by Jacob Skaria Go to last post
2 154
Data to another sheet by nandu1256
I have a table for marks of students. I have their ranking in the last col. In the next sheet I have another table in which I want the names of the first...
March 8th, 2010 06:02 AM
by Jacob Skaria Go to last post
1 111
Vacation Tracking formula by Rehab brain
I am trying get my formula for hours accured in a vacation tracker spreadsheet to show up as 60 minutes in an hour instead of 100...
March 8th, 2010 05:51 AM
by Russell Dawson[_2_] Go to last post
2 121
how to count my paydays before the due-date of a bill? by Judoman
I'm trying to make up a budget for my family. I'd like to be able to enter in the amount of an upcoming bill (a1), the due-date of an upcoming bill (b1), then...
(Multi-page thread 1 2)
March 8th, 2010 05:36 AM
by Fred Smith[_4_] Go to last post
11 215
#DIV/O! by painter50
I get this #DIV/O! when I divide two cell that both total 0. These cell will not always be used in the spreadsheet. Is there any way to show the total of...
March 8th, 2010 05:18 AM
by T. Valko Go to last post
5 140
Please help by cccc[_2_]
I am really sorry I have left msg here a week ago but I can not find it now. I found out what I need to do. Here is example A B C ...
March 8th, 2010 05:00 AM
by cccc[_2_] Go to last post
2 95
vlookup 3 sheets by Ben
Hi, I have 3 worksheets and want to combine a vlookup to find the sum of the unique criteria. I can get it to work with 2 spreadsheets but not 3. The...
March 8th, 2010 04:06 AM
by T. Valko Go to last post
1 125
Looking up name with 2 criteria by jtfalk
A B C D E First x 5 second...
March 7th, 2010 09:09 PM
by Mike H Go to last post
5 117
Sum value between two dates and copy to new cell by dave
Hi Guys, Thanks for all the previous helps and guidance on excel sheet and im looking forward for new assistants. i've various dates in column A and values in...
March 7th, 2010 08:47 PM
by dave Go to last post
6 102
vlookup multiple data by Art
Is it possible to have a cell contain two pieces of informaton (e.g., A1 = "Me, You"), a vlookup statement to look for each pece of informaton in that cell...
(Multi-page thread 1 2)
March 7th, 2010 07:56 PM
by Herbert Seidenberg Go to last post
11 189
Matching function or no match by Donna[_5_]
I am using this formula to compare 2 list to see which numbers are not included in both column A and Col C. The formula I am using below pulls out the ones...
March 7th, 2010 07:14 PM
by T. Valko Go to last post
3 124
SUM all Instances Q by Seanie
How could I achieve the following via formula I want to add up all the instances that certain numbers appear in Col B with their corresponding values in COL D...
(Multi-page thread 1 2)
March 7th, 2010 03:45 PM
by Dave Peterson Go to last post
15 200
What does " mean in excel by Jane
When working in excel and doing my labs, I am often told to use " " in my formulas but I don't know what " " stand for and the ! is also used, can someone...
March 7th, 2010 01:58 PM
by JLatham Go to last post
5 123
Basing math on duplicate entries in a formula by Karl
Okay, what I want is semi complicated, but should be simple. I have two excel sheets, one has raw data on it, let's say its an inventory sheet with Widget A...
March 7th, 2010 01:52 PM
by JLatham Go to last post
1 141
protection indicator by nader
Hi I write two question a bout this but no answer pleas, if possible I want a function that if worksheet protected write a text in a cell like "protected" if...
March 7th, 2010 01:40 PM
by Satti Charvak Go to last post
1 105
Calendar Formatting Based Upon Multple Date Ranges by Garnet
Hi there, what I am after is simple enough in nature, but seems to be difficult to create. Basically I work on a rotational job. Usually it is 4 weeks at...
March 7th, 2010 10:38 AM
by Russell Dawson[_2_] Go to last post
1 118
How do I turn off automatic date function in XL? by Darin
"Duke Carey" wrote: Should be a simple matter of changing the cells' format from Date to Number Select the cell(s) giving you trouble, press Ctrl-1 or...
March 7th, 2010 07:23 AM
by Fred Smith[_4_] Go to last post
1 98
Sumproduct and dynamic data by jtfalk
Good afternoon, I have an Excel 2007 workbook that I am having issues with. I have set up a dynamic graph that allows me to put in a start and finish date...
March 7th, 2010 03:31 AM
by T. Valko Go to last post
1 111
Post New Thread


Display Options
Showing threads 2321 to 2340 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:12 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.