Worksheet Functions - Page 1117

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.

Thread / Thread Starter	Last Post	Replies	Views
How can I filter just 2 columns (separated by another column)? by theglove33 Hi. Does anyone know how to filter just two columns? For example, I want to filter column B and column D only. No other columns. Thoughts? TIA	July 29th, 2008 07:15 PM by Gord Dibben	2	79
What would I set up this formula by Karen I want to get the totals of several cells but not use any negative numbers; plus I want to round up the currency to the nearest 2nd number would this work...	July 29th, 2008 07:02 PM by David Biddulph	4	64
#VALUE! error message in simple sum function by Sandog I am getting a weird error message doing the simplest sum function. I have a column with 10 filled cells, I7-I16. In a cell below that I enter...	July 29th, 2008 06:59 PM by Sandog	4	119
Adding sums from different worksheets by laurabell I am designing a yearly sales pipeline report. Each worksheet is a different month. How do I create a running YTD total of previous months sales totals to...	July 29th, 2008 06:36 PM by Gord Dibben	2	73
Is it possible to filter using row height in Excel by xBRITO to filter out rows of a particular or less than height	July 29th, 2008 06:31 PM by Gord Dibben	2	83
Still need help with IF and Count Function by Vicki I tried the formulas... ( 1 2)	July 29th, 2008 06:25 PM by T. Valko	11	103
find the cells that represent a code in one cell by shane I have assigned occupational codes to job titles. One code can refer to more than one job title. I want to be able to list all the job titles = to an occ...	July 29th, 2008 06:21 PM by Gord Dibben	1	79
How do I use a variable as a reference to an array in INDEX by Steve Haack I want to use the INDEX function to lookup data in an array. I have several ranges defined as tables, and have named them tblScottsScores, tblStevesScores,...	July 29th, 2008 06:16 PM by T. Valko	6	82
Hyperlinking to Excel and the resulting cell shading displayed. by Bamos101 With Excel 2007, when I hyperlink to a cell, group of cells, or data range in an excel S/S and then execute this link, the shading of the cells linked to is...	July 29th, 2008 06:15 PM by Bamos101	0	75
Alphanumeric by hardeep via OfficeKB.com Dear sir I have list of 15000 of Alphanumeric data for ex. ADEDO125ADSD589ADF121, UIEIROIWS12556ERE545,ADAS15455212AD4564AD2 And so on. Now I want to extract... ( 1 2 3)	July 29th, 2008 06:12 PM by T. Valko	22	250
XL2002 - VLOOKUP with variable Sheet Name by Trevor Williams Hi All I am trying to create a formula to look up data on a sheet that has a variable sheet name. Here's the current...	July 29th, 2008 05:33 PM by Pete_UK	3	95
Autofilter with pivot table by InÃ¨s I would like to create an autofilter on a table, but without the usual autofilter mode. I would like it to be as a pivot table, with the "pages fields" on...	July 29th, 2008 05:31 PM by InÃ¨s	0	60
Write a formula using two arrays, across two worksheets by Susan What I want to do is write a formula that will gather information from one column in a different worksheet (same workbook) based on a condition, then using... ( 1 2)	July 29th, 2008 05:30 PM by David Biddulph	11	141
IF function by Rebecca I have an if function that relies on dates... the formula works every time unless the value is = 0 .. then it displays -1.13687E-13 as the value... how can i...	July 29th, 2008 04:29 PM by David Biddulph	4	116
Multiple If Statements in the same cell by JBarsema I am building a spreadsheet to display all documents I have sent someone. In cell A1, I have created a drop-down list of households, and now in column B, I...	July 29th, 2008 04:21 PM by ryguy7272	2	74
Adding Rows by leimst Hi, Is there a good way to add rows to a spreadsheet and keep all formulas and conditional formatting? I converted a range to a "list" so that it is now...	July 29th, 2008 04:19 PM by ryguy7272	2	68
"IF" Condition by shafali I want to add a long "IF" condition in a macro but its giving me error "unable to...	July 29th, 2008 04:04 PM by PCLIVE	1	51
How can I calculate total spend on items that have different values by [email protected] I want to use a formular to calculate the total spent on a item in a list and the total made from selling an item in a list. The item quanaties varey as do...	July 29th, 2008 04:01 PM by John C[_2_]	1	123
INDEX / MATCH with SUMIF/COUNTIF/SUMPRODUCT Statements? by Ronny Hamida Hi there! I have formulas like this in a... ( 1 2)	July 29th, 2008 03:50 PM by Pinto G[_2_]	10	511
Formula being replaced by =#N/A by Scopar Hi, I have a spreadsheet saved on a server at work. It has multiple tabs one of which is a summary tab containing various formulas to summarise data. Over...	July 29th, 2008 03:40 PM by VoxBox-Richard	1	96

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed