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
How do I hide #N/A, ### in cells not yet worked on? by Sunny9210
My spreadsheet is a pricing sheet with formulae using lookup in another worksheet so it fills in the rest of the row automatically. All rows below what has...
(Multi-page thread 1 2)
February 13th, 2010 02:13 AM
by Fred Smith[_4_] Go to last post
11 341
Changing cell colors from a function command by Joebeone
I am trying to change a cell color to either red, yellow or green if the data in the cell is greater than lets say 90 it would turn red. Less than 90 but...
February 13th, 2010 02:11 AM
by Fred Smith[_4_] Go to last post
3 129
finding duplicate addresses across 2 worksheets in the same workbo by DAY
I have 2 spreadsheets within the same workbook that contains duplicate addresses. I need a macro or a formula to compare all of the addresses in a column...
February 13th, 2010 01:32 AM
by Ashish Mathur[_2_] Go to last post
2 147
multiple work sheet data to link in one worksheet by MANISH
Kindly help me out with this problem. i have a data of multiple clients. e.g. complete data of a single client will found in single work sheet. the name...
February 13th, 2010 01:16 AM
by Ashish Mathur[_2_] Go to last post
6 147
Copy to another worksheet IF by mandy1979
I have a workbook with multiple pages. There is a master page that I have titled Hot Sheet. It contains all of the data for all agents. The other sheets...
February 13th, 2010 01:10 AM
by Ashish Mathur[_2_] Go to last post
3 162
Tab Control by John
I have a 15 page pricing program I wrote in Excel 2007 which includes various forms which would be filled out by the operator. I want to be able to have the...
February 12th, 2010 11:20 PM
by Gord Dibben Go to last post
2 118
Finding the combination that appears more times by Alonso[_2_]
Hi everybody i have a list on excel 2007 that displays the purchase of items on columns A:E, each column showing one (1) item I want to find what combination...
February 12th, 2010 10:27 PM
by Alonso[_2_] Go to last post
9 188
Dynamically load DataValidation List through Source field? by Dave
I'm using the Data, Data Validation, List option to create a dropdown list in a cell that references a range in my worksheet. However, the worksheet is very...
February 12th, 2010 09:35 PM
by Luke M Go to last post
1 127
Lickert Scale Formula Help Needed! by Danny Boy
I'm trying to figure out a formula that would produce the following flags" based upon an evaluation form that patients are completing regarding the services...
(Multi-page thread 1 2)
February 12th, 2010 09:07 PM
by Danny Boy Go to last post
10 182
2007 Excel - GETPIVOTDATA by Elizabeth
I want to create a formula that should be easy but can't get it to work for some reason. I have 3 cells within a pivot table that I want to add, then divide...
February 12th, 2010 07:47 PM
by Elizabeth Go to last post
2 119
Condional Formatting with Percents by Miki
I'm trying to conditionally format a row of calculated values displayed at percents with icons such that 0% - green light, 0% - red light. Any insight...
February 12th, 2010 07:31 PM
by Miki Go to last post
2 113
advanced search for excel not producing data by kim
When I do an advanced search through multiple folders for a specific cell in excel it is no longer providing the data. Some spreadsheets I search with the...
February 12th, 2010 07:28 PM
by David Biddulph Go to last post
1 99
Conditional formatting Icons by Miki
Hi All, I have values for two months - Current and Previous. If current month's value is closer to zero than previous month's value then i want to show a...
February 12th, 2010 07:22 PM
by Miki Go to last post
0 96
Automatic updating by Barb H[_2_]
I am familiar with how to do basic linking between worksheets/workbooks. I have multiple worksheets (some on Sharepoint, some on local drive) with different...
February 12th, 2010 06:10 PM
by Barb H[_2_] Go to last post
0 88
Excel - by luendab
Is there a way to check through a group of numbers and pick out the ones that total a figure. Eg: I have a value of $20,554.00 An the following credits, of...
February 12th, 2010 06:01 PM
by Mike H Go to last post
2 119
Formula for changing cell format based on more than 3 values by Francisco Rodriguez[_2_]
Hello, I was wondering how could it be possible to change the format (color to be exact) of a cell based one of 5 possible values (for example: 1=red; 2=pink...
February 12th, 2010 05:14 PM
by Pete_UK Go to last post
3 163
subtraction of negative numbers by Roger
I'm trying to create an equation that, on occation, will result in a subtraction of a negative, which then results in a larger negative number than it should...
February 12th, 2010 04:21 PM
by bwbmom Go to last post
9 73
Subtracting positive amts from negative and positive from positive by bwbmom
I have a problem with a spreadsheet that SOMETIMES would result in subtracting positive amounts from negative where I would want the result to show negative...
February 12th, 2010 04:15 PM
by bwbmom Go to last post
3 82
Incrementing Formula by Column Instead of by Row by Andy
In one worksheet I have the formula: =SUM(Data!B5:B78) referencing data in a column on another worksheet. I want to drag the formula down to the next row so...
February 12th, 2010 04:04 PM
by Glenn[_6_] Go to last post
1 83
How do I color one cell and have another cell get same color by glassman
I want to assign a yellow color to either of 2 cells and have a seperate cell turn the same color
February 12th, 2010 04:02 PM
by Otto Moehrbach[_2_] Go to last post
1 106
Post New Thread


Display Options
Showing threads 2981 to 3000 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:37 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.