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 Reverse Sort Order Replies Views
Is there anonther way to write this? by Ayo
Is there an easier, or simplier way to write this...
November 20th, 2009 06:46 PM
by Jacob Skaria Go to last post
1 122
Shared workbook by puiuluipui
Hi, i have a shared workbook. I want to work with another user, at the same time. But if i enter some datas on the same row as the other user, i receive an...
November 20th, 2009 06:44 PM
by puiuluipui Go to last post
0 118
How to select one record of each from a column by Cesar Urquidi[_3_]
Hello, I have a large worksheet with data. Here are the columns (a,b & c): Order # Employee Hrs. 1000 Mike 2 2000 Mike 1 1000 Paul 2 3000 Rose 3
November 20th, 2009 06:34 PM
by Lars-Åke Aspelin[_2_] Go to last post
2 110
Conditional format for complete column by Vaquita
Hi I have the following conditional rule in column Z3 =AE3(TODAY()-30) I want to apply it for 50 cells more it means from Z3:Z53 using the information from...
November 20th, 2009 06:26 PM
by Jacob Skaria Go to last post
1 95
Help with if statement by rew3791
Ok, I can't quite make this formulat work. Assume: Column D is Birth Year, Column E is Death Year, Column F is Age at Death The basic formula is =E-D (Death...
November 20th, 2009 06:08 PM
by T. Valko Go to last post
4 137
counting based on two dates by AccessNoviceButTrying
I have two columns which both contains dates. I want a count based on criteria from the dates. For example... Start Date End Date 01/01/08 ...
November 20th, 2009 06:02 PM
by Jacob Skaria Go to last post
2 92
Data not updating in linked workbook by Teri
I have two workbooks that I was trying to link together. Workbook 1 holds the data and the information went on to workbook 2 but it's not updating when you...
November 20th, 2009 05:53 PM
by Dave Peterson Go to last post
1 114
Condition based on multiple cells by WAR
I would like to look at 3 cells: A6, C6, E6. If all 3 of these cells are blank, I would like to return a blank cell. If any of the 3 cells has a value, I...
November 20th, 2009 05:04 PM
by WAR Go to last post
4 99
Rounding Effecting Sum by Steve Graves
I have cells that cotain formulas based on adding four other cells together. One of those cells is the result of a percentage applied to a dollar amount. ...
November 20th, 2009 05:03 PM
by Joe User[_2_] Go to last post
2 95
Cannot navigate between cells using arrow keys by Jim Gardner
In a worksheet I regularly use I used to be able to move from cell to cell using the arrow keys. Now when I select a cell and press one of the arrow keys,...
November 20th, 2009 04:53 PM
by Bob I Go to last post
2 100
Problem with PowerPivot Virtual Lab by dbaechtel
I am following the PowerPiot Virtual Lab from https://cmg.vlabcenter.com/default.aspx?moduleid=ad3bd3e9-8d2b-498d-94fa-e41e1b09730d with Excel 2010...
November 20th, 2009 04:52 PM
by dbaechtel Go to last post
0 129
Incorrect result for simple SUM formula by VivienW
Hello, Does anyone know why Excel sometimes give an incorrect result when adding the contents of cells? It may only be 1p out but even if I increase the...
November 20th, 2009 04:46 PM
by Joe User[_2_] Go to last post
9 147
missing drop down command by Darin
I was customizing my toolbars and when I click on the data drop down menu, I accidently clicked on one of the options and tried to drag it into my toolbar. ...
November 20th, 2009 04:43 PM
by Bob I Go to last post
1 98
Transform table into calendar format by Matheus
I have a table with dates (column A) and events (column B). I wanted to know how I automatically create a calendar template with the events I have on this...
November 20th, 2009 03:58 PM
by Matheus Go to last post
2 119
Office 2007 Converter for Office 2003 by Rob Jordan[_2_]
I have this one machine that is running MS Office 2003 SP2 (Must remain SP2 due to a unified messaging app that's broken by SP3). I've installed the File...
November 20th, 2009 03:58 PM
by Rob Jordan Go to last post
1 118
Calculation if a cell contains a word by James
I've exported data from a database and then performed a subtotal/count. I need to multiply the count of the different criteria by three different values. If...
November 20th, 2009 03:27 PM
by James Go to last post
4 82
Autofiltr w Tabeli z formułą w kolumnie funkcjonuje błędnie by Rulon
Excel 2007. W pierwszej kolumnie tabeli wprowadzono formułę obliczającą liczbę porządkową, by po wyfiltrowaniu nieaktywnych klientów numeracja nie...
November 20th, 2009 03:23 PM
by Rulon Go to last post
0 115
How to Delete entire rows by selecting different text in column A by Doug[_15_]
I have a database that exports data to excel where duplicate and specific data is deleted using macros. My question is the data in column A uses multiple...
November 20th, 2009 03:03 PM
by Doug[_15_] Go to last post
2 117
compare for high with two or more cells and then flag. by Mario
Hi Guys; I have this sheet, Mario's and Joe picks, i need to flag who has the highest percentage number in colummn D5 or D11. In these example D5 is higher...
November 20th, 2009 03:01 PM
by Luke M Go to last post
1 137
More than 3 Conditions by John Moore
Hi, I am looking for a code which will do the following for me Range is T5:T90 Condition 1: If Cell value is 10 make background light blue Condition 2: If...
November 20th, 2009 02:59 PM
by Luke M Go to last post
2 96
Post New Thread


Display Options
Showing threads 9681 to 9700 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 06:16 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.