Email:      Pass:    Pass?

E-mail:

# Loops And Counters

Half the battle with this one is in describing the problem . . .

If someone could help with getting me started; I’d like to know how to use a loop counter (For-Next) in conjunction with a second counter that adjusts the integer on each loop. I'm hoping that describes the problem but, if not, maybe this explains it better:

I have many columns of data – only three rows high - containing all kinds of combinations of numerics.

Initially, I’m looping though to find the first occurrence of a particular combination:

Row1 = 2.2
Row2 = 3.4
Row3 = 4.6
(When I find that combination I copy, transpose and write it to another sheet. I can do that part.)

Next loop ‘round I want to ignore the above – as I already have the first occurrence of that sequence – and instead find the first occurrence of:
Row1 = 2.1
Row2 = 3.4
Row3 = 4.6

And after that:
Row1 = 2.0
Row2 = 3.4
Row3 = 4.6

Finally – here’s the painful part – I want another loop to do similar things with the second number. For example:
Row1 = 2.2
Row2 = 4.0
Row3 = 4.6
But I’ll worry about that part later . . .

Any guidance - especially on the first stage with a loping counter and a variable counter - very gratefully received!

Cheers.

## Similar Excel Tutorials

Excel Macro that Searches Entire Workbook and Returns All Matches
- This is the ultimate Lookup Macro for Excel. It will search every worksheet in the workbook and return all of the mat
Vlookup Macro to Return All Matching Results from a Sheet in Excel
- This Excel Macro works like a better Vlookup function because it returns ALL of the matching results. Run the
Delete Duplicate Rows
- This macro will delete rows that appear twice in a list or worksheet. If two cells are identical, this macro will delete
Vlookup Macro to Return All Matching Results and Stack them with Previous Results
- This is very similar to the other Vlookup type Macro in that it returns all of the results that match a particular se
Excel Macro to Save a Specific Worksheet as a New File
- This Excel Macro allows you to save a specific worksheet within the Excel Workbook to its own new file. You will be a

## Similar Topics

I have a problem that is likely very simple, but which has stumped me. I have a list of values that look like the following:

Row1 Col1 Value
Row1 Col2 Value
Row1 Col3 Value
Row1 Col4 Value
Row2 Col1 Value
Row2 Col2 Value
Row2 Col3 Value
Row2 Col4 Value
Row3 Col1 Value
Row3 Col2 Value
etc.

What I really want is:
...........Col1...Col2...Col3...Col4
Row1 Value Value Value Value
Row2 Value Value Value Value
Row3 Value Value Value Value
Row4 Value Value Value Value
etc.

Is there any easy way to do this easily? Sometimes I have up to 500 rows and columns, so manual cut-and-paste is out of the question. Thanks in advance for any assistance.

Hi,

I am trying to see if I can do the following in Excel......

Column A
Row1 5/09/2008 8:28
Row2 5/09/2008 8:28
Row3 5/09/2008 8:28
Row4 5/09/2008 8:28

Column B
Row1 is empty
Row2 is empty
Row3 RWLU214846
Row4 RWTU9711617

Column C
Row1 RWTU9627105
Row2 CRXU0778382
Row3 is empty
Row4 is empty

Column D
Row1 5/09/2008 8:48
Row2 5/09/2008 8:48
Row3 5/09/2008 8:48
Row4 5/09/2008 8:48

Column E
Row1 VSW640
Row2 VSW640
Row3 VSW640
Row4 VSW640

Column F
Row1 5814851
Row2 5814851
Row3 5814851
Row4 5814851

I am after a formula that will give the following results in Column H, I

The above data may be 200 or more rows, with different data, but most times there will be 2, 3 or 4 rows, with data in Column F being identical. This is the reference point.

Take Column D from Column A result Column H, ie in this case 00:20 minutes

As there are 4 rows that have an identical number in Column F, count the cells in Columns B & C that fall in the same 4 rows that have data in, result in Column I. ie in this case 4

Any Help appreciated

Cfer

Hi,

I have the following cell formula:

Code:

```=IF(AND(D1=D2, C1=C2, B1B2, E1E2), TRUE, FALSE)
```

Which checks two rows to meet the above conditions.

Now I want to write a code where every row in the worksheet is compared to all rows in the worksheet for the above conditions.

So row1 with row2, row3, row4...
then row2 with row1, row3, row4...
then row3 with row1, row2, row4...

