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
Conditional Format by Randy
I'm wanting to shade a cell if 2 conditions are true. They problem I am having is that one of the cells uses the VLOOKUP function. I can get the cell to...
April 14th, 2009 03:51 PM
by Randy Go to last post
4 85
Drop Functions and Sorting by dicko1
I am creating a report card for work performance. Right now I have several worksheets that contain the different data that I combine onto the report card...
April 14th, 2009 03:31 PM
by [email protected] Go to last post
2 112
A conditional Sum & Count by keerthyV
Hi, I have a query, My data : Days Type Sunday Lunch saturday Dinner sunday Dinner
April 14th, 2009 02:48 PM
by Ivan Go to last post
3 85
Sum with New Cell Reference by DOUG
I am designing a macro to link to a cell reference and to move the reference two cells to the right in the following month. So, this month I the formula...
April 14th, 2009 12:06 PM
by Jacob Skaria Go to last post
2 123
lookup function help by alberson
I am having a problem with the formula below. I have a chart of certifications listed by date which are due annually. I have a column dedicated to list the...
April 14th, 2009 08:56 AM
by alberson Go to last post
2 86
Protect an excel spreadsheet by NZuser
Hello, Can someone pls tell me what the most secure way to protect a worksheet is? :-)
April 14th, 2009 08:45 AM
by NZuser Go to last post
3 77
separate lastname from firstname by enrico via OfficeKB.com
if lastname and firstname is in one column, can you separate it into two columns? -- Message posted via http://www.officekb.com
April 14th, 2009 06:56 AM
by Kassie Go to last post
3 72
help with data labels by struggling student
I am new to using excel charts. i want to change the layout of the data labels in a pie chart to show a percentage. I click on chart tools, data layout,...
April 14th, 2009 06:42 AM
by struggling student Go to last post
0 85
Area by jai
Excel 2007 has a function Area I am not getting for which purpose this function has been created. I have tried to find learning material from internet also...
April 14th, 2009 06:40 AM
by Rick Rothstein[_2_] Go to last post
1 88
SUMPRODUCT by M&M[_3_]
The Min column is the calculation of MIN(ABS(A1:C1)) by row. Now I need to have a count by each column that the value is equal to the Min column. I tried...
April 14th, 2009 06:31 AM
by T. Valko Go to last post
3 68
SUMIF formula using data from another file by Hugh
I am attempting to use a SUMIF formula that uses a criteria range and sum range in another file. The formula works fine as long as both files. When the...
April 14th, 2009 05:02 AM
by Tom Hutchins Go to last post
2 71
conditional formatting expiry dates by mooty
Hi All, I am trying to conditional format a spreadsheet that i have licence expiry dates but want to flag these 30 days prior to expiry but also want the...
April 14th, 2009 04:24 AM
by Fred Smith[_4_] Go to last post
1 71
Excel Functions by LNS
hi, i have a worksheet as similar to the one below and i am trying to calculate the minimum function and retrieve the corresponding column...
April 14th, 2009 04:20 AM
by T. Valko Go to last post
7 67
need formula help by jjmore
my spreadsheet looks something like this: (i have about 12000 rows) A B C D date depth ...
April 14th, 2009 04:16 AM
by Jacob Skaria Go to last post
2 75
Combo boxes and drop down lists by Rosalie
I've added a combo box to a worksheet where I have some drop down lists so that I can change the size of the font and the number of lines in the box. I've...
April 14th, 2009 04:10 AM
by Rosalie Go to last post
0 80
IF by Susan
Hello, Having problem using the IF function with dates. If the date in cell A1 is from and including 4/1/2009 to 4/30/2209, the result in B1 should be...
April 14th, 2009 04:02 AM
by Rick Rothstein[_2_] Go to last post
4 61
definite integral by dmahn14
how to I enter a definite integral into a cell in Excel? I have a column of equations that i need to get the definite integral of.
April 14th, 2009 03:59 AM
by dmahn14 Go to last post
0 85
Using dropdown in protected sheet by veggies27
I am having trouble choosing items from a drop down list when my sheet is protected. In the same file I have certain areas where this is not a problem at...
April 14th, 2009 03:46 AM
by Dave Peterson Go to last post
2 73
Creating automated timeline by Ruki
Trying to create an automated time line for a process (eg process starts on a date, 5 days later step 2 happens, 3 days later step 3 happens, etc) but...
April 14th, 2009 02:52 AM
by Ruki Go to last post
0 82
April 14th, 2009 02:35 AM
by Tom Hutchins Go to last post
4 89
Post New Thread


Display Options
Showing threads 12181 to 12200 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:45 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.