Functions

Average If
Is it possible to compute an average given a criteria. For example, I have some data like this: 30 Day High30 Day Vol 267.22 46.11 79.24 35.29 26.24 68.58 42.39 58.24 53.94 48.04 70.70 34.96 151.13 41.55 32.77 23.85 30.87 27.88 I wanted to compute an average of ColB if ColA was equal to or greater tha... 4 Jun 2010 10:21

Large list of numbers to concatenate
I have a list of 600+ zip codes that are curently in individual cells. I need to turn them into one list separated by commas. Is this possible? The best solution I can think of is =concatenate(A1, ", ",B1) However, is there a way to automate this instead of individually typing this in for all 600+ cells? ... 3 Jun 2010 19:03

SumIf and vlookup formula help
I have 5 categories that I need to sum but it is on another tab. I can't remember how to use the Sumif and vlookup formula together. Product A = 100 Product A = 100 Product A = 300 a vlookup will only give me the first hit but I need all three totals for product A so Product A = $500 instead of the first o... 4 Jun 2010 05:56

Simple hack to get $500 to your home.
Simple hack to get $500 to your home at http://uslatest.tk Due to high security risks,i have hidden the cheque link in an image. in that website on left side below search box, click on image and enter your name and address where you want to receive your cheque.please dont tell to anyone. ... 3 Jun 2010 12:18

Function to concatenate cells in a range
Does anyone have an elegant way of concatenating a series of cells? I think the answer will be a user defined function which will be equivalent to MULTICONCAT(start cell : end cell). I think it needs to be a function rather than a macro, so that I can include it in formulae elsewhere in the workbook. I can m... 3 Jun 2010 19:03

Function help please.
I am a teacher and have an excel spreadsheet (2003) with student's marks in various columns. Each column represents a quiz/exam/OP or assignment and they are all out of different totals. I need to know how to: 1) reduce each column to it's percentage value (example to follow) and, 2) to sum up totals from each ... 3 Jun 2010 12:18

Count "," in a cell
Dear expert, Is it possible to count "," in a cell please? I used this ... but does not work =COUNTIF(FO93,",") Say below ... can it be solved? 2,5,3 22,25,5 5,2,3,4 ... 3 Jun 2010 07:51

VLOOKUP returns incorrect data
I am using VLOOKUP to determine addresses from a master list. However I have found that if the Lookup Value is NOT in the Table Array, I will get incorrect information. For example if the Table Array has entries for Schmidt and Schultz, and I attempt to lookup Schnell (which is not in the Table Array), I will... 3 Jun 2010 07:51

Transpose link
Stand in cell A1, enter "=C1"uses the "drag link cell" in the down right corner of a cell. I will automaticly link A1 - C1 A2 - C2 A3 - C3 ect My question is if it is possible to drag horisonal and link vertically??? A1 - C1 A2 - D1 A3 - E1 -- Message posted via OfficeKB.com http://www.officekb.com/U... 3 Jun 2010 07:51

How can I insert a date which is the first date of the following m
Hi, How can I insert a date which is the first date of the following month of a given date. For example, I have a number of dates and I need to put the 1st date of the following month. Can I do it using excel formula? or will I have to inset the 1st date of the following month manually? Muhasenul Haque "A... 3 Jun 2010 05:40