cheers
Tobi

Hi Guys,

I have been trying to sort a two-dimensional array in excel using VBA.
the values of the array are all strings not numbers, which has been causing my head to explode.

I have an excel sheet that contains data 4 rows by 4 columns.
I then want to put that data in to an array so I can use it.

This is the first time I have been playing with 2D Arrays in VBA. From what I gathered this is how it should look:

Code:

```    Dim MyArray(1 To 4, 1 To 4)
MyArray(1, 1) = "A col1 row1"
MyArray(1, 2) = "C col1  row2"
MyArray(1, 3) = "D col1  row3"
MyArray(1, 4) = "B col1  row4"
MyArray(2, 1) = "D col2  row1 - sort this col"
MyArray(2, 2) = "B col2   row2 - sort this col"
MyArray(2, 3) = "A col2   row3 - sort this col"
MyArray(2, 4) = "C col2   row4 - sort this col"
MyArray(3, 1) = "A col3  row1"
MyArray(3, 2) = "D col3 row2"
MyArray(3, 3) = "B col3 row3"
MyArray(3, 4) = "C col3 row4"
MyArray(4, 1) = "D col4 row1"
MyArray(4, 2) = "C col4 row2"
MyArray(4, 3) = "B col4 row3"
MyArray(4, 4) = "A col4 row4"
```

so going by this principal i tried to sort the array by the 2nd column. I tried various examples from other sites but they all say that "subscript out of range"

Code:

```
Dim MyArray(1 To 4, 1 To 4)
Dim i As Integer, j As Integer

MyArray(1, 1) = "A col1 row1"
MyArray(1, 2) = "C col1  row2"
MyArray(1, 3) = "D col1  row3"
MyArray(1, 4) = "B col1  row4"
MyArray(2, 1) = "D col2  row1 - sort this col"
MyArray(2, 2) = "B col2   row2 - sort this col"
MyArray(2, 3) = "A col2   row3 - sort this col"
MyArray(2, 4) = "C col2   row4 - sort this col"
MyArray(3, 1) = "A col3  row1"
MyArray(3, 2) = "D col3 row2"
MyArray(3, 3) = "B col3 row3"
MyArray(3, 4) = "C col3 row4"
MyArray(4, 1) = "D col4 row1"
MyArray(4, 2) = "C col4 row2"
MyArray(4, 3) = "B col4 row3"
MyArray(4, 4) = "A col4 row4"

SortColumm1 = 1
SortColumn2 = 3
For i = LBound(MyArray, 1) To UBound(MyArray, 1) - 1
For j = LBound(MyArray, 1) To UBound(MyArray, 1) - 1
Condition1 = MyArray(j, SortColumn1) > MyArray(j + 1, SortColumn1)
Condition2 = MyArray(j, SortColumn1) = MyArray(j + 1, SortColumn1) And _
MyArray(j, SortColumn2) > MyArray(j + 1, SortColumn2)

If Condition1 Or Condition2 Then
For y = LBound(MyArray, 2) To UBound(MyArray, 2)
t = MyArray(j, y)
MyArray(j, y) = MyArray(j + 1, y)
MyArray(j + 1, y) = t
Next y
End If
Next
Next
```

Hi Experts,

I am a novice in using VBA or Macros in excel. I need a help in copying all the available rows from Individual Sheet say A, B & C that needs to be copied to Sheet D in the given below fashion in a Worksheet:

Copy Row1 from Sheet A
Copy Row1 from Sheet B
Copy Row1 from Sheet C

Output Results in Sheet D should be:
Row1 = Paste Row1 from Sheet A
Row2 = Paste Row1 from Sheet B
Row3 = Paste Row1 from Sheet C
Row4 = Paste Row2 from Sheet A
Row5 = Paste Row2 from Sheet B
Row6 = Paste Row2 from Sheet C

I have around 4224 rows in Sheets A, B & C that needs to be copied to Sheet D. Hope i have explained what i am looking at above clearly. If you need any clarifications then, please let me know.

Your help would be greatly appreciated...

Thanks & Regards,
Kaushal

I have:

Col A----Col B----Col C
row1 cow cat
row2 dog
row3 sheep

I need:

For all rows, if Col B has data but Col C does not, move data from Col B into Col A and down one row

Col A----Col B----Col C
row1 cow cat
row2
row3 dog
row4 sheep

Hi,

This is my first ever post as I'm new to VBA, so forgive any sloppy code or inadvertant breach of etiquette.

