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 373
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 257
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 349
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 340
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 394
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 417
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 735
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 432
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 345
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 433
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 355
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 409
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 357
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 420
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 427
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 486
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 337
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 464
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 333
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 354
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 05:35 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.