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
Percntages by Adam
Hey guys, i want to know if there is a way to do something like this I have a columns of numbers, and i want to display a percentage behind the value in the...
April 14th, 2009 11:38 PM
by Gord Dibben Go to last post
9 183
Need Function Help by TechieGirl
Hi, I have looked up the search, vlookup, insa and if functions and I am still a little lost. I need a funtion that will look up a value or cell in a column...
April 14th, 2009 10:37 PM
by T. Valko Go to last post
8 208
I have lost the soft, blue borders of some cells. by Gerald
I have lost the border lines in a portion of one column in one of my worksheets--66 adjacent rows (cells) in one column. I have done a--- office buttonexcel...
April 14th, 2009 10:07 PM
by Gerald Go to last post
6 136
Increase Values by Percentage by Cynthia
Hi, I need to know if there is a formula to increase values by a percentage. 2 columns with different values all needing increased by 3%. Any help would be...
April 14th, 2009 09:48 PM
by Mike H Go to last post
1 92
Rolling 12 Spreadsheet by Miss Karen
I have a spreadsheet with about 500 rows on it and it calculates in different fields down the line. It has the 12 monthly columns at the top and every month...
April 14th, 2009 09:33 PM
by Miss Karen Go to last post
6 80
Displaying "0" Values by Ant
I am trying to type a series of numbers with "0"s. ex. 000058745. When I do this excel kicks out all of the zeros. 58745. I need the zeroes to be displayed...
April 14th, 2009 09:10 PM
by David Biddulph Go to last post
4 75
I need help desperately !! I need a formula that will allow me to match cells... by phillip warren
I need a formula that will allow me to match 2 cells from 2 different columns on one sheet to two columns on another sheet. Then if they match I need the...
April 14th, 2009 07:31 PM
by Eduardo Go to last post
2 125
Editing Queries In Excel 2007 by T Stephens[_2_]
I have several queries in an Excel 2007 workbook pulling data from Access. I need to modify the properties of the queries, but when attempting to do so with...
April 14th, 2009 07:08 PM
by BIAKathy Go to last post
1 111
Forcasting question by Donna
Hi: I have a worksheet to track payments from several offices I want to forcast what we would collect by the end of the month as we receive payments. I...
April 14th, 2009 06:47 PM
by Donna Go to last post
4 78
Cell not available when inputting formula by Lyn
I am trying to input a formula in Cell B2; I am in that cell and input the equals sign and want to click on cell A2, but it's like B2 has expanded and won't...
April 14th, 2009 06:38 PM
by Lyn Go to last post
2 105
How to discover the difference by Mike Blakeley
I am creating a worksheet and I can't quite get the formula to work. I want to compare two numbers and see if they are equal to, less than or greater than a...
April 14th, 2009 06:15 PM
by Don Guillett Go to last post
6 71
Identify which column 'Large' finds a match in by ker_01
I have a grid that shows categories along the top, and people down the left. For each person, the categories may show zero time, or increments up to 100. I...
April 14th, 2009 06:07 PM
by T. Valko Go to last post
6 100
Offset function gives different answer in columns v Rows by Jolly
I have a set of numbers by year and am trying to get the NPV on forward basis. I used the Offset function to allow for NPV on different dates. However, the...
April 14th, 2009 05:45 PM
by Jolly Go to last post
6 68
Remove e-mail address from general text field. by InsomniacFolder
Hello, I have a column containing free text data dumped from a CRM program. Each cell in the column contains an e-mail address at some point in it. I want to...
April 14th, 2009 05:19 PM
by InsomniacFolder Go to last post
2 85
Excel Charts with Data Tables by Joe R @ AA[_2_]
Need your help! I'm creating charts to plot YOY and MTD comparisons of data. My charts' data tables keep populating future months with zeroes even though the...
April 14th, 2009 05:04 PM
by Gord Dibben Go to last post
1 84
Password protect sheet from viewing by Enrique
I'm using Excel 2007 I have a team of sales individuals and have created a workbook which contains a worksheet for each individual. When they open it I only...
April 14th, 2009 04:52 PM
by Gord Dibben Go to last post
4 95
Calculate running average but not count a zero. by marsjune68
A B C D E F ROW1 DATE SCORE MATH AVERAGE ROW2 1 1/2/2009 0 0 0 ROW3 2 1/2/2009 75 75 75 ROW4 3 1/2/2009 135 213 107 ROW5 4 1/2/2009 99 312 104 ROW6 5...
April 14th, 2009 04:49 PM
by marsjune68 Go to last post
3 114
Searching on 2 columns and putting result in third column. by RobFJ[_3_]
Columns B and C just contain either Yes, No. Depending on the combination I want to put the text result in column C as follows. A B ...
April 14th, 2009 04:32 PM
by Luke M Go to last post
2 139
IF Function based on a set of numbers? by Scott A
I am trying to figure out how to do an IF function based on a set of numbers. To be detailed, in column B I am inputing apartment unit numbers...
(Multi-page thread 1 2)
April 14th, 2009 04:31 PM
by Rick Rothstein[_2_] Go to last post
11 125
Countifs of prior years monthly data based on MTD today by Joe R @ AA
How can I get a formula to calculate prior years data for a month to date, month against month comparison with the current year? I'm using the COUNTIFS...
April 14th, 2009 04:09 PM
by Joe R @ AA[_2_] Go to last post
3 101
Post New Thread


Display Options
Showing threads 12161 to 12180 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 06:54 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.