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
prevent div/0 error by Austin[_3_]
I am building a gradebook with limited knowledge of Excel. To get a weighted percentage, I came up with...
March 15th, 2010 06:37 AM
by Héctor Miguel Go to last post
2 193
How to set a formula if the value is with #N/A by lee-sc
Example : E/no salary Bonus total 001 1000 #N/A 002 200 100 003 2000 #N/A How to set a formula for...
March 15th, 2010 06:17 AM
by Ashish Mathur[_2_] Go to last post
4 197
Compound Interest Rate or Growth Rate by 1944-71222
Is there a function in Excell that can be used to calculate an investment"s compound growth rate? If so what is it and how do you use it? For instance if...
March 15th, 2010 05:38 AM
by Fred Smith[_4_] Go to last post
2 176
slow worksheet by rylie14
why does it take so long to open an existing worksheet
March 15th, 2010 05:35 AM
by Corey[_4_] Go to last post
1 185
Macro question by Tina
I need a macro that will add the text -0000 at the end of whatever text is in that current cell. For example Cell = 75154 I need to add -0000 at the end...
March 15th, 2010 04:23 AM
by Corey[_4_] Go to last post
2 184
Help with formula by Corey[_4_]
I have data readings on a worksheet in cells B3:AF12 (10 rows deep x 31 columns wide). I also have a date in cells A3:A12. One date for each row of data that...
March 15th, 2010 04:05 AM
by Corey[_4_] Go to last post
0 212
Printing Worksheet by GANTRYMAN
Is it possible to print a worksheet which shows the cell nos and row nos. If you check the comment box which sais " show comments at end of sheet" it states ...
March 15th, 2010 03:25 AM
by Ashish Mathur[_2_] Go to last post
1 178
Why does it display #### in my cell? by Lindsey-Star
In cell I25 I have the following formula: =SUM(I11:I14) All it displays is #####, but when I hover over it, it gives me the correct answer on a popup...
(Multi-page thread 1 2)
March 15th, 2010 12:32 AM
by Joe User[_2_] Go to last post
14 598
Lookup for this? by Zakynthos
Hi, In col A I have numbers 1 to 500 in sequential order In column B, I have values against each of these numbers In column C I have numbers 1 to 500 in...
March 15th, 2010 12:28 AM
by Zakynthos Go to last post
2 171
sumif by Robb27
I need to sum two cells together as long as either of the two cells have numbers in them. If either of the two cells has "A" in it, then I need to...
March 15th, 2010 12:05 AM
by Fred Smith[_4_] Go to last post
1 119
converting an .xlsm file to .xml? by Janis
how do you save an .xlsm file as .xml? the excel files are simple files with cells with no calculations. the records are county property records with some...
March 14th, 2010 09:53 PM
by Chip Pearson Go to last post
1 195
How to use the Stop If True Condition for highlight cells by Fefe
The Stop If True Condition don't seem to be work when you input an formula to highlight all cells greater than 100 and Stop If True, once it finds the first...
March 14th, 2010 02:51 PM
by Bob Phillips[_3_] Go to last post
1 130
Calculation Question by Scott
I have to calculate total tax based on a graduated scale. Let's say I make $15,000 (in cell A1) and I want to calculate tax in one cell (in cell B1). The tax...
March 14th, 2010 02:37 PM
by Ashish Mathur[_2_] Go to last post
2 148
Check to see if a value exists in a list? by Pradhan
Hi and thanks again for your help out there... Is there any function to test if a particular value exists in a list? A simple example: Column A1= car;...
March 14th, 2010 01:40 PM
by Ashish Mathur[_2_] Go to last post
4 163
Creating a new table from another - filtering out unwanted data by Kamalii
Here is my table for sheet1: Shipment No. Product No. of Pieces A pencil 1 B pen ...
March 14th, 2010 12:17 PM
by Ashish Mathur[_2_] Go to last post
8 207
concantenate then index match by Robb27
Hi. Is it possible to concantenate one cell with text with another cell with a number in it and take that result and then use it in an index/match formula...
March 14th, 2010 12:10 PM
by Ashish Mathur[_2_] Go to last post
2 106
Splitting Text from single cell in column across multiple Columns by Harold
Text To column wont work because I have name and address info in a single cell in this format. Each cell has different data representing different...
March 14th, 2010 12:06 PM
by Ashish Mathur[_2_] Go to last post
3 137
count nonblank cells by Art
I have a column B9:B100 on Sheet 1 in Excel 2007 in which each cell includes a formula (=Sheet2!A9). The results of a search appear on Sheet2, then appear on...
March 14th, 2010 11:54 AM
by Ashish Mathur[_2_] Go to last post
3 224
Formulas to reference range based on data in column by Code Numpty
I probably didn't title this too well. I have a spreadsheet with 500 rows of data, sorted by the date in column A. I want to extract certain data from rows...
March 14th, 2010 09:53 AM
by Code Numpty Go to last post
8 180
SUMIF (SUMPRODUCT?) with two arguments by Max
Something like this should work ok In M3: =SUMPRODUCT(($A$3:$A$100=L3)*($B$3:$B$100="Tom"),$C$3:$C$100) Real dates are assumed in col A and in L3, real numbers...
March 14th, 2010 08:47 AM
by Max Go to last post
0 130
Post New Thread


Display Options
Showing threads 2141 to 2160 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 06:12 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.