My problem is I’m not able to influence the ending row (where the loop stops) of a ‘For’ loop to reflect rows inserted during its execution.

I am writing a spreadsheet macro where there will be a different number of rows each time it is run. My macro correctly determines the final row and then runs a ‘For’ loop to process every row.
When I encounter a change of, in this case a contract number I insert a line and I then increment my counter and the variable holding the row count by one.

The problem is that the execution still stops when the current row is equal to the starting value of the variable final row – stopping short of the last row. How do / can I influence where the loop stops once I’m in the loop?
Code:

```Dim FinalRow            As Integer
Dim i                       As Long
.
.
FinalRow = Cells(65536, 1).End(xlUp).Row
For i = 2 To FinalRow
.
.
i = i + 1
Cells(i, 1).Select
ActiveCell.EntireRow.Insert shift:=xlDown
FinalRow = FinalRow + 1
.
.
Next i
```

dear everyone,
I have 3 columns say
colA colB Col C
row1 1 A pen
row2 2 B sit

now i want my output to be like

colA colB Col C
row1 1 A pen
row3 2 B sit

that is i want to group all the As in the column B and allow it to display
only once for howmany ever rows we have in col C.
The main thing is that these rows get filled from another sheet. therefore
they are dynamic, i may have any number of rows in this sheet.
I want to do this kind of grouping inside a macro. kindly help

Thread Locked as Title infringes forum rules

I have an excel chart ( XY scatter, compares pairs of values.)

How can I make it read data the following way:
for the first point
legend comes from (Column A:row1)
x axis value comes from (columnA:row2)
y axis value comes from (columnA:row3)

for the second point
legend comes from (Column B:row1)
x axis value comes from (columnB:row2)
y axis value comes from (columnB:row3)

for the third point
legend comes from (Column C:row1)
x axis value comes from (columnC:row2)
y axis value comes from (columnC:row3)

and so on...

Thanks for any help anybody can give...

Vivek

I have a csv file with roughly 4k rows. I am trying to avoid doing this process manually. What I need is to duplicate every row and change a few values systematically. So real world example is something like this:

Row1
Row2
Row3
Row4

Becomes

Row1
Row1-copy
Row2
Row2-copy
Row3
Row3-copy
Row4
Row4-copy

Then I need to

delete the values from columns B,C,D,F from just the copied rows.
delete the value from column H and change it to "SCAN" on just the copied rows
append "-scan" to the end of column M on just the copied rows
column S value needs do be deleted and changed to 6.99 on just the copied rows
columns U and V need to be deleted and both changed to "FALSE"
column W value needs to be deleted.

Is something this complicated even possible? And if so where, oh where do I start?

Any and all tips/advice is greatly appreciated. If there is a service that can build this as a (macro?, function?) for a fee that would even work.

Thanks! and Best!
Jamie

I have an excel chart ( XY scatter, compares pairs of values.)

How can I make it read data the following way:
for the first point
legend comes from (Column A:row1)
x axis value comes from (columnA:row2)
y axis value comes from (columnA:row3)

for the second point
legend comes from (Column B:row1)
x axis value comes from (columnB:row2)
y axis value comes from (columnB:row3)

for the third point
legend comes from (Column C:row1)
x axis value comes from (columnC:row2)
y axis value comes from (columnC:row3)

and so on...

Thanks for any help anybody can give...

Vivek

Question 1:
I would like to alert the user if a line of data does not adhere to the following validation rules listed below. The user will then need to manually correct the data and the template will not perform any auto-correction of the data for the user.
a) Header – Check that ‘PODAgentDetails’ exists.
b) SO – Check that the length is 10 digits.
c) SR – Check that the length is 11 characters long (inclusive of ‘SR’ characters)
d) CourierDay & PODDay – Check that the date is in the correct mm/dd/yyyy format. It will also check if that the ‘mm’ field is between 1 to 12.
e) CourierTime & PODTime – Check that the time is in the correct hh:mi:ss format. Check that ‘hh’ is between 0 to 23, ‘mi’ is between 0 to 59 and ‘ss’ is between 0 to 59

Question 2:
The input of the data to this excel sheet, might be key in or paste. How to protect the cell validation rules if we paste one row or column data on the it.

Question 3:
Any suggestion how to let the user manually see the problem of the key in or paste data format is wrong? ( maybe auto checking - circle/colour the cell)

