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
multiple worksheets by chieflx
Hi, I wonder if anyone might be able to give me a bit of advice. I have several worksheets containing observation data from different days, all contained in...
March 20th, 2010 03:39 AM
by Pete_UK Go to last post
3 75
Moving Cell Formula by iamjbunni
I have a spreadsheet with a summary page and several worksheets following. My formula calculates from a column of data that is updating with new information...
March 20th, 2010 01:19 AM
by Gord Dibben Go to last post
1 65
Vlookup problem by tpocccfo
I am having a problem with a vlookup fromula returning an #N/A value when using a cell with another vlookup formula as the lookup_ value. I created this same...
March 20th, 2010 01:01 AM
by L. Howard Kittle Go to last post
2 78
Making an excel sheet so formulas can not be deleted in the sum to by Dan
Making an excel sheet so formulas can not be deleted in the sum total yet in the other cells used to add up to the sum total cell a numer can be added. I...
March 20th, 2010 12:30 AM
by cadustin Go to last post
2 80
sumproduct with 4 conditions by EXCELably Challenged[_2_]
i need to have a single formula that will count the number of times 4 different conditions are met. I 2 types of members, in 3 different markets. i need to...
March 19th, 2010 11:46 PM
by Fred Smith[_4_] Go to last post
1 63
Excel 2007 Countifs macro with multiple criteria (OR) by Tapani Mikkola
Been working on this reporting macro for excel 2007. Cant figure out how to make countifs work for many possible values in one cell. I have report with...
March 19th, 2010 11:45 PM
by Herbert Seidenberg Go to last post
2 84
AVERAGE last 4 Mondays? by Ted[_15_]
I hope I am not coming to the well too often but the help people provide here is incredible. I have a data sheet that will not be seen by users. They input...
March 19th, 2010 11:25 PM
by Mike H Go to last post
1 70
Is there a function that counts distinct number od records in a ra by Ayo
I am looking for a way to tell how many distinct values are in a range. For example, say I have values in Range A5:A2000 and I want to know of those 1995...
March 19th, 2010 10:01 PM
by Mike H Go to last post
3 101
Vlookup with variable column reference by jenVBA
Help! I am trying to link two workbooks with a vlookup that searches for the last populated columns' entry in a range (see example...
March 19th, 2010 09:57 PM
by Paul C Go to last post
1 74
Protect cell but allow copy command? by Melissa
Does this work the same way in 07? I have tried it several times. However, it will not allow me to copy and insert a row without entering the...
March 19th, 2010 09:49 PM
by Melissa Go to last post
0 134
Protect cell but allow copy command? by Melissa
"Jay" wrote: Yes, go to the cell right click and select format cells from the pop-up menu. Then go the very last right tab and place a check mark in...
March 19th, 2010 09:47 PM
by Melissa Go to last post
0 74
Multiple functions by Debbie
I am attempting to use a combination of "IF" and "IS" statments to solve for multiple scenarios. For example, I need the following to be solved with the IF...
March 19th, 2010 09:33 PM
by Debbie Go to last post
2 71
No Balance Owed Flag Help! by Danny Boy
Trying to resolve this formula to work appropritely in cell E7: =SUM(E2:E6),IF(E2:E6=0,"No Balance Owed") In other words, all currency outcomes are totaled...
March 19th, 2010 09:31 PM
by Danny Boy Go to last post
2 58
IF INDEX and MATCH function together by cadustin
Okay, now that I had the other figured out, I am told there is more I need. I need a formula that tells me to look at one place IF my criteria is met,...
March 19th, 2010 09:24 PM
by Gord Dibben Go to last post
5 94
Row Height or Column Width not Showing by Brian
When I left click on the row it use to give me the row height and now for some reason I can't see that anymore. I have to right click and select the row...
March 19th, 2010 09:18 PM
by Gord Dibben Go to last post
1 71
If then between two dates by BBD
I am trying to distribute revenue evenly between two dates. I have in one cell the beginning of the project. I have in another cell the end of the project....
March 19th, 2010 09:18 PM
by T. Valko Go to last post
1 69
what does the size 1/72 means by Vin_microsoft
trying to find out if appies font or point
March 19th, 2010 08:50 PM
by macropod[_2_] Go to last post
2 77
Monday closest to today's date? by Ted[_15_]
Hello: I am seeking a formula that would return the date of the closest Monday to today's date. The monday would have to be the first one in the future, not...
March 19th, 2010 08:41 PM
by Ron Rosenfeld Go to last post
6 77
Recurring header. by Col Phil
I did an Excel worksheet and placed a header on it. When it printed, it automatically did column headers (A,B,C,D). The header and column headers now print...
March 19th, 2010 08:01 PM
by Luke M[_4_] Go to last post
1 91
Vlookup with If condition by Biff
I meant this to go under Excel Worksheet Function. My apologizes for the repeat. A1 A2 A3 1 3 4 2 5 6 3 6 3 4 7 8 5 ...
March 19th, 2010 08:01 PM
by Luke M[_4_] Go to last post
1 72
Post New Thread


Display Options
Showing threads 1961 to 1980 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 07:59 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.