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
How do I open qpw file with office 2007? by Kranz
I am now using windows 7 operating system and have some files saved in qpw format. I have windows home office and student as my program. How can i open...
February 14th, 2010 10:02 PM
by David Biddulph Go to last post
1 87
Vlookup of specific text, then in consecutive rows by Steve
I'd like to have vlookup return a name if a cell contains the word relief. And also in consecutive rows. Meaning the word *relief* may be in e.g. 20 cells in...
February 14th, 2010 09:59 PM
by zvkmpw Go to last post
9 155
Formulas by formulaconfusion
How do I create a formula for this? Multiply the base value in cell B6 times 100% plus the value in cell C4. Place the second expression in parentheses so...
February 14th, 2010 09:47 PM
by formulaconfusion Go to last post
5 122
VBC 'Contains' Check by msnyc07
Apologies gain, still trying to hack this coders VBA as a non-coder so I can fix as he is AWOL. Anyway part of the code was supposed to see if a cell...
February 14th, 2010 04:22 PM
by Don Guillett[_2_] Go to last post
2 77
Write a formula for a penalty for status of TRUE? by Esperanza
Need to write a formula in column H for a penalty of $50 for the customer that has a fixed penalty status of TRUE and $) for all others
February 14th, 2010 02:08 PM
by Fred Smith[_4_] Go to last post
4 131
LookUp Function by KAL64
I have values (V1) in one column (Sheet1!A1:A200) that I need to search for in multiple columns in another worksheet (Sheet2!B thru Sheet2!x). Once V1 is...
February 14th, 2010 12:59 PM
by Bernd P Go to last post
6 166
How do I calculate Track and Distance from two sets of coordinate by Ant
I have a table of place names and gps coordinates. Via drop down boxes and vlookup, a user can select a start point and destination. I would like excel to...
February 14th, 2010 04:10 AM
by Ant Go to last post
2 204
Check for # of Words in Function by msnyc07
Apologies in advance, I am NOT a coder, I am trying to fix VBA someone wrote for me by 'slogging' through it on my own. Making some decent headway on easier...
February 14th, 2010 03:03 AM
by msnyc07 Go to last post
2 90
Write a Formula by Esperanza
How do I write a formula for penalty on past due accounts with great than or equal to 1000 but less than 5000, apply a penalty of $100. For accounts with a...
February 13th, 2010 11:11 PM
by Joe User[_2_] Go to last post
2 108
Duplicate value address search - apologies for cross post by Bony Pony[_3_]
Hi everyone, 21:00 on a Saturday night and I'm struggling with this! I have textual data in cells C158:L177 Unfortunately these are not all unique values...
February 13th, 2010 10:02 PM
by Bony Pony[_3_] Go to last post
0 77
How do I have excel highlight days before & after a date on a cale by Moovysheek
How do have excel highlight 15 days prior to a chosen date on the calendar below & 30 days...
February 13th, 2010 07:35 PM
by Don Guillett[_2_] Go to last post
2 79
Trying to get a blank cell presented if B26=0 by dennis
IF B26=0, how do I present a blank cell in another place, or put an amount if not true. I have used =IF(B26=0,0,Sheet1!E2) , but I get a $0.00 figure...
February 13th, 2010 06:32 PM
by Joe User[_2_] Go to last post
4 79
Restrict Number of Columns by xxx
How do i restrict my worksheet to 20 rows & 20 columns.
February 13th, 2010 06:30 PM
by Gord Dibben Go to last post
2 85
Sum Data if Column B = Q by Seanie
I wish to sum all data in Sheet2 Column J, if the value in Sheet2 Column B = The value in Sheet1 Column A I've tried...
February 13th, 2010 04:44 PM
by Teethless mama Go to last post
3 86
Comparing 3 columns? by cthompson17
How do I compare a value in one cell, to a value in a column, that looks at the value in the adjacent column, to display in a cell? For example: cell A1 =...
February 13th, 2010 03:01 PM
by Fred Smith[_4_] Go to last post
5 79
Rolling average by afdmello
Gentlemen, I have been assigned a new task, to make a score card for Key Performance Indicators. I have asked the concerned departments for the data. Now...
February 13th, 2010 02:48 PM
by afdmello Go to last post
2 133
LOOKUP VALUE OCCURS ONCE IN TABLE ARRAY - RETURN LAST OCCURRENCE by robzrob
Hello All Writing this workbook in 2007, but it will be used in 2003. Have searched but can't find answer to this. I have a 5-column (A to E) table array...
February 13th, 2010 09:30 AM
by [email protected] Go to last post
6 108
What function need to be used by Khaleel
I am preparing a mark sheet in which i have columns for year, month and subjects. In rows I am inserting names of students for year and month. Now I am...
February 13th, 2010 08:48 AM
by Khaleel Go to last post
0 59
Match second occurance of value by John
I am trying to match the second time a value occurs in a horizontal range. This formula sometimes works and other times does not.... the value I am...
February 13th, 2010 02:21 AM
by T. Valko Go to last post
6 79
AVERAGE - Disregard zero and numbers over 60? by Ted[_15_]
I need to compute averages of several rows of numbers. Every cell contains a number. None are negative. I want the average to disregard '0' and any number...
February 13th, 2010 02:15 AM
by Ted[_15_] Go to last post
3 130
Post New Thread


Display Options
Showing threads 2961 to 2980 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:47 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.