Thanks for all suggestion for helping.

I was wondering if anybody could help me. Here is my problem:

Row1 ? Row2 10 Row3 20 Row4 Sum(Row1:Row3) I want to make Row1 equal to a number that is always going to make my sum equal to 1.5, how can I do that? That would not only create a circular reference but I am not sure about the formula.

Thanks for the help,

Mark

Hi,

I will appreciate your help on my project. As shown in the attached file, I have data from Columns A to G. I want to do the following:

1. Look for duplicates in all column A
2. For each duplicate found in column A, check if all values in columns B, C and D are also duplicates (The condition is all 4 columns must have the same values)
3. If the condition in (2) is satisfied, compare column E for all the rows; select the row with the minimum value in column E, and delete the other rows.

For example:

A B C D E F G

Row1:Test01 100 Class 1 1 80.67 6.47 145
Row2:Test01 50 Class 1 3 80.25 6.71 598
Row3:Test01 100 Class 1 1 77.72 6.62 110

Since Rows 1 and 3 have the same values in columns A, B, C and D; and Row3 value in column E is less than Row1 value (77.72<80.67); Delete Row1

Results

A B C D E F G

Row2:Test01 50 Class 1 3 80.25 6.71 598
Row3:Test01 100 Class 1 1 77.72 6.62 110

Hi,

I tried to find a macro on this forum which can transpose a set of rows to columns, but could not find one that solves my needs. Can anyone help me out? Much thanks in advance

Problem description (sample Excel 2010 File attached):

> Excisting Data

Row1: WireWay
Row2: Manufacturer of wire-management control systems
Row3: http://www.wireway.com
>Row4: Empty Row
Row5: Marrow Lin Development Co., Ltd.
Row6: Manufacturer of copper terminals
Row7: http://www.marrowlin.com
>Row8: Empty Row
...next till end

> Need to become:

Row1>Column1: WireWay
Row1>Column2: Manufacturer of wire-management control systems including modular
Row1>Column3: http://www.wireway.com
Row2>Column1: Marrow Lin Development Co., Ltd.
Row2>Column2:Manufacturer of copper terminals
Row2>Column3:http://www.marrowlin.com

EXAMPLE:

Row2 A2:12 B2:25 C2:36 D2:48 E2:56 G2:56
Row3 A3:1 B3:0 C3:1 D3:2 E3:4

Row2 shows 5 different numbers

Row3 relates to the Row2 number, Row 3 is the number of times Row2 number has hit.

I'm looking for a formula which picks the "highest" hit number (Row3) and places the appropriate Row2 number in the G2 cell.

This would be an automatic update since hits per number increase over time.

Thanks for the help...

Hi everbody,

In the example table below I have a data in 4 rows

Example Table:
*

A

B

C

D

1

Row1

Row2

Row3

Row4

2

0

0

0

0

3

2

5

1

1

4

3

0

2

2

5

4

1

3

3

6

5

2

4

4

7

6

3

0

5

8

7

4

1

6

9

8

5

2

7

10

9

6

3

8

11

10

7

4

9

12

11

8

5

10

13

12

0

6

11

14

13

0

7

12

15

14

1

8

13

16

15

2

9

14

17

16

3

10

15

18

17

4

11

0

19

18

5

0

1

20

19

6

1

2

21

20

7

2

0

22

21

8

3

1

23

22

9

4

2

24

23

10

5

3

25

24

11

6

4

26

0

12

7

5

27

1

13

8

6

28

0

14

9

7

29

1

15

0

8

30

2

16

1

9

31

0

17

2

10

32

1

18

3

11

33

2

19

4

12

34

3

20

5

13

35

4

21

6

14

36

5

22

7

0

37

6

23

8

0

38

7

24

9

1

39

8

25

10

2

40

9

26

11

3

41

10

0

12

4

42

11

1

13

5

43

12

2

14

6

44

13

3

15

7

45

14

4

16

8

46

15

5

17

9

47

16

6

18

0

48

17

7

19

1

49

18

8

0

2

50

19

9

1

3

51

20

10

2

4

52

21

11

3

5

53

22

0

4

6

54

23

1

5

7

55

24

2

6

8

56

25

0

7

9

57

26

1

8

10

58

0

2

9

11

Is it possible to extract highest value after Zero(0) from each column and get result as shown below

Result Table
*

A

B

C

D

1

Row1

Row2

Row3

Row4

