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
Counting cells with conditional formatting by AOdoc
I am trying to count the cells in a range that have a certain fill color in Excel 2003. Is there a way to use COUNTIF? If so, how do I write the criteria for...
June 2nd, 2010 03:27 PM
by Luke M[_4_] Go to last post
2 386
Index Match Inconsistencies by Office Girl J[_2_]
hi all, I am trying to use Index Match formula on 2 spreadsheets. There is 2 text fields and a date field which I need to match b/w the s/s. Problem 1: when...
June 2nd, 2010 03:01 PM
by Steve Dunn Go to last post
1 267
Trying to lookup based on a condition of two values by Trying to lookup based on a condition of
I have three columns A, B and C. I want too look up the value in C where A and B match different values. Example: A, B ,C apple, color, green apple , price,...
June 2nd, 2010 03:00 PM
by T. Valko Go to last post
1 360
Need a little math help in making a formula by Meenie
I have an audit and am looking for a specific item in the audit. I'm asking a specific question and the answer can be either Yes, No or N/A. To figure out...
June 2nd, 2010 02:46 PM
by Meenie Go to last post
2 354
Multi-Condition Formula by Malcolm
I’m using this formula; =IF(OR(‘Source Sheet’!C10={“”,”C”, “B”}),’Source Sheet’!B10). This allows what I enter into the source sheet to...
June 2nd, 2010 02:27 PM
by Malcolm Go to last post
5 409
Recalculate the Formula by Malcolm
Earlier today I was given 2 formulas for a problem I was having. I started with a formula that worked and I wanted to add 2 conditions to it. The formula...
June 2nd, 2010 01:53 PM
by Malcolm Go to last post
2 437
Drop Down Lists 2007 by tlynn
I have followed all the steps in creating a drop down list in Excel 2007: Created Named list on seperate sheet goto the sheet that the drop down will be on...
(Multi-page thread 1 2)
June 2nd, 2010 01:19 PM
by Max Go to last post
10 758
Finding identical rows in a list by Brian Clarke[_2_]
I have a long list in columns A to I. In some cases, all the items in adjacent rows are identical, and I need to be able to find these as quickly as...
June 2nd, 2010 12:33 PM
by Steve Dunn Go to last post
6 450
Loose formula/value (when building graphs) by PvZ
Hi, (looks like my previous posting was lost . . . . ?) thanks to the help from this forum (Roger G. !), ==for using the same graph, for various...
June 2nd, 2010 12:24 PM
by Roger Govier[_8_] Go to last post
3 358
Locking A Sheet Using Words & Numbers by Mumsy[_2_]
Before I got Office 2007 I was able to lock a spreadsheet using a word combined with numbers, i.e., locksheet123. Now I can't lock it using that formula I...
June 2nd, 2010 12:14 PM
by Dave Peterson Go to last post
3 441
How do I delete a space at the end of an amount or text by Maureen
How do I delete a space at the end of an amount or text?
June 2nd, 2010 12:06 PM
by Jacob Skaria Go to last post
5 377
Filter zeros from two columns, maybe on different rows by Jbaccinv
Before printing, I need to remove zero entries from two columns, but they are often different rows. Normal auto filter will not work, it hide positive...
June 2nd, 2010 07:54 AM
by Ashish Mathur[_2_] Go to last post
2 417
How to calculate the present value of a security, $5000 @ 7%, 20y. by catslgc
I'm trying to use excell to calculate the present value of a security that will pay $5000.00 in 20 years at 7% interest. PV=FVn/(1+I)N
June 2nd, 2010 07:35 AM
by Tom-S[_2_] Go to last post
1 366
Converting number to text by booshi
Is it possible to convert, say 1234 to one thousand two hundred and thirty four Thanks
June 2nd, 2010 06:17 AM
by Jacob Skaria Go to last post
1 433
Keyboard shortcut for current date and time by Raj[_4_]
Hi, Ctrl+ ; inserts current date and Ctrl+Shift+; inserts current ti me Ctrl+Shift+; inserts the current time with the date serial as 0 and not the current...
June 2nd, 2010 04:24 AM
by Jim Cone[_2_] Go to last post
1 445
How do I put a blank value in a cell not using "" in a formula by Gunnatrada
Thanks in advance I have a row that that is sometimes blank or contains a number followed by a space and two letters eg. In cell A1 I have the value 456 CR...
June 2nd, 2010 03:25 AM
by T. Valko Go to last post
2 492
Case sensitivity of functions in Excel by Raj[_4_]
Hi, Which Excel functions are case sensitive and which are not? Can anyone shed some light or point to some resource that explains the case sensitivity of...
June 2nd, 2010 03:12 AM
by T. Valko Go to last post
2 358
Cut, copy & paste functions in Excel 2007 are extremely slow. by Joe B.[_2_]
I just got a new Dell with Office 2007. Computer is a Vostro 430 with 4GB of RAM and a 2.8GHz processor. Cut, copy and paste operate extremely slow in...
June 2nd, 2010 02:29 AM
by odingalt Go to last post
3 473
To protect all worksheet simultaneously in a excel workbook by Vimlesh
If we select either few worksheets or all worksheet by holding 'shift' key, can these all worksheet be protected/unprotected simultaneously using either same...
June 2nd, 2010 12:17 AM
by Gord Dibben Go to last post
1 348
producing a report via a keyword - filtering and macros not suitab by UKMAN[_2_]
help needed please........ I am not a formula expert so bear with me please. I know filtering is available but I am trying to save effort as data goes into a...
June 1st, 2010 10:58 PM
by Steve Dunn Go to last post
1 369
Post New Thread


Display Options
Showing threads 121 to 140 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:31 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.