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
vlookup formula error by Samantha
I am trying to lookup a value in one worksheet, find an approximate match in another table, and return the corresponding value from the 2nd column of the...
April 10th, 2010 01:41 PM
by Dave Peterson Go to last post
2 99
Time elapsed calculation by MTate
I have a text string in a cell that comes from an AS400. I need for this string to convert to a time value. Example text: 20100409073000 In the AS400 this...
April 10th, 2010 01:29 PM
by Ron Rosenfeld Go to last post
9 117
Keyboard shortcut for Paste Special-Values by skoeske
I find myself using "Paste Special - Values" a ton, a keyboard shortcut for this function would be fabulous. I'd also like to see a keyboard short cut for...
April 10th, 2010 06:55 AM
by Michael Go to last post
4 204
Updating Next Consecutive Cell in Range by Stilltrader47
I am trending a bank account balance. Every time I enter the current value in cell c3, I would like it to update the value in the next empty cell in range...
April 10th, 2010 06:00 AM
by Stilltrader47 Go to last post
8 193
How to set up a conditinal formula w/letters vs numbers? by lz
I'm trying to create a conditional formula that will say true if the cell contains a certain string of words and false if it doesn't. For example: If in...
April 10th, 2010 05:34 AM
by Dave Go to last post
2 162
Multiple table lookup by tornado1981
A B 1 Name Code 2 London 301 3 Paris 302 4 Rome 303 5 Moscow 304 6 Madrid 305 7 Berlin 306 9 Name Code
(Multi-page thread 1 2)
April 10th, 2010 04:50 AM
by T. Valko Go to last post
12 265
How do I set up a formula to give me an average based on IF? by Kris M[_3_]
I need help! i'm trying to get a formula for an AVERAGE base on if a value is less than 4.01 in column IF another columns value is 01, 02, 03 and so on....
April 10th, 2010 03:40 AM
by Teethless mama Go to last post
1 103
Average with Conditions by Curtis[_6_]
I need to a formula that will look at column c and if it contains a certain text say "dog" I want to average the price located in column H Thanks -- ce
April 10th, 2010 03:01 AM
by ozgrid.com Go to last post
3 126
Help for Medical Records sorting by Gerry St[_2_]
I know this has been queried before but unfortunately, I cannot locate it. Our office deals with medical records numbers and we often have need to sort them...
April 10th, 2010 02:30 AM
by Gerry St[_3_] Go to last post
3 130
Counting Merged Cells by Excel Ella
Is there a formula I can use to: 1. Count the number of merged cells (comprised of 3 cells) in a column AND how many of those are blank? 2. Count the number...
April 10th, 2010 01:54 AM
by FSt1 Go to last post
5 215
Formatting does not follow when copying from one cell to another by Banker
I have a cell on sheet 1 that I have added text to with some bolding, coloring of text, etc. On Sheet 2 I have a cell that I have told to copy whatever is in...
April 10th, 2010 01:11 AM
by Gord Dibben Go to last post
7 118
Excel 2007 - AVERAGEIF on rows that are non-continuous by tcbooks
I have 42 rows of data and I need to average every 3rd row if "1". I've tried a couple...
April 10th, 2010 12:40 AM
by Bob Phillips[_3_] Go to last post
2 115
SUMIF with OFFSET by Lewis Clark[_2_]
Hello I am trying to find a way to use SUMIF with OFFSET on a range of variable length. My data is organized in this manner: Each row represents one fee...
April 9th, 2010 11:43 PM
by T. Valko Go to last post
5 78
Line Feed in Formula Adds Double Quotes? by CarlT
I am trying to use a formula to create multiline text that I can copy and paste into another application. The problem is the pasted text always comes...
April 9th, 2010 10:51 PM
by julie kothari Go to last post
3 128
How to count merged cells by Excel Ella
Can someone help me in developing a formula that will: 1. Count how many merged cells in a column that are created from 2 cells AND contain both text and...
April 9th, 2010 10:28 PM
by JLatham Go to last post
2 138
How do I conditionally format only some of the text in a cell? by Goo
For example any time a cell contains the text "greater" I would like the font for the word greater to be bold but not the other text in that cell.
April 9th, 2010 07:55 PM
by Dave Peterson Go to last post
9 149
return 0 if cell has data? by kathysonisland
I feel stupid asking this question.......I just cannot figure a formula out that I know I know......... I need a formula to display 0 in a cell if another...
April 9th, 2010 07:49 PM
by Joe User[_2_] Go to last post
4 86
#VALUE error-- some cells? by roborat
I am doing a VLOOKUP moving out comments from a Pivot Table to separate column. I have 115 rows, 100 of which work perfectly... but 15 of them give me the...
April 9th, 2010 07:47 PM
by Luke M[_4_] Go to last post
3 98
Return 0 if cell has data, of copy if it doesn't by kathysonisland
This was what I needed, Thank you! But now it leads me to the next step.....(probably would be easier to just enter the $0 myself) Here is what I need: the...
April 9th, 2010 07:47 PM
by Joe User[_2_] Go to last post
2 64
sum column based on single cell match? by adodson
This seems so simple and yet the solution eludes me... In row 2 I want Excel to match a cell's contents (ex: find 3200). Once finding the column that...
April 9th, 2010 07:15 PM
by Luke M[_4_] Go to last post
1 90
Post New Thread


Display Options
Showing threads 1401 to 1420 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 03:57 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.