2

24

5

4

15

3

1

8

11

2

4

2

26

9

14

5

26

11

19

9

6

2

9

11

7

2

8

9

10

11

12

13

14

15

16

17

18

19

Thanks And Regards,
Moti

Hi guys,

I have a problem with VBA I need to overcome.

OK, so, I have three Worksheets:

Data_Sheet – this contains a table of data with three columns; Date, Sales, Cost
Pivot_Sheet – this contains a pivot table of the data within the Data worksheet
Controls_Sheet – This contains a parameter which I would like to use to control the pivot table

What I would like to do is to change the date value in Controls_Sheet!B2, then run a macro, which would then filter all date values except the value within Controls_Sheet!B2.

So for example, if these are my dates within the ‘Dates’ column of my Pivot Table:

31/07/2010
07/08/2010
14/08/2010
21/08/2010
28/08/2010
04/09/2010

Then I set Controls_Sheet!B2 equals ‘04/09/2010’ then run the macro, only the line for ‘04/09/2010’ will be showing in the pivot table.

I have tried many codes all which seem not to work, so I haven’t posted them here. I have posted the example work sheet.

I’m sure this is simple buy I’m struggling with it. Thanks in advance.

Hello,

I am trying to create a macro that will compile data for me in a visual way. Here is the best description I can give:

The workbook has one worksheet in it which is the compilation, and several (uncertain number) more worksheets which are identical to one another from which data will be compiled.

In these worksheets, each row is a different person's info, with column A of that cell having the person’s name, and column W having their total score (those are our only concerns for compilation). The row number where this starts is row 10, and continues down until each person from that group is entered (various numbers of people per worksheet). Above row 10 is various non-important info. below the last persons name will be a blank space.

What I would like the macro to do is check each individual, then copy their name on the compilation, in a column that corresponds with their score.
The columns are as follows:
A – Below 54
B – 54-55
C- 56-59
D – 60-63
E – 64-65
F- 66-69
G – 70-73
H – 74-75
I – 76-79
J – 80-83
K – 84-85
L – 86-89
M – 90 – 93
N – 94-95
O – 96-99
P – 100-103
Q – 104-105
R-106-109
S- 110-113
T – 114-118
U – 119-123
V – 124-128
Starting with the 4th row in that column, and one lower with each subsequent person in that scoring range.

So, if Billy (from a10 on the first worksheet) scored 104 (from w10), it would copy “Billy” from a10 into q4 on the compilation. It would then check the next person, and continue through that worksheet until there are no more names, then move to the next worksheet and continue until there are no more worksheets.

Is this possible?

Thanks!

EDIT: Sorry about all the numbers, i just wanted to give you an idea. I dont know how to get it to place according to a specific set of ranges, or how to get it to switch to the next worksheet at a blank space without an error.
Thank you so much!

