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
Can I use an IS function with Vlookup by JJ in LA
I am trying to write a formula that says If the Vlookup returns NA, then plus a particular cell, otherwise return the vlookup value. Can this be done. I've...
August 9th, 2008 04:00 AM
by Dave Peterson Go to last post
2 79
Transferring formulas from older excel versions by climbergirl17
I have recently updated my Office to 2007. Recently I have found that some of my excel worksheets were altered in the process. Does anyone know if the...
August 9th, 2008 01:59 AM
by Fred Smith[_4_] Go to last post
1 85
Conditional format an entire row based on one cell by Wagman V1
Is there any way to have an entire row shaded based on a value in that row. I want rows to be shaded once if a date in the row has passed. I have tried using...
August 9th, 2008 12:09 AM
by Max Go to last post
3 85
Vlookup matching conditions by Nancy Guillemette
Bonjour, I have two large spreadsheets. I want to match the values in 4 cells (within the same row) in one spreadsheet and search a second spreadsheet to...
August 9th, 2008 12:09 AM
by Max Go to last post
3 103
Specify target cell by New Ton
Hello. I am trying to get an output to a specific cell after change in any cell in a range. This code does what i want, except it offsets target next to...
August 8th, 2008 11:38 PM
by Dave Peterson Go to last post
8 91
Cleaning Specific Data withing a range from a cell by Ziantist
I have nested some Numbers into , into a description column. What i would like to do is extract the numbers between these ' s example; 3/4" EMT ON STL 3...
August 8th, 2008 11:35 PM
by Teethless mama Go to last post
2 84
How do I create a formula by Trikester824
That returns different values for a cell that contains a yes, no or N/A.
August 8th, 2008 11:10 PM
by Otto Moehrbach[_2_] Go to last post
4 76
Another Macro Question by igotquestions
First of all, what would be a good book to get to help a new user with learning how to create macros for Excel? The Dummies books don't seem to help with the...
August 8th, 2008 10:56 PM
by Mike H Go to last post
9 105
Drop-Down Lines by FrazzledAdminAssist
I am trying to create a document with drop down boxes in excel. I go to the Data menu, click Validation and then Settings. I go to the Allow box and choose...
August 8th, 2008 10:48 PM
by FrazzledAdminAssist Go to last post
3 111
text to column by Mike
I have a column that contains email addresses, a space, and then a street address which has spaces between the street number and the street name. In some...
August 8th, 2008 09:58 PM
by Gord Dibben Go to last post
6 107
Yesterday by Loadmaster
I currently have a conditional formatting formula in Cell B2. Condition 1 is this: Cell Value Is, between, =NOW()+1 and =NOW()+31, formatted yellow. This...
August 8th, 2008 09:41 PM
by Loadmaster Go to last post
5 50
how do I unmerge data in a column and distribute in rows? by Mike
I have data from an address base that when cut and pasted gourped or merged three cells. I would like to unmerge them and distribute the information from 3...
August 8th, 2008 09:40 PM
by Gord Dibben Go to last post
7 170
How do I convert an excel worksheet into a word document? by Countess Page
I am trying to convert a 50 page excel workbook into a word document without revealing formulas and certain other information. I am using office 2007 and the...
August 8th, 2008 09:20 PM
by Marcelo Go to last post
1 93
Subrange by Oscar
In range a (part of the column) I have series of values. I want to calculate sum of positive and negative increments. Formula...
August 8th, 2008 09:05 PM
by T. Valko Go to last post
5 70
Macro help by igotquestions
I am trying to create a macro that will add the dollar values in a specific column. The problem I am having is that the number of vaules in that column vary...
August 8th, 2008 09:00 PM
by igotquestions Go to last post
4 89
Conditional Formatting by TaylorLeigh
I want the message "Inventory is below minimum" when a calculated field falls below a certain number. Is it possible to have this message appear in the cell...
August 8th, 2008 08:28 PM
by TaylorLeigh Go to last post
2 64
functions do not calculate correctly by petew812
I have used the financial functions lots in the past. Suddenly the simplest of functions are not returning the correct answer. Even if I use the examples...
August 8th, 2008 08:08 PM
by petew812 Go to last post
6 85
CONDITONAL SUM DATE RANGE ISSUE by woody
Having an issue with suming using the Conditional sum wizard. At the bottom is the formula. Have 3 criteria, a specific code number (shown as V13 below ) and...
(Multi-page thread 1 2)
August 8th, 2008 07:07 PM
by Peo Sjoblom[_2_] Go to last post
10 156
Conditional formatting by Trish
is it possible to preserve conditional formatting in a excel worksheet when saving as a html?
August 8th, 2008 06:49 PM
by Duke Carey Go to last post
1 80
Problem using average or sum formulas by Miki
I'm facing problem while using sum or average formulas in same worksheet when I try use it for more than 30 different cells. It calculates only 30 and if I...
August 8th, 2008 06:28 PM
by Bob Phillips[_2_] Go to last post
3 101
Post New Thread


Display Options
Showing threads 21881 to 21900 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 02:05 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.