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
Formula to find last different value in a column? by msnyc07
I have a formula that is based on comparing the last value in a column. Basically of not null it performs an action. However I need the ones after that to...
February 11th, 2010 10:33 PM
by Glenn[_6_] Go to last post
5 124
Formulae Help by KevL
Hi, I am trying to right a formulae for the following below: I think that I should be using the IF but can't seem to make it work. In my cell I will have a...
February 11th, 2010 09:47 PM
by KevL Go to last post
6 115
WORKDAY Function by Connie Martin
I've read, read, and read about the WORKDAY function (Excel Help and online) and cannot find a solution as to why my formula is giving me #NUM!. I read the...
February 11th, 2010 08:55 PM
by Luke M Go to last post
3 108
Delete ROW on Sheet#1 corupts data on Sheet#2 by Duane
If I delete a ROW od data on sheet1, my formulas on sheet2 screwup. a2 on sheet2: (Filled down to 200) =If('LIST'!$B2="Y","YES","NO") If I delete row #25 on...
February 11th, 2010 08:53 PM
by Gord Dibben Go to last post
4 116
February 11th, 2010 08:52 PM
by T. Valko Go to last post
1 180
Autofill data based on an assigned code/prefix by anrcreations
I am an estimator, and I am trying to make a new template that will allow me to enter a "smart part number" in column "A" that will find the corresponding...
February 11th, 2010 08:50 PM
by Luke M Go to last post
2 90
Conditional Format by Coach
I'm overthinking this: I need to conditionally format a cell(s) within a range of cells only if the nested formula contains an additional operator. Cells in...
February 11th, 2010 08:49 PM
by Luke M Go to last post
1 76
time blocking calendar by excelrookie
I would like to create a workbook that contains 52 worksheets (1 per week). I would like to be able to break down the day in 15 minute intervals and have a...
February 11th, 2010 08:31 PM
by excelrookie Go to last post
0 99
search for match by Tami
i have a list of merchandise on a week 1 tab, and a week 2 tab, etc through week 26. there are two columns of data: A=SKU, B=Description I need to find the...
February 11th, 2010 08:21 PM
by T. Valko Go to last post
1 59
Auto update information in footer by - pat
Hey, I would like to ad a feature in an Excel footer that would place a person's information(login name, identifier, etc.) for when the file was created...
February 11th, 2010 08:15 PM
by - pat Go to last post
0 105
Indirect function by javablood
I am trying to get the following to work to calculate percent change: =INDIRECT(("'"&$E$1&"'!" &$C$2& "42" - "'"&$E$1&"'!" &$D$2& "42")/"'"&$E$1&"'!" &$D$2&...
February 11th, 2010 08:02 PM
by Pete_UK Go to last post
3 120
IF statement that yields a value based on a formula by barbara h
Help! If cell B12 = 0, then I need the answer to be calculated based on the formual "B12 * .40". If cell B12 0, then the answer is zero. How do I do...
February 11th, 2010 08:01 PM
by Mike H Go to last post
6 110
Format 8.3568 into: 8 years, 4 months, 8 days, 10 hours, 45 minute by igorin
Hello, How can I format the number 8.3568 into: 8 years, 4 months, 8 days, 10 hours, 45 minutes and 7 seconds? Thank you!
February 11th, 2010 07:34 PM
by Rick Rothstein[_2_] Go to last post
8 153
EXCEL by BobT
I need to total a column of numbers eg 'R' but only if the column 'I' says 'DES'. -- BobT
February 11th, 2010 06:53 PM
by Daryl S[_2_] Go to last post
6 102
A Concatenate Formula Question by msnyc07
I am using Concatenate to build strings from a spreadhsheet. Mostly these are based on prior records. My data was delivered sort of like this Parent ...
February 11th, 2010 06:49 PM
by Daryl S[_2_] Go to last post
1 97
Sending a group email by Newbee
I want to send a group email from email addresses I have listed in my spreadsheet. How do I do it?
February 11th, 2010 06:47 PM
by Gord Dibben Go to last post
9 227
Can I 'embed' a formula to affect numbers as they're entered? by barkingmad
Ms Office Excel 2003 ( Ms Office Professional Edition 2003) I want to 'embed' a formula (eg: *.05) in multiple cells so that when data is then entered into...
February 11th, 2010 06:36 PM
by Gord Dibben Go to last post
2 111
AutoFill with Reference incrementing BUT able to delete! by Duane
Good morning folks! I hope I have a simple one for you but I am stumped! On sheet #1 (called: Kub Kar List) I have my sponsors listed down Col "F" and their...
February 11th, 2010 06:27 PM
by Gord Dibben Go to last post
2 83
Count Vaules in a range that appear in another range by T Newbery
I have three ranges e.g. Range 1 Range 2 Range 3 Bread Apples Bread Apples Oranges Buns Oranges ...
February 11th, 2010 06:08 PM
by T Newbery Go to last post
5 125
How can I stop format change when copying data into unlocked cells by Linty
How can I stop the format changing when I copy data into an unlocked cell in a format protected worksheet? I need to allow people to both enter data or copy...
February 11th, 2010 05:55 PM
by Gord Dibben Go to last post
1 81
Post New Thread


Display Options
Showing threads 3021 to 3040 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 07:11 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.