Sorry if this is such an easy question:
Have a spreadsheet with 4 columns of data, I am not interest in ColA
Row1 ColB shows as ABCDEF WWWW YYY ColC shows as 12345 67890
Row2 ColB shows as ABCDEF HHH ColC shows as 12345 67890
Row3 ColB shows as ABCDEF ColC shows as 12345 67890
Row4 ColB shows as ABCD 986753412 ColC shows as 09876 54321
Row5 ColB Shows as ABCD ColC shows as 09876 54321
So if ColC on Row2 matches ColC on Row1 and the first section of ColB Row2 (ABCDEF) matches the same section of ColB Row1 and Row2 ColD Value to Row1 ColD value etc etc.
The code I am using seems to work until it gets to Row3 (where there is nothing after the first section)
"Code"
If Application.WorkSheetFunction.IsNumber(Application.WorkSheetFunction.Find(" ",Cells(StrtRow,2)) Then
Col2Eend=Application.WorkSheetFunction.Find(" ",Cells(StrtRow,2))
Col2Srch=Mid(Cells(StrtRow,2),1,Col2End)
Else
col2Srch=Cells(StrtRow,2).Value
End if
"Code"
Can't use TextToColumns since there could be 3 instances of spaces in ColB or 4 or 2 or none
Ideally (unless someone has a better idea of course) I think I would like to just strip out anything after the first space in ColB so I just end up with ABCDEF or ABCD etc
Help would be greatly appreciated

pivot_test.xlsmI have a problem just like this which I want to overcome with VBA.

OK, so, I have three Worksheets:

Data_Sheet – this contains a table of data with three columns; Date, Sales, Cost
Pivot_Sheet – this contains a pivot table of the data within the Data worksheet
Controls_Sheet – This contains parameter which I would like to use to control the pivot table

What I would like to do is to change the date value in Controls_Sheet!B2, then run a macro, which would then filter all date values except the value within Controls_Sheet!B2.

So for example, if these are my dates within the ‘Dates’ column of my Pivot Table:

31/07/2010
07/08/2010
14/08/2010
21/08/2010
28/08/2010
04/09/2010

Then I set Controls_Sheet!B2 equals ‘04/09/2010’ then run the macro, only the line for ‘04/09/2010’ will be showing in the pivot table.

I have tried many codes all which seem not to work, so I haven’t posted them here.

Any help would be greatly appreciated.

I have two rows with values and blanks at the end (but I don't know how many blanks). For example,

Row1: A C E G * * *
Row2: H A C F I * * * *

* is blank
The values could be either text or numbers (but not both at the same time).
Each individual row has unique values (no duplicate values in each row).

1. I would like to know how many values there are in Row2 that doesn't exist in Row1, ignoring the blanks. In the example above, there are 3 values in Row2 that doesn't exist in Row1 (H, F, I).

2. Alternatively, I would like to know how many of the values in Row1 also exist in Row2 (this is actually the final result that I need and it can easily be calculated from # of values in Row2 - result above = 5-3=2 ).

Could someone propose a formula for this?
TIA!

Given a table containing cell values of either 1 or 0, I'd like to be able to calculate the maximum number of adjacent "1" values in each row.

So, for instance, given the following matrix...

ROW1 00001101111111000011100
ROW2 00000011100011000010000
ROW3 00111101111110111010000
ROW4 00011010000000000000000
ROW5 00001001000010001001111

I'd like to automatically calculate the following values (longest string of adjacent '1' values for each row):

ROW1 7
ROW2 3
ROW3 6
ROW4 2
ROW5 4

What's the best way to achieve this?

Thank you

Hi I need help with lookup, let’s say I’m selling shoes and I have a list, the first column is the date, 2nd column is the shoe size, 3rd column is color, 4th column is the price, that has to be looked up in a table with all information that’s listed in a lot of rows the same way as the first column is the date 2nd column is the shoe size 3rd column is color 4th column is the price. (Example 1st row [1/5/10], [5], [black], [\$45] – 2nd row [1/5/10], [5], [brown], [\$48] - 3rd row [1/5/10], [10], [black], [\$61] – 4th row [1/5/10], [10], [brown], [\$63] – 5th row [1/10/10], [5], [black], [\$35] – 6th row [1/10/10], [10], [brown], [\$40] ) now the lookup should work like this the first column is the date - [1/6/10] , 2nd column is the shoe size – [9] , 3rd column is color – [brown] , 4th column is the price should bring me back the price of row 6 that’s [\$40] as you see in the example.

First of all thanks to all who have helped with this project to far. The Userform prototype is up and running and is so far ‘idiot proof’ {hurriedly touching wood}

‘It feeds the below data sheet’…..

DATE NUMBER OF staff SHIFT LENGTH STAFF HOURS Sales section 1 Productivity 1 Productivity 2 Productivity 3 23-Jan-08 1 8 8 Counter 1 0 0 0 23-Jan-08 5 10 50 Counter 2 2 0 0 26-Jan-08 6 9 54 Counter 3 0 0 0 26-Jan-08 8 8 64 Counter 4 0 0 0 26-Jan-08 11 8 84 Counter 5 0 0 0 26-Jan-08 13 5 63.5 Counter 6 0 0 0 24-Jan-08 10 8 80 Counter 7 6 0 0 24-Jan-08 8 3 24 Counter 8 0 0 0 25-Jan-08 5 9 45 Counter 9 0 0 0

But now the bosses want a ‘summary sheet’ (it was expected but they didn’t know what to ask for till I showed the project so far.)

From: 01/Jan/2008 To: 10/Feb/2008 Counter "1-12" section 1 Productivity1 0 Productivity2 0 Productivity3 0 Productivity4 0 Productivity5 0 Staff Hours 0 0 0 0
I’ve tried the following without success. I have always had trouble with nested formulae… can any one show where I’m going wrong please???? PLEASE!!!!!!

{=SUMPRODUCT (( Date >= start )*( Date = start )*( Date = start )*( Date