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
subtotal, match? by Steve
Morning all. I need to do a name check to match with a subtotal function. Is that possible? I was thinking that subtotal(Func_Num,match(....)) might handle...
(Multi-page thread 1 2)
February 17th, 2010 05:44 PM
by T. Valko Go to last post
10 124
Counting days from a date by Sunshine
in cell D5 I have the date 2/12/10...in cell D6 is blank but is assumed to be today's date...in cell D7 I need it to calculate the number of days from 2/12...
February 17th, 2010 05:35 PM
by T. Valko Go to last post
3 95
Multiple name appearances by Pat318
Have a list of 1000 names trying to sort by appearances 5. Not sure if Lookup or Hlookup?
February 17th, 2010 05:29 PM
by Glenn[_6_] Go to last post
1 189
Excel files take long time to open by Rick KH
I just upgraded to office 2007. I have files that were created in older versions of excel. Some of them contain macros and some don't. When I go to my...
February 17th, 2010 05:07 PM
by Rick KH Go to last post
0 261
how to automatically update a second worksheet when data inserted by maggiemay
I prepared a worksheet with years and names. This worksheet showed names, dates and other data (total five columns) with the names (column 2) in...
February 17th, 2010 04:23 PM
by JLatham Go to last post
2 102
multiple criteria date range by Pat318
I'm trying to countif in 2 columns 1has "O" or "MV". The other column has date ranges. So if dates 1/1/1985 -12/31/1985 "O" count how many. And do the same...
February 17th, 2010 03:47 PM
by Mike H Go to last post
4 65
Formula for unique records by Keithlearn
I am trying to make a report a little more user friendly for a novice excel user, and I am trying to use all formula's instead of pivotables on large data...
February 17th, 2010 03:47 PM
by Max Go to last post
2 78
If function with format by Khusro
=if(a10,a1,"") A1 "text" or "number" in red color I want to print the value of cell A1 in Cell B1 with its format if above condition is true. Is it possible ?
February 17th, 2010 03:46 PM
by JLatham Go to last post
1 68
Calculating working hours to complete a task by Richard
Hi all i have a team who respond to customer requests, and they record when the request came in and when it went out. I then report on how many working hours...
February 17th, 2010 03:13 PM
by Richard Go to last post
3 87
MS Word equation by qamar
How can I edit MS Word equation after pasting it in excel sheet?
February 17th, 2010 03:07 PM
by Bernard Liengme Go to last post
1 83
Pulling Data from one worksheet into another by Kate
Hi, I have a question regarding pulling text from one worksheet into another. Please can you help me? I need to duplicate the information (text only) on one...
February 17th, 2010 02:54 PM
by Bernard Liengme Go to last post
1 136
How can I assign a value to a cell without putting a formula in it by WFariss
I have one cell (C33) that has a list validation attached to it. The list (column A on a separate sheet called Data_text) is a series of text statements that...
February 17th, 2010 02:10 PM
by WFariss Go to last post
4 133
Unmoveable SUM by LiAD
Hi, I have a very simple formula =sum(A1:A100). If I highlight lines 20 to 40 and then delete the entire line the formula will update to =sum(A1:A80). Is...
February 17th, 2010 12:40 PM
by LiAD Go to last post
4 81
Delete some column headings from an autofiltered range. by Champ
I've selected a range of cells e.g. A6 to CP83 and autofiltered this range. I wish to retain the list headings for columns A to C but wish to remove the list...
February 17th, 2010 07:39 AM
by Champ Go to last post
1 108
Protecting is NOT working right !!!!!!!!!!!!!! by KSO
If you have a protected sheet in a workbook, A, and you CUT out some of the unprotected cells from A and paste them in another workbook - then the...
February 17th, 2010 07:24 AM
by KSO Go to last post
6 98
Not sure what type of formula to use by woodson87
I'm trying to find in one of my rows of my excel spreadsheet specific countries like Germany, Italy, France, etc. I need a formula that will display IF one...
February 17th, 2010 05:12 AM
by T. Valko Go to last post
2 75
if statements for multiple entries by DLB
I have a spreadsheet that has a ID number in column A and an airport identifier in column B in sheet 1. I want to return a value ("1") if the ID number and...
February 17th, 2010 04:41 AM
by T. Valko Go to last post
1 83
Find a single value from tables by selecting two variable inputs? by jj023
I am trying to have a worksheet locate a single data value based on two, variable input values. The single data value is located at the intersection of two...
February 17th, 2010 02:40 AM
by T. Valko Go to last post
8 114
COUNTING TEXT VALUES GIVEN MORE THAN ONE ARGUMENT. by JOEY
I have to count how many contracts are valid in column C according to the states listed in column A; what can I use as a formula?? Example below: columnA ...
February 17th, 2010 02:23 AM
by Beverly Go to last post
2 92
convert meters to feet/inches by Ann
i'm trying to convert from meters to feet and inches (not just feet or not just inches). so if i have 2 meters, i want the result to read 6 feet, 2 inches for...
(Multi-page thread 1 2 3)
February 17th, 2010 01:59 AM
by Dana DeLouis[_3_] Go to last post
21 306
Post New Thread


Display Options
Showing threads 2881 to 2900 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 08:20 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.