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 Reverse Sort Order Last Post Replies Views
Inserting automatic text in Excel by [email protected]
Is there an option in Excel for "Inserting automatic text" like in MS-Word? I would like to have some "pre-preapred" text expressions that I can easily insert...
June 8th, 2006 12:21 PM
by hans bal(nl) Go to last post
1 61
combining conditional formatting and functions by zvi
Hi all, I want an empty given cell, say AA5, to become the color red when a range of 8 cells in the same row starting 13 columns to the left of AA5 (i.e. the...
December 9th, 2005 01:37 PM
by zvi Go to last post
2 135
Why does the right 'Alt' key not work in Excel? by zuzartej
The right 'Alt' key does not work in Excel 2003. The key plus the enter key provides a paragraph break in a cell of text. When I discovered the problem at...
January 2nd, 2006 07:36 AM
by zuzartej Go to last post
4 129
how to add values of cells only if a corresponding cell has information on it by zuri125
Is there a function that can add up the values of cells but only if a corresponding cell has information on it. For example i have two columns of lists. The...
June 7th, 2006 06:59 AM
by Ardus Petus Go to last post
1 94
Adding a constant to a formula. Problems w/filling in by zuri125
I am trying to find a way to "fill in" a funtion. I have F2=E2+F1, for example. I want the cell next to it, G2, to be =E2+G1. In other words, I want Row 2 to...
February 3rd, 2006 07:16 AM
by Biff Go to last post
4 88
a function that counts the number of cells with information by zuri125
Is there such a function that counts the amount of cells with information in them. For example right now Im trying to find this so I can find an average. So Im...
June 7th, 2006 07:37 AM
by VN Go to last post
1 116
COUNT THE NUMBER OF LETTERS INCLUDING SPACES IN A CELL? by zurafz6
Im currently creating codes for our inventory list. The system provider mentioned that my codes can only have 30 characters including spaces and symbols. Now I...
March 6th, 2006 08:53 AM
by Biff Go to last post
7 114
Trouble With Data Validation And Filtering On A Dropdown by zura04
Hi all, I need help! I created a dropdown menu using Data Validation and a dynamic range, so that anything typed into the range automatically appears on the...
October 24th, 2006 08:58 PM
by zura04 Go to last post
0 51
Satisfying two conditions? by Zuo
I need to satisfy the following condition: If the longest side of a box is greater than 60 or its second longest side is greater than 30, then charge $8. I...
April 26th, 2010 06:05 PM
by Fred Smith[_4_] Go to last post
8 177
Matching two sets of data? by Zuo
Hi, I have two sets of data, one in A1:A450 and the other in D1:D700. I want the matching data (reference) of the array in column A to appear in Column C...
March 24th, 2010 03:25 AM
by Zuo Go to last post
5 136
Simple calculation where values change to letters? by Zuo
I have a simple formula (A1*B1*C1)/((A1*B1*C1)+(D1*E1*F1)+(G1*H1*I1)). However there are times when the values of D through F or the G through I denominators...
May 3rd, 2010 11:48 PM
by Zuo Go to last post
3 189
Fixing a formula to read a general format? by Zuo
A few months ago I had asked a question and got this answer: Question: I have a a set of values in A1 through A100. I need to look up each value and find a...
May 17th, 2010 01:02 AM
by Per Jessen[_2_] Go to last post
1 161
Changing a formula to read a general value? by Zuo
A few months ago I had asked a question and got this answer: Question: I have a a set of values in A1 through A100. I need to look up each value and find a...
May 13th, 2010 09:24 PM
by T. Valko Go to last post
1 129
Match value in one column and return value in same row in next col by Zuo
Hi, I have a a set of values in A1 through A100. I need to look up each value and find a match in another set of values located in C1 through C200. If a...
March 6th, 2010 10:28 PM
by Zuo Go to last post
2 127
Finding the corresponding value in a range? by Zuo
Hi, I appreciate if somebody can help me with a formula. In one spread sheet I have a list of products and their weights. In that same sheet I want to...
February 25th, 2010 01:45 PM
by Fred Smith[_4_] Go to last post
4 121
Finding the cell loacation that matches a specific value in a rang by Zuo
Hi, I have a list of references in column A going from A3:A240. I need a formula that can find a specific reference within that range and give me back the...
February 24th, 2010 11:09 PM
by Zuo Go to last post
3 106
Locating values in a range and bringing up the corresponding price by Zuo
Hi, I appreciate if somebody can help me with a formula. In one spread sheet I have a list of products and their weights. In that same sheet I want to...
February 22nd, 2010 08:53 PM
by Zuo Go to last post
3 127
Copying data from 205 columns to 1 column by Zuo
Hi, I am using Excel 2007 and have a table that has 205 columns and 15 rows. I want to copy the data of the 15 rows of every column under Column A with a...
February 22nd, 2010 05:18 PM
by Max Go to last post
4 97
Draft by Zuny
I work on a lot of different budgets in excel. I want to know if there is a "draft" template or form that would show the word "draft" all over the budget. So...
February 10th, 2004 05:58 PM
by Frank Kabel Go to last post
1 219
How can I prevent users from linking to other sources in Excel? by Zuni
Is there a way to protect the Excel workbooks so that users cannot create links to external sources when they enter data?
March 6th, 2006 07:51 PM
by Barb Reinhardt Go to last post
2 77
Post New Thread


Display Options
Showing threads 101 to 120 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 03:29 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.