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
Is there a way to use a multiple column array in SUMPRODUCT? by rk
I am attempting to use SUMPRODUCT to pull values froma multiple column spreadsheet and add them together. I am able to get the SUMPRODUCT to work if I am...
March 15th, 2010 11:34 PM
by Teethless mama Go to last post
2 150
Index/Lookup Function? by jackie
Hi All- I need help returning a list of names on a separate sheet. I'll enter "manager 1" in an input cell, and i want to return a list of corresponding...
March 15th, 2010 11:25 PM
by Max Go to last post
4 189
Replace Function that uses lookup table? by msnyc07
I have a large (50k+records) spreadsheet I've been 'cleaning' using some basic cell functions that look for specific strings and then remove or substitute,...
March 15th, 2010 11:05 PM
by Eva Go to last post
1 188
EXCEL COUNTING HELP by EXCELably Challenged
I need to count the number of occurances of a date range from a column of dates spanning from December 1, 2009 - March 15, 2010. (how many dates in column C...
March 15th, 2010 10:26 PM
by Bernd P Go to last post
3 144
cube functions by Robert
Hello everyone, in Excel 2007 we have the new cube functions described in this blog for...
March 15th, 2010 10:16 PM
by Robert Go to last post
0 186
OFFSET and LOOKUP Error by Jim
I'm using Excel 2007 I'm using this formula in cell F11 to lookup a payment amount, which works fine. =HLOOKUP($I$3,Mortgage_Pay_Table,A11+2) In Cell E11 I...
March 15th, 2010 09:42 PM
by Glenn[_6_] Go to last post
2 149
how to sum cells and ignore the #div/0! 's ? by Bryan
I an working with the following formula: =SUM(C8:E8)/COUNTIF(C8:E8,"0") if I initially have no data entered i get the #div/0! 's is there a fix for this?
March 15th, 2010 08:43 PM
by Teethless mama Go to last post
3 179
Counting independent items in a list by Brad E.
This formula is meant to count independent entries in A1:A20. =ROUND(SUMPRODUCT(1/COUNTIF(A1:A20,A1:A20)),0) Can anyone make this better? I am not talking...
March 15th, 2010 08:39 PM
by Mike H Go to last post
3 159
Dynamically Adding Textbox To Frame by sarndt
How do I add a textbox control to a frame object (declared as OLEObject) in vba code behind a worksheet? For example, I have tried the following that doesn't...
March 15th, 2010 07:19 PM
by sarndt Go to last post
0 153
Get location of match in another worksheet by AZSteve
"Workbook A/worksheet A" contains a reference cell with a date (formatted date number). I need a formula for this worksheet that gives the cell address in...
March 15th, 2010 06:01 PM
by AZSteve Go to last post
0 120
left/right or center ? by Steve
I have days off in the P column in this format: Sat/Sun I'm using them in another column in this format SatSun, so I'm using this...
(Multi-page thread 1 2)
March 15th, 2010 05:30 PM
by Steve Go to last post
13 459
Cells Fill Automatically on Another Workbook by BrazosJoe
I've created what we'll call a seed worksheet to be used over and over for different clients. I have linked its cells to another workbook. As the originating...
March 15th, 2010 05:18 PM
by BrazosJoe Go to last post
0 152
Setting special format for a cell by Ruslan
Dear All, Could you please tell me how can I can set special format to a column? To be precise, I'd like to set such a format to the column of cells that it...
March 15th, 2010 05:02 PM
by Gord Dibben Go to last post
6 172
Summarizing up cells based on two different criterias by Ruslan
Dear All, I have the following table: No. Hours Price/m² Price/hr Total price Total m² 20140 8,50 0,08 20 170,00 € 2125,00 20140 9,15 0,08 20 183,00...
March 15th, 2010 03:58 PM
by Glenn[_6_] Go to last post
4 244
Problem with LARGE function by mickjjuk
I am trying to sum the best 2 scores from a total of 4 scores using the LARGE function. the 4 scores are immediately above the cell containing the function....
March 15th, 2010 03:31 PM
by Ashish Mathur[_2_] Go to last post
3 146
Determining number of entries in a table by smaruzzi
I want to dynamically calculate the number of entries in a list of text strings. Surprisingly COUNTA returns a number not corresponding to the actual number...
March 15th, 2010 02:04 PM
by Ashish Mathur[_2_] Go to last post
3 167
Autofill from Data Validation by JPDS
I have a list of staff in sheet 1, along with where they work in the company i.e. their geographic location, their department name, their section and their...
March 15th, 2010 12:56 PM
by JPDS Go to last post
2 153
ms excel by vinay
how to change uppercase to lowercase in ms excel
March 15th, 2010 12:14 PM
by Mike H Go to last post
1 146
Index from TM by Dave
Hi, Looking at an answer from Teethless Mama to someone else's question, raised yet another question. (what a surprise) The formula was:...
March 15th, 2010 08:01 AM
by T. Valko Go to last post
8 252
Starting drop down lists at the top by test123
I have several drop down lists on sheet 1 where the data sets are on sheet 2. Some of my drop down lists start at the first entry and others start at the...
March 15th, 2010 06:46 AM
by Héctor Miguel Go to last post
1 139
Post New Thread


Display Options
Showing threads 2121 to 2140 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 10: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.