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
Counting for frequency by Roxana[_2_]
How can I count the frequency a piece of data occurs in an array? I am trying to determine if a a set of data repeats itself and how many times it repeats...
May 5th, 2010 03:53 PM
by Joe User[_2_] Go to last post
2 130
How to insert Checkbox in excel to simply click and tick it? by Keegan
I just wanted to know how I can create a Check Box in Excel where I can simply chick the box and it gets Ticked.
May 5th, 2010 03:21 PM
by Bob Umlas, Excel MVP Go to last post
3 209
Password protect cells by Christobo
I would like to protect six to ten cells within excel. But the cell protected by one can ont be accessed by another, i.e. - I need to allow for multiple uses...
May 5th, 2010 02:34 PM
by Dave Peterson Go to last post
9 204
SumIf AND by NoodNutt
Hi everyone I use the SumIF() usually to great effect, but this one has the grey matter throbbing. =SUMIF(Data!$P:P,"On Time",Data!O:O) This returns the...
May 5th, 2010 02:26 PM
by Fred Smith[_4_] Go to last post
6 166
count similar text with using filters by mj
I want to count the number of occourances of a "Y" in coulumn D .. so i used a countif and it works great however when i filter another column it still...
May 5th, 2010 02:05 PM
by Eduardo Go to last post
1 137
Match - not sure how to use this function by Luvable Lady
I have created a Validation List called Suppliers, and then once I have picked a supplier I want it to pull over the correct Account Code. An example of the...
May 5th, 2010 01:37 PM
by Bob Phillips[_3_] Go to last post
3 112
Help with SUMPRODUCT & converting date to value by jrproudfoot
I have the following Excel calculation, shown below. It is searching cells A6:A1000 on various sheets for data which fall between a certain date/period...
May 5th, 2010 01:35 PM
by Bob Phillips[_3_] Go to last post
1 117
Using wildcard characters in find & replace by Tola
How do I change a range of Formula linked to 3 other files ? Example: Cell...
May 5th, 2010 12:31 PM
by Tola Go to last post
3 293
activate formula when adjacent cell populated by Simon
Dear All, I have copied a simple formula (A1+1095) down the length of column B (working with excel 2003). A1 contains a date, the formular in column B...
May 5th, 2010 12:00 PM
by Arvi Laanemets Go to last post
4 180
About Data Validation by moonhkt
Hi All I have excel worksheet using Data Validation for control input Value. In the raw data sheet, Define some Name e.g. "DBNAME", AREA","TABLE Name"...
May 5th, 2010 08:33 AM
by Roger Govier[_8_] Go to last post
2 164
formula for month that is prior to actual by GoBonnieGo
I saw a question with this title on here and it's exactly what I want... but the answer is too technical for me and I'm wondering if someone can simplify it....
May 5th, 2010 06:31 AM
by [email protected] Go to last post
6 116
inventory by Gary
can you make a sum a text insted of a number
May 5th, 2010 04:33 AM
by ozgrid.com Go to last post
2 188
Regression Formula by Abby
I'm trying to understand the Regression function- would someone be able to explain the steps to calculate Regression and the info the formula generates?...
May 5th, 2010 01:59 AM
by Mike Middleton[_2_] Go to last post
1 97
Counting results of a formula by Nadine
I have a column that has about 111 rows to it. In each row is a formula that will find an invoice number if it exists elsewhere. The are alpha-numeric...
May 5th, 2010 01:07 AM
by Nadine Go to last post
9 183
make a check form, and then have info go to a check register by richie g
make a form that looks like a check, then add all information in the check and have the information go to a check register on next sheet
May 5th, 2010 12:10 AM
by richie g Go to last post
0 87
Count blanks by date by Molasses26
I have a table that has meter# , date, and usage in colums A, B and C. I use a formula =sumif($B$11:$B1000,"=",$C$11:$C1000) to total up the amount of usage...
May 5th, 2010 12:09 AM
by Max Go to last post
2 96
In Excel need to have a sub worksheet inserted into each row by RT
I seem to recall that you can press on a + sign in the row number and this then opens up a sub worksheet within. What I have is a number of companies which I...
May 4th, 2010 11:58 PM
by Dave Peterson Go to last post
2 110
lookup? by Mezani
I am trying to enter data in sheet 1, that is dependant on drop down lists that are on sheet 2, which is looking through named ranges on sheet 3. Is lookup...
May 4th, 2010 11:31 PM
by Bob Phillips[_3_] Go to last post
1 77
set flashing alarm by a date for a text box by In a quandary always
For example, I want to set an alarm that flashes my car bill entry a week before it is actually due. Thank you!
May 4th, 2010 11:04 PM
by Tom Hutchins Go to last post
1 147
LOOKUP formula when term may not be present by MichaelRobert
How can I get LOOKUP to return a 'blank' value when a term is not found in the Lookup arrray? At present, what is being returned is the next alphabetical...
May 4th, 2010 10:35 PM
by Niek Otten Go to last post
1 91
Post New Thread


Display Options
Showing threads 781 to 800 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 12:26 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.