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
if cell equals "a" then another cell would calculate percentage by Brandy
I have a worksheet with a dropdown box of discount price codes and another with list prices. I need another column that would automatically figure the...
June 20th, 2008 05:18 PM
by Storm Go to last post
1 94
Excel template populating from a worksheet by Brandy
Good morning, I have an excel worksheet containing customer names, addresses, phone numbers, machine, serial number, type of service, last service date, next...
April 29th, 2008 05:36 PM
by Pete_UK Go to last post
1 90
How do I update a drop down box in Excel? by Brandy
I have an existing workbook with drop down boxes in specific cells. I need to update the information contained in the the drop downs. Can anyone tell me how...
January 5th, 2006 07:55 PM
by Duke Carey Go to last post
2 76
How do I count a named range for a specific word or acronym? by brandyb
I am trying to count how many times the acronym "SD" shows up for all worksheets in my file and on a specific row.
November 4th, 2005 08:50 PM
by Biff Go to last post
1 86
Still need help by brandyda
Please see Logical Function question posted today. -- B. Davis
(Multi-page thread 1 2)
June 3rd, 2005 12:02 AM
by Gord Dibben Go to last post
17 131
Logical Function by brandyda
Can anyone tell me what is wrong with this function? I've switched from Excel 2000 to 2003. - it used to work, but doesn't...
June 2nd, 2005 05:19 PM
by brandyda Go to last post
2 81
delete grid lines by brandyman1710
how do I delete specific gridlines in a certain cell, Is it possible to have offset vertical grid lines in the header section in relation to the grid lines...
November 17th, 2006 02:54 AM
by brandyman1710 Go to last post
0 63
Opposite direction by Branko Pecar
Assume I have numbers in cells A1:A5 and B1:B5. I would like to add them in column C, but following this formula: C1=A1+B5, C2=A2+B2,...,C5=A5+C1. How do I...
November 25th, 2009 06:47 AM
by T. Valko Go to last post
9 156
Can I enter a formula using data from cells in seprate worksheets by Brannon
I want to take the results of a fromula on one sheet and use it on another sheet. I want to know if I can put a formula in that can draw information from...
May 10th, 2005 09:27 PM
by Per Erik Midtrød Go to last post
1 214
Excel solver should allow "equal to" value to be a selected cell. by Brantlee
I am trying to solve a log series equation in an Excel 2003 spreadsheet. I want to have excel adjust a single variable in the equation to find a product equal...
May 19th, 2006 07:49 PM
by Tushar Mehta Go to last post
1 81
Howdo U copy a formula down a column, that uses data in another w. by brantty
Im trying to copy a formula to the rest of a column. The Formula uses the same data that sits on a different worksheet. Currently, when I copy and past the...
February 25th, 2005 11:11 AM
by brantty Go to last post
0 80
how can I eliminate the first 3 characters from a cell by brantty
I have a cell (A2) that has a code (AAA123456B). I need a formula that will eliminate the first 3 charatcers from this code and post the remaining characters...
September 28th, 2005 10:01 PM
by Gord Dibben Go to last post
3 88
change all at the same time by brasch
I'm currently working on a sheet tracking cash over/short in a register. I've made 52 sheets (1 per week). The sheets contains the same information. If one of...
February 17th, 2006 05:37 PM
by CLR Go to last post
1 78
Need help transferring information between work sheets! by [email protected]
I hope I can explain my question. Excel and I often don't see eye to eye. ************************ I have designed a workbook that will keep score sheets for...
April 25th, 2008 03:59 AM
by [email protected] Go to last post
0 74
Problem with entering values in Excel97 by Brasule
When I open a new sheet and try to enter a value into a cell (eg. "123"), it is automatically changed to 1/10th, ie. 12.3. I'm quite sure it has General...
October 15th, 2003 09:17 PM
by Kevin Go to last post
2 120
Working with Time in formulas/calculations by Braunn
Let's say I have a construction budget figure in cell A1 ($308,239,413). A2 contains an hourly income ($4,930,100). A3 then tells me how many hours I need to...
November 15th, 2008 09:41 PM
by Ron Rosenfeld Go to last post
2 57
Return sum of values based on lookup-function by Braute
Hi ! I want to do as follows: I work in another worksheet than the data. Wanting to find the same 6-digit number in the other worksheet and return the value...
February 25th, 2009 10:21 AM
by Max Go to last post
1 87
How to fill out a table (a row) with data from another worksheet by braveheart
I have two Excel worksheets: Worksheet #1. - it has extensive information on customers, a fragment of it is shown below: Cust # Customer...
October 3rd, 2006 07:45 PM
by braveheart Go to last post
4 78
Use a code to populate a cell with a specific value by braveT
I am using a spreadsheet to track print jobs. One of the things I track is the type of paper used and the cost of each piece for each job. Each paper stock...
April 13th, 2007 10:02 PM
by Storm Go to last post
5 82
make a macro to move specific rows to another sheet by braxton
i have a spreadsheet called "complaints" and one of the column headings is "status". the response is pending or resolved. now this is what i would like to do....
February 21st, 2005 10:01 PM
by Gord Dibben Go to last post
1 204
Post New Thread


Display Options
Showing threads 10101 to 10120 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:56 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.