Does anyone know how to subtract from or add to the year in a given date e.g if today's date is 28 Sep 07 I would like to be able to add 1 and subtract 1 to...

Dear all: I tried searching for this in the forum using the keywords "formula, sum, addition, error" but couldn't find any relevent information, so I'm...

I assume you mean duplicate sales values. =INDEX($3:$3,INDEX(ArrayMatch($F$1,dataRange),ROW(A1),2)+COLUMN(dataRange)-1) for the customer...

I think you've overcomplicated the example, which makes it hard to reproduce; can't you articulate your problem using simply, e.g., =MATCH(JP,iRange,0) and...

Set rng = Range("A1") Range(rng(1, 1), rng(1, 4)).Select Alan Beban Terry Bell wrote: I want to select a group of 4 adjacent cells in a for-next loop and ...

To those, if any, who use the array functions in the freely downloadable file at http://home.pacbell.net/beban: I refreshed the file yesterday with changes I...

After a couple of years of neglect I have done some housekeeping on the file of Array Functions at http://home.pacbell.net/beban. I added a function for...

I have uploaded to the freely downloadable file at http://home.pacbell.net/beban some additiional procedures for handling 3-D arrays, including a function to...

I have the following question from a colleague: I like to solve the following problem. I have an RC address in one cell of the form, RC6, (current row, col...

Ben I would combine all 5 worksheets into a sixth worksheet, and then save this sheet as a csv file. I if you do have problems you can always open the...

I have up to 400 rows of data imported into a work sheet coming from a data logging device. The work sheet has functions to test each set of data which forms a...

Here is the problem: range F3:30 contain percentages range J3:J30 contain an x where certain criteria were met (win or loss say) need to say the...

How do i create an IT Statement that is a bit like =IF(j3="ABCD"or"EFGH",1,0) The cell j3 can contain a number of differnt variants of what i am trying...

i run a spreadsheet that calculates commision for sales people Column I is a product list - 40 products or so Column P is total sales value Column Z is the...

i run a spreadsheet that calculates commision for sales people Column I is a product list Column P is total sales value Column Z is the name of a sales...

I've a spreadseeht that calcualtes commission payments based on different products It uses validated lists for some data entry and then looksup the...

I want to use an IF statment in a spreadsheet as follows Column I cells are Validated as Lists for input Column K is a value that is associated with Column...

i am using a workbook to calculate commission payments one worksheet contains info on the sale made: Name of customer/date/product/rental/term of rental/total...

Can someone help me please ? I am manipulating a large spreadsheet where I have to enter invoice numbers. I often enter invoice numbers that already exist...