A Microsoft Excel forum. ExcelBanter

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 » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
extract list of names and elimanate duplicates by Frank Kabel
Hi use a pivot table for this....
October 27th 04 04:52 PM
by petty Go to last post
2 1,776
sumif 2 criteria by Doug
This is probably very simple but I am having problem writing the sumif formuala. The range I want to add up is AJ99:Aj3467 if f36 = d99:d3467 and if g36 =...
October 27th 04 05:06 PM
by JulieD Go to last post
1 1,882
lookup combine vlookup with hlookup by Doug
I want to search in a table for a specific value. I have a table with item numbers in column A going down rows 10:200 and the customers names going across the...
October 27th 04 05:10 PM
by JulieD Go to last post
1 8,072
Count cells with the red color by Collcat
Hi, I'd like to be able to count all the cells that are red (I made them red, not conditional formatting) in my spreadsheet. How can I achive that? Thanks in...
October 27th 04 05:26 PM
by Frank Kabel Go to last post
1 2,117
index to a range of cells by Frank Kabel
Hi this is something you can't achieve in Excel with formulas. You need a kind of unique key for referencing (much easier to achieve in a database). So you...
October 27th 04 05:39 PM
by Frank Kabel Go to last post
0 1,825
Pasting onto filtered cells by Mediaexcel
Hello, I seached for this but could not find any solution in the forums. I have filtered unique records in place and now I want to paste data adjacent to...
October 27th 04 05:44 PM
by Frank Kabel Go to last post
1 1,634
To me this is huge, need some assistance by craigwojo
Just looking for some help on the timing sections, from above post. Thank...
October 27th 04 05:52 PM
by craigwojo Go to last post
0 1,531
Using the Indirect.Ext function by henryhbb
I keep trying to use this function and it gives me an error even if the source workbook is open or closed. I have a reference in a cell that pulls the cell...
October 27th 04 05:56 PM
by Frank Kabel Go to last post
1 1,885
Average Range by Stndt
Does Excel (2003)have a way to calculate Average Range? My problem is: B2:M2 is avg. low price for the year in months D2:M2 is avg. high price in C2 to M2 I'd...
October 27th 04 06:00 PM
by Stndt Go to last post
0 1,537
average of everytwo rows? by Myrna Larson
Are you saying that you have blanks within the data? Can you repeat what the layout is? What are the columns and what's in each? For each group of 3 rows, the...
October 27th 04 06:42 PM
by Myrna Larson Go to last post
0 1,464
Help!! What formula do I use? by HL
I have two columns in my worksheet. In column A I have the last name and in column B I have "active" or "inactive" Example: Column A Column B Johnson ...
October 27th 04 06:45 PM
by HL Go to last post
5 1,521
Add months and adding partial monhts by Adam C
Hi - When I need to add a month, to a date. I use - =DATE(YEAR(B27),MONTH(B27)+S21,MIN(DAY(B27),DAY(DATE(YEAR(B27),MONTH(B27)+S22,0)))) However, I...
October 27th 04 06:53 PM
by Ron Rosenfeld Go to last post
2 4,079
copy worksheet ... formulas do not update by Datasort
I am coping a worksheet (in the same workbook) and then renaming the sheet all in vba code. There are formulas on the source sheet, and copied sheet, that...
October 27th 04 07:01 PM
by Frank Kabel Go to last post
1 2,158
Need to sum values of columns 1 - 13 and 4 - 15 by ExcelHelp
I have many rows of data and need to sum values in the first 13 columns (col 1 - 13) and starting from the column a value first appears. For example a value...
October 27th 04 07:03 PM
by Frank Kabel Go to last post
1 1,962
Can anyone suggest me ways to simultaneously sort and match multiple colums . The multiple columns mostly similar values with few dissimilar ones. I need to...
October 27th 04 07:03 PM
by Frank Kabel Go to last post
2 2,790
Count cells with the red color by Collcat
Thanks for the links. I have ben trying : *=SUMPRODUCT(--(ColorIndex(A1:A100)=3))* (from xldynamic) But I get *#NAME?* as a response in my cell. What am I...
October 27th 04 07:04 PM
by Frank Kabel Go to last post
1 1,526
Get cell value from 2 lists by cybersteve
Biff - that's why I posted the question here in the first place, as I tried a number of things and nothing worked. If anyone can help me I would appreciate...
October 27th 04 07:08 PM
by Biff Go to last post
1 1,548
MIN >0 by Neil
How do I get this to tell me when column B MIN >0 =INDEX(A2:A367,MATCH(MIN(B2:B367),B2:B367,0))
October 27th 04 07:46 PM
by Myrna Larson Go to last post
4 1,215
How do I create a column that has a 'drop box' by Dave Simons
I would like to create a spreadsheet that contains a 'drop box' feature in certain cells that allow the user to choose from a pre-described list of values. How...
October 27th 04 07:57 PM
by Frank Kabel Go to last post
1 1,379
index match and sum by Pamela
Hello All, I have a listing of product orders in a workbook. In another workbook I want to find the product, and sum the quantity of orders I have for...
October 27th 04 08:10 PM
by Pamela Go to last post
4 2,940
Post New Thread

Display Options
Showing threads 1 to 20 of 88524
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 On
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 10:08 AM.

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