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
to CONCATENATE from the smallest date with at least 2 criteria by Andri
Dear All, Here is the sample database. Date Salesman Region 16-Aug-08 A N 16-Aug-09 B E 16-June-07...
(Multi-page thread 1 2)
April 24th, 2010 12:49 AM
by Andri Go to last post
17 256
Shared Excel File by jkcates
Hello, I created an excel spreadsheet in 2007, which I then shared in the office to other users. The file had drop down menus in some boxes. Some users in...
April 24th, 2010 12:29 AM
by Gord Dibben Go to last post
1 130
Creating a formula by Jupiter53132
i have a long list of data with 10 columns of information, one column identifies my committee that's responsible (the committees are identified numerically 1...
April 23rd, 2010 11:11 PM
by Teethless mama Go to last post
1 144
Locking Worksheet Security Name by Mumsy[_2_]
In my old MS Word version, pre-2007, I was able to lock my worksheet with my password and a number at the end. Example--abcdef2009. Now, since I got 2007,...
April 23rd, 2010 10:44 PM
by Mike H Go to last post
1 130
Pre-Populating Fields by MP
I have a table of data that I want to pull numbers from based on different scenarios. I'm not sure how to set this up in Excel. Can somebody help me write...
April 23rd, 2010 09:09 PM
by Teethless mama Go to last post
2 117
Word lists by overthehill lady
I am a teacher and I use vocabulary lists. I would like to know if there is a way to mix up a list of words so that they do not appear in the same order all...
April 23rd, 2010 09:02 PM
by Teethless mama Go to last post
3 126
Need a code by MAX
I need a code that does the following: If C3D3, B3 value will start blink and if C3D3, E3 value will start blink. Any help please. Thanks in advance.
April 23rd, 2010 08:34 PM
by Luke M[_4_] Go to last post
1 116
Dynamic DropDown list from Unsorted vector by RegorTheGreat
This seems to be a fairly common question I have found...with no answer! Maybe I just missed the answer somewhere, but I am hoping to get a quick, direct,...
April 23rd, 2010 08:16 PM
by RegorTheGreat Go to last post
0 137
VLOOKUP and IF together by FR[_2_]
Hi, I trying to create a formula for this. Sheet 1 - where the formula is created Column A - name part-number Column B - name wholesaller Column C - price of...
April 23rd, 2010 07:50 PM
by Don Guillett[_2_] Go to last post
3 131
Help me (Vlookup) by Amin
hi my problem here is that i get this #NA thing anytime i select a product code more than twice. data is formatted as tables in the lookup sheet with 757...
April 23rd, 2010 07:37 PM
by L. Howard Kittle Go to last post
6 132
VLookup between date ranges ? by Steve
A B 2010082 4/3/10 2010091 4/10/10 2010092 4/17/10 2010101 4/24/10 2010102 5/1/10 2010111 5/8/10
April 23rd, 2010 06:51 PM
by Steve Go to last post
6 112
COUNTIF Formula by Gyles
I am using an excel spreadsheet to keep track of ratings. Count A and C. The spreadsheet used to updated automatically when A or C was entered, but now it...
April 23rd, 2010 06:37 PM
by Jacob Skaria Go to last post
1 123
Formulas do not update by AZSteve
Excel 2003 - Formulas on one worksheet (pMon) referring to another worksheet (pCSRs) all-of-a-sudden stopped updating when the information on the second...
April 23rd, 2010 05:48 PM
by AZSteve Go to last post
2 103
Getting the average from a column using date constrants by Trevor.
Using Column A (Date) Formatted Monday, February 1, 2009. I want to grab the Average of column Z (percentage) where the Month of the row is February. In a...
April 23rd, 2010 04:54 PM
by Trevor.[_2_] Go to last post
8 171
Data validation dependant drop down on unsorted list by Reacher21
I can't see a solution on contextures.com or here so hoping someone can put me out of my misery! I have a master list of vessel names on Sheet1 Column A. On...
April 23rd, 2010 04:32 PM
by Roger D[_3_] Go to last post
6 200
Import underscore in coding every after 2 digits by Manos
Dear All I have a fixed coding with 8 digits. (ie: 40000000). I need to change this and split it importing underscore every two digits in order to look like...
April 23rd, 2010 04:08 PM
by Dave Peterson Go to last post
4 117
Sumproduct with 4 variables by Steve
I posted this last week, but didn't explain it very well, so hopefully this is a bit clearer. One of the variables has 7 possibilites, another has 8. These...
April 23rd, 2010 03:51 PM
by Steve Go to last post
2 119
ODBC Query by Laddie
Is there a way to have an ODBC query when refreshed simply insert the new rows into the spreadsheet, thus preserving any data in adjacent columns which needs...
April 23rd, 2010 03:35 PM
by Laddie Go to last post
0 109
How to select other random cells by Chad
I have a 2 part question. I want to have a 1 question survey randomly filled out by 200 people. Column A lists the 1 questions. Columun b has ABCDE listed...
April 23rd, 2010 02:49 PM
by Chad Go to last post
0 128
Lookup by Kaisa
A B C E F 1 SKU SUM SKU SUM 2 85 10 85 10 3 86 20 86 20 4 87 30 88 30 5 89 40 I'm trying to make a formula that can tell me the sum of each number....
April 23rd, 2010 01:58 PM
by Jacob Skaria Go to last post
3 107
Post New Thread


Display Options
Showing threads 1041 to 1060 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 07:51 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.