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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Replies Reverse Sort Order Views
How do I copy a formula with the cell increasing by increments? by Jaxboo
I would like to take a simple Sum formula such as Sum(b1:b6) and copy it into the next cell in an increment so the next cell (below) will read...
(Multi-page thread 1 2 3)
May 3rd, 2010 08:44 PM
by ecap Go to last post
22 511
Vlookup but with multiple results by ORLANDO VAZQUEZ
Thank you for your support. Can someone please help me with the following array? type of question. What formula can I use to return a list of results when...
(Multi-page thread 1 2 3)
February 24th, 2010 08:36 PM
by slf Go to last post
22 432
Active cell highlight by E
Hi, I would like to know if there was a way to have an active cell always in yellow or any color. Example: If the active cell is moved around, the active...
(Multi-page thread 1 2 3)
February 15th, 2008 10:40 PM
by Chip Pearson Go to last post
21 471
Adding top 10 numbers from 100 by Frustrated
How do I add the top 10 numbers out of 100 numbers that are not in a row or column but scattered throughout a spreadsheet. For instance, the first number...
(Multi-page thread 1 2 3)
July 21st, 2008 07:06 PM
by T. Valko Go to last post
21 244
one row won't calculate by Rick
I use a grade book which I downloaded from the Microsoft site. It works great, except when I had to add a new student. The grades do not calculate like in...
(Multi-page thread 1 2 3)
October 13th, 2008 11:49 PM
by Gord Dibben Go to last post
21 324
Dates into percentages by CelticCharmer
Hi, I was wondering if you could help me out. I train students and when a student completes an element of their course work I input a completed date into a...
(Multi-page thread 1 2 3)
February 5th, 2009 11:08 AM
by CelticCharmer Go to last post
21 198
Add Same in amount in whole Column by S1L1Y1
I have Office XP. In Excel I want to increase the price in the whole column by lets say 5% how do I do it? Sol
(Multi-page thread 1 2 3)
August 24th, 2009 11:38 PM
by Dave Peterson Go to last post
21 315
Workbook_BeforeClose by Ed Davis[_2_]
Posted in another news group but no response. I have a situation where I have 7 workbooks open at any given time. I have created macros that saves, backups...
(Multi-page thread 1 2 3)
September 26th, 2009 01:01 AM
by JLatham Go to last post
21 295
Searching alfanumaric cell contents and returning with a numaric v by ksean
Is there a way to use a formula to determine how many times an alphanumeric value is used in a column of cells. For example a column consisting of 300 cells...
(Multi-page thread 1 2 3)
October 29th, 2009 05:55 PM
by T. Valko Go to last post
21 354
Require input in a cell before saving file by Patrick Riley[_2_]
I want to require the user to enter his/her name in a cell (E59) before the user can save the file. I tried using Data Validation where I specified Text...
(Multi-page thread 1 2 3)
March 26th, 2008 03:47 PM
by Patrick Riley[_2_] Go to last post
21 308
Why doesn't INSTREV work for me? by dsimcox
I'm using INSTREV to retrieve the location of a character in a string by searching from the end of the string. When I type the following in the immediate...
(Multi-page thread 1 2 3)
February 21st, 2008 07:10 PM
by Jon Peltier Go to last post
21 210
Blank cells by Antonio
Hi all Have numbers on column D, that are placed there by using the following formula: =IF(B14=2,C14,0). This formula is copied down until the 400th row...
(Multi-page thread 1 2 3)
March 13th, 2008 06:58 PM
by Antonio Go to last post
21 179
apostrophes by teepee[_4_]
I have a formula with an apostrophe, but it's not a leading apostrophe. ='results.csv!$B1 I wrote it this way for reasons I won't bore you with, but there is...
(Multi-page thread 1 2 3)
February 14th, 2008 02:05 AM
by Dave Peterson Go to last post
21 154
1st and 2nd.... positions by gorro
assuming i want to arrange student positions, how do i get excel to automatically add say st, nd, rd, th, to 1st, 2nd, 3rd, and 4th positions? thaks for...
(Multi-page thread 1 2 3)
January 21st, 2008 07:35 AM
by T. Valko Go to last post
21 158
Convert test to date by GKW in GA
I have a cell, F5, that has 20071225 in it. I want to convert this to a date field that displays as 12/25/2007 When I use the function =DATEVALUE(F5) , I get...
(Multi-page thread 1 2 3)
December 13th, 2007 06:22 PM
by Ron Rosenfeld Go to last post
21 180
Why does "cannot shift objects off sheet" prevent row insertion? by Idaho old guy
I am unable to insert rows in an existing spreadheet and a new one I just initiated in a book with multiple sheets. What did I do to cause this and how do I...
(Multi-page thread 1 2 3)
August 19th, 2008 10:36 AM
by Jesper Audi Go to last post
21 333
find a number in a cell by Jambruins
In cell B239 I have the following text Carolina 3 at Pittsburgh 4 (SO) All of column B is like this except with different team names. I would like a formula...
(Multi-page thread 1 2 3)
October 23rd, 2007 05:36 AM
by Rick Rothstein \(MVP - VB\) Go to last post
21 205
Prevent Duplicate Records by Kenny
I have a spreadsheet Column A is the account number. I want to write a procedure that if the user enters the same account number in column a that already...
(Multi-page thread 1 2 3)
October 15th, 2007 01:56 PM
by Dave Peterson Go to last post
21 233
How do I use conditional formatting for an entire column? by Patti F
How can I format an entire column using conditional format? I keep getting an error message when I choose the column.
(Multi-page thread 1 2 3)
February 26th, 2010 06:36 PM
by vemory Go to last post
21 406
Help with tax formula for marginal tax rates by MZ
I am trying to make a single formula that will calculate a person's taxable income assuming the six different marginal tax rates that range from 10% to 35%,...
(Multi-page thread 1 2 3)
January 8th, 2010 03:02 PM
by Stefi Go to last post
21 259
Post New Thread


Display Options
Showing threads 121 to 140 of 139764
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 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.