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
count how many different numbers in the column and return to the n by CC
I have a sheet Amount Item $12 1 $2 1 $8 3 $98 2 $23 2 the thing I would like to do is item ...
February 5th, 2010 11:54 PM
by Shane Devenshire[_3_] Go to last post
2 137
DMax with No Criteria by Paul Kraemer
Hi, I am using Excel 2007. I have a range of cells in which I want to find the largest (numerical) value in one particular column. I would like to use the...
February 5th, 2010 11:37 PM
by Shane Devenshire[_3_] Go to last post
2 142
repost of question from 2/4 "Using drop-down lists" by RoofIL
Thanks for the help. When I copy and paste the function you provided into C2 on sheet 1 and press enter I get #N/A. When I enter this formula and hit enter,...
February 5th, 2010 11:34 PM
by Shane Devenshire[_3_] Go to last post
2 131
Using wildcards with logical (IF, AND) conditional formatting by olddog
I have two columns: A & B. Assume A contains a combinaton of numbers and letters (e.g. 13.00.10i.022) and is formated as "General." Column B is a whole...
February 5th, 2010 11:28 PM
by Shane Devenshire[_3_] Go to last post
2 137
formula question by Cindy[_8_]
We have a spread sheet - htm - end project will be working with 90,000 records - broken into about 90 different spreadsheets... ColumnA - will be hyperlinked...
February 5th, 2010 10:33 PM
by Cindy[_8_] Go to last post
1 110
Formaula for less than date and name begins with...!!! HELP!!! by Senor Martinez
IM trying to create a formula that gives me a total count for cells that are less than 02/05/10 and the name begins with FHLM, heres what i came up with......
February 5th, 2010 10:04 PM
by David Biddulph Go to last post
4 144
Is Vlookup the correct way to do this? by tammyncook
Hello, I have a spreadsheet which is basically a database. I want to create a separate worksheet that will fill in with information from this database. What...
February 5th, 2010 10:02 PM
by Dave Peterson Go to last post
9 187
Adding text to an IF statement effeciently by Bishop
I have the following code in a cell on Sheet A: =IF(E41H41,"Rock on, Man! You are EXCEEDING your Stretch goal for the month!",IF(E41=H41,"Nice work! You...
February 5th, 2010 09:51 PM
by Bishop Go to last post
2 109
Conditional Formatting Not Working As Intended by Bishop
I have the following Conditional Formatting rules set up. This is the order they appear in the Conditional Formatting Rules Manager: Rule ...
February 5th, 2010 09:51 PM
by Bishop Go to last post
3 116
Using drop-down lists by RoofIL
I created a drop down list using data validation in sheet 1 from data in sheet 2. The data in sheet 2 reads: A ...
February 5th, 2010 09:20 PM
by Gord Dibben Go to last post
4 128
Excel 2007 drop down lists by Angela9520
I would like to create a drop down list of number that, when selected, will automatically fill out the the next cell with a name i.e. I select No. 120 and...
February 5th, 2010 09:15 PM
by Gord Dibben Go to last post
6 159
Function needed to search and pull data from 1 table to another by Heidi
Really need some help to determine what function/formula to use. Table A contains names of Learners and their job functions. The same learner could be there...
February 5th, 2010 09:05 PM
by Heidi Go to last post
4 146
multiply criteria in a range using sumifs by dloc
I hope someone can help, Please, I'm using the following formula to get payroll data from 1 table into another on a different sheet, the formula works great,...
February 5th, 2010 09:01 PM
by dloc Go to last post
1 114
combining =SEARCH & =IF statements by McRibIsBack
hello, I have a simple task i think, but i need some guidance! I have 3 Cells: A1: 12345 - 67891 A2: 12345-67891 A3: 1234567891 Here are the things I want to...
February 5th, 2010 08:26 PM
by Teethless mama Go to last post
4 103
Auto Fill-Down? by msnyc07
I have a sheet with about 20 records. One column is for Company. However the way the data was compiled only the first record has a value for company and then...
February 5th, 2010 08:11 PM
by msnyc07 Go to last post
2 101
Question About Sorting by Nancy
I want to make a spreadsheet that shows multiple book authors and the books they have written. I want to set it up so that I can sort the list by last name...
February 5th, 2010 08:03 PM
by Gord Dibben Go to last post
2 125
IF Formulas by MR4815
I am trying to create a formula that will keep a running total of containers that I use to ship with. The problem is that I want to use this off of my...
February 5th, 2010 07:42 PM
by Bob Phillips[_3_] Go to last post
2 101
Formula for if name begins with and date is less than or equal to. by Senor Martinez[_2_]
Im trying to create a formula that gives me a total count for cells that are less than 02/05/10 and the name begins with FHLM, on previous post teethless...
February 5th, 2010 07:34 PM
by Senor Martinez[_2_] Go to last post
5 107
Transfering a changing cell value progressively through a workbook by Mike1558
I am creating a payment application form in excel 2007 using windows 7. Each worksheet represents one months invoice. Say I have a formula in "sheet 1/ cell...
February 5th, 2010 07:33 PM
by Gord Dibben Go to last post
3 129
Formula to count data in a column that falls between a range by Paul_UK
i am trying to count the number of times a number between a range appears in a column e.g. in sheet 1 i have column1 Column2 2000 4000 3000 ...
February 5th, 2010 07:11 PM
by Eduardo Go to last post
3 128
Post New Thread


Display Options
Showing threads 3201 to 3220 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 08:59 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.