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
Macro Formula for counting rows and doing a fill in afterwards by Bud
Hello We are copying data from a worksheet in workbook#1 into a workbook#2 with a macro in it and into Worksheet A specifically of that workbook #2. While...
September 25th, 2008 08:10 PM
by Bud Go to last post
0 137
In Excel, how do I count cells with a particular format (e.g. colo by voyagerff
I inherited a large spreadsheet with certain rows colored red. I want to be able to count the red rows (or cells). Is there some function that can test for...
September 25th, 2008 08:09 PM
by Gord Dibben Go to last post
3 202
year formula returning incorrect value by dbdewitt
As I understand it, the YEAR formula should return the year to which the formula relates. I have a date of 4/24/2008 in a cell (let's say it's in cell B2),...
September 25th, 2008 07:46 PM
by muddan madhu Go to last post
5 145
Excel 2003-Data Validation drop down list not working? by Balcott
Spreadsheet created in Excel 2003. Drop down list in data validation cells works fine for me and most others, but have one person using the spreadsheet (in...
September 25th, 2008 07:42 PM
by Gord Dibben Go to last post
1 202
matching cell values by Geofridu
I have a spreadsheet with cities and time zones. I have another with zip codes, cities, states, and area codes. I would like to match up the time zones...
September 25th, 2008 06:49 PM
by Geofridu Go to last post
2 163
Comma in Function Argument name treated as separator by Error trying to sort in a Macro
I am referencing an internet based workbook in a Vlookup function that has a comma in the internet address. The problem is that Excel is treating the comma...
September 25th, 2008 06:40 PM
by Niek Otten Go to last post
1 135
Lookup text in a string with wildcard and return a certain value by Tommy
I am using Excel 2003. I can't seem to figure out a function. I need help on looking for a certain value in a long string and return a certain value in the...
September 25th, 2008 06:21 PM
by T. Valko Go to last post
4 220
Ctrl+Home is not A1 by Lilbit
When I press Ctrl+Home, the cursor goes to cell C1. Why? -- Message posted using...
September 25th, 2008 06:20 PM
by Lilbit Go to last post
2 199
omit numbers past decimal in formula result by DebC
In a prefilled form, the formula in cell B1 is: =roundup(A1/4,0) Cell A1 = 24, so the answer should be 6. My problem is that even tho the cell displays the...
September 25th, 2008 06:19 PM
by T. Valko Go to last post
6 279
if function by hal
Not sure if this is the best way to go about this, but a scaled down approach of what i'm trying to do is see if a value in one cell is greater than five other...
September 25th, 2008 06:19 PM
by Pimamedic Go to last post
1 148
Odd and even numbers by RodJ
I need a function that would count how many are odd/even numbers in a row or column. eg: 1,3,6,22,35 = this row has 3 odd and 2 even numbers. Is there a...
September 25th, 2008 06:14 PM
by Peo Sjoblom[_2_] Go to last post
6 180
Getting a unique list, then counting in a range by JN[_3_]
I have a bunch of blocks of 5 x 5 that look like this: 1,3,7,3,7 2,7,3,7,2 2,4,8,8,2 1,2,8,4,7 1,4,7,4,2 What I want to do is have a summary of the count of...
September 25th, 2008 06:14 PM
by JN[_3_] Go to last post
3 158
Analyzing survey results by Tina K
Hi Everyone, I am analzying the results of a survey for our company and I am wondering if there is a better (smarter) approach in accomplishing what I...
September 25th, 2008 06:08 PM
by Tina K Go to last post
6 186
Validating a Cell by Lady Success
My columns look like: P/NP Copay Basis Copay - 90 day P R $100.00 P M $85.00 I want to validate...
September 25th, 2008 06:05 PM
by ShaneDevenshire Go to last post
1 140
if function by hal
Not sure if this is the best way to go about this, but a scaled down approach of what i'm trying to do is see if a value in one cell is greater than five other...
September 25th, 2008 05:57 PM
by hal Go to last post
3 116
XL2000 More Function Problems by LPS
My Excel 2000 workbook has two sheets, the first (Evaluation Detail) contains details about course evalutions per instructor. Column A is Course Name, B and...
September 25th, 2008 05:34 PM
by LPS Go to last post
2 172
Maxing out nesting levels limitation of IF function by Sergei[_2_]
I have a question on creating a drop-down menu in the cell that would check the contents of the other cell first, then based on what it finds there, it will...
September 25th, 2008 05:23 PM
by Sergei[_2_] Go to last post
3 310
Using worksheet names as references by bmac
I am not sure I can do this or not or if there is any easier way to do this... any help appreciated. I have several worksheets in a workbook. To keep it...
September 25th, 2008 05:16 PM
by Frederik[_3_] Go to last post
3 172
Formula Question by Sarah
I have a list of advertisements with the following information: Ad Order Number Insertion Date Background information: One ad can run on multiple days, both...
September 25th, 2008 05:02 PM
by Sarah Go to last post
0 130
Recipe by Paul
Hi, Is there any way that the user could choose an item from a combo box, and somewhere on the sheet the recipe for that item to be shown? i.e. choose BREAD,...
September 25th, 2008 04:33 PM
by Sandy Mann Go to last post
2 125
Post New Thread


Display Options
Showing threads 19881 to 19900 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 12:31 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.