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 you update a cell after an operation on it. by Tony
Can you do a calculation on a cell, get the answer and then post it back to the same cell?
June 24th, 2009 08:32 PM
by Luke M Go to last post
3 153
How to update a cell after a calculation? by Tony
I am creating a spreadsheet that keeps track of my inventories. I want to set it up to do a calculation using a cell, and then update that cell with the new...
June 24th, 2009 08:30 PM
by Mike H Go to last post
1 159
Comparing two colunms by Red Deer Tech
I have a user that is trying to do the following: In column A is a set of numbers (for this example we will say 40 rows) In column B is a set of numbers (for...
June 24th, 2009 08:25 PM
by Bernard Liengme[_2_] Go to last post
1 254
June 24th, 2009 08:17 PM
by Bernard Liengme[_2_] Go to last post
1 204
if statment by Stuntz Waldorf
I have a cell (b1) formatted as ddd, d-mmm-yy and I need cell (a1) to show "weekend" if the cell (b1) is a "Sat" or "Sun". What is the proper syntax for this...
June 24th, 2009 08:07 PM
by Bernard Liengme[_2_] Go to last post
4 234
how do you highlight the result of an IF statement by clipski
Hello, I have a simple If statement that results "PASS" if the statement is true and "FAIL" if the statement is false. Is there a way that the result can be...
June 24th, 2009 08:05 PM
by Shane Devenshire[_3_] Go to last post
4 215
@IF Formula by Ann 'Formula challenged'
Hello, I struggle incorporating @IF formulas. I have three date columns. I need to find the work days between any two dates. My challenge is when I use...
June 24th, 2009 08:00 PM
by Bernard Liengme[_2_] Go to last post
3 258
Range - using in code by Stephanie
Hi, All! Excel coding is a whole new ball game! I set ranges (A5:F11) as "PeopleDrivers" and range (A13:F26) as "ProcessDrivers". Column F is a "Click here"...
June 24th, 2009 07:38 PM
by Stephanie Go to last post
5 139
Modification Time Update by Kanmi
Please i want to modify this formula to change when column content below it change. "=TODAY()" or if other way to do it. A ...
June 24th, 2009 06:48 PM
by Bernie Deitrick Go to last post
3 333
AUTOMATIC COLUMN TRACKING by Kanmi
I WANT TO SET COLOUR ON A WORKSHEET THAT WHEN I CHANGE CONTENTS ON THE ROW WITHIN 2DAY THE COLOUR OF THAT ROW SHOULD SHOW YELLOW "SET FOR "2DAYS" AFTER...
June 24th, 2009 06:41 PM
by Kanmi Go to last post
0 164
ISNA Formula returning "False" instead of value by Picman
i wrote this ISNA Formula =IF(ISNA(VLOOKUP($A2,Specialists!$A$2:$E$93,2,FALSE)),VLOOKUP($A2,Specialists!$A$2:$E$93,2,FALSE)) and it is returning "False"...
June 24th, 2009 06:30 PM
by Picman Go to last post
4 122
Name by Talladega
Hi, I have two colums, check number and number of months. I want to create a formula showing if it is more than 36 months then it shows "Check No. 457" if...
June 24th, 2009 06:27 PM
by Bernard Liengme[_2_] Go to last post
2 179
Counting with multiple matching criteria by Gary''s Student
A colleague came to me yesterday and complained about the length of formulas. She needs to count occurrences of values in a table that meet any of several...
(Multi-page thread 1 2)
June 24th, 2009 06:11 PM
by Gary''s Student Go to last post
12 305
VLookup formula transposing table_array when copied to another cel by PHammonds
I'm using the VLookup formula on a table with hundreds of rows of data. Obviously, I don't want to enter the formla manually on each row; but when copying...
June 24th, 2009 06:01 PM
by Jacob Skaria Go to last post
1 173
Eliminating Duplicate values on a large workbook by Wacky Wednesday
I have a 22 sheet workbook and the first tab is the monthly department wide summary based off the individual employees. One column counts how many documents...
June 24th, 2009 05:51 PM
by Wacky Wednesday[_2_] Go to last post
1 143
sum function by dannyboy8
I have a row of numbers, both positive and negative and am looking to sum up these rows, but omit all the negative #s in the sum, how would I write a formula...
June 24th, 2009 05:09 PM
by Rick Rothstein[_2_] Go to last post
1 149
can EXACT search for text in an entire spreadsheet? by stuckonexcel
Hi I'm working from Excel mac 2008 and I am trying to create a formula that allows me to search a name from one spreadsheet, againt the entire contents of...
June 24th, 2009 04:44 PM
by Rick Rothstein[_2_] Go to last post
3 154
COLOUR MANAGEMENT by Kanmi
I WANT TO SET COLOUR ON A WORKSHEET THAT WHEN I CHANGE CONTENTS ON THE ROW WITHIN 2DAY THE COLOUR OF THAT ROW SHOULD SHOW YELLOW "SET FOR "2DAYS" AFTER...
June 24th, 2009 04:16 PM
by Kanmi Go to last post
2 134
Column sum will not add by babzybaby
Ok here is my problem. I am working with a large spead sheet. I have six columns that are adding up to the correct sum and two that are not identifying any...
June 24th, 2009 04:15 PM
by Michael Arch Go to last post
1 143
Chart on Excel 2007 by milu
How do I change the data on the Y axis set automatically by the program? I already tried with the 'Select Data' option but it only allows you to change the...
June 24th, 2009 04:09 PM
by milu Go to last post
0 124
Post New Thread


Display Options
Showing threads 9801 to 9820 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 09:19 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.