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
Normalize/concatenate by EllenM
Hello, I have a data set that looks like this: Sortterm Doc # Main Term CAS # CFR REG # DIPHTHALATE 7065 DI(2-ETHYLHEXYL)...
(Multi-page thread 1 2)
March 11th, 2010 06:19 AM
by minyeh Go to last post
10 292
How do you make a userform open automatically when you open excel? by Evan
I created a Userform in VBA, and want it to automatically appear upon opening the Excel file everytime. How do I do that?
March 11th, 2010 03:24 AM
by John Go to last post
1 165
lookup question by Art
I have a sheet in Excel 2007 that lists all of the courses we offer. Columns L to O indicate if a particular course if offered each quarter. For example, for...
March 11th, 2010 01:24 AM
by Mayasmom Go to last post
1 142
vintage fashion by raismisuaween
vintage postcards vintage mens vintage audio amplifiers vintage dolls vintage definition
March 11th, 2010 12:49 AM
by raismisuaween Go to last post
0 148
how can I use conditional formatting with formula and 3 poss resul by CBS
Want to test 5 calculated results against a static target. If result greater than target, color cell green. If result = target, color cell yellow. If result...
March 11th, 2010 12:40 AM
by Fred Smith[_4_] Go to last post
1 121
Referecing Worksheet names that are dates in a formula by David McLean
Hi There, I've got a tricky one here, and I'm not sure if anything can be done about it. Here's the situation... I've got a workbook that I use to track the...
March 11th, 2010 12:37 AM
by T. Valko Go to last post
2 120
Can a formula be "built" referencing text content from another cel by Pradhan
Hi, and thank you for your help. I have run across this need many times...is there any way to use to contents of one cell, to construct a formula in another...
March 10th, 2010 11:56 PM
by Max Go to last post
3 115
Percentage max formula? by liaper
i need to find out how divide two cells but the answer cannot be more than 150% for example: I want to divide A2 and A1 abd have the answer be on A3 but the...
March 10th, 2010 11:36 PM
by tompl Go to last post
2 115
Pivot Table Wizard causes crash by mike in texas
Hello, I'm using Excel 2003(11.8316.8221) SP3 When I use the Pivot Table Wizard and press the "back" button to redefine the range of data. Excel crashes....
March 10th, 2010 11:34 PM
by mike in texas Go to last post
1 118
Returning a label rather than a number in pivot table field by Kristian
I am new to pivot tables and have managed to create a few that show the desired data. However, I would like the value returned to be the name of a company...
March 10th, 2010 10:59 PM
by Herbert Seidenberg Go to last post
1 177
customize drop-down box by Art
Is there a way to use Data Validation to create an in-cell drop-down box from a range of cells...but before displaying that list in the drop-down box, can...
March 10th, 2010 10:40 PM
by Art Go to last post
1 138
How do I subtract todays date from range of dates by AHD3
I need to make todays date as a constant so when I drag the formula down the cells used in calculating the cell with todays date does not change.
March 10th, 2010 10:30 PM
by David Biddulph Go to last post
2 150
How to MATCH value up a column by DevourU
I need to match/find the first matching cell up a column. Ideas? TIA!
March 10th, 2010 10:09 PM
by DevourU Go to last post
3 117
using indirect to return a named range? by ker_01
I'm having a mental block on how to do this. I have a boatload of named ranges in my workbook. I have one worksheet that has two data validation cells and a...
March 10th, 2010 10:02 PM
by ker_01 Go to last post
1 113
SUMPRODUCT and Dates by Glenn
Greetings, I am using the following: =SUMPRODUCT(($D$27:$D$500=C12)*($G$27:$G$500=$K$2)*($G$27:$G$500=$K$3)*($H$27:$H$500="Single")*($B$27:$B$500)) where C12...
March 10th, 2010 09:36 PM
by Glenn Go to last post
2 94
How to remove headers when importing from an external source? by e-Learning
I am combining several worksheets into a summary document. When I import external data, the headers for each worksheet remain. These are the headers that...
March 10th, 2010 09:16 PM
by Don Guillett[_2_] Go to last post
1 120
Count Cells Within 10 of a Cell Value by Missbrooke06
I need a formula that calculates how many out of a range of cells are within 10 of another cell. For instance, I have cells F3 through U3. I want to know how...
March 10th, 2010 09:14 PM
by Mike H Go to last post
2 132
"search" a different sheet with multiple criteria by Art
I would like to know if its possible to use a formula like VLOOKUP using more than one criteria in Excel 2007? For example, say I have Sheet 1 that...
March 10th, 2010 09:11 PM
by Art Go to last post
2 180
Import multiple photos into excel by shanelawler[_2_]
I am trying to create a photo sheet that will allow me to import all photos in a directory into an excel spreadsheet. I want it to: Import all images in a...
March 10th, 2010 09:00 PM
by Billns Go to last post
1 113
excel number appearances by longgone
some numbers in excel speadsheet appear like ####### How do I get rid of them/fix them to show a currency amount
March 10th, 2010 08:31 PM
by Mike H Go to last post
1 87
Post New Thread


Display Options
Showing threads 2221 to 2240 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 02:48 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.