assigning appropriate values to the points

Actually no, because I wouldlike to have all values from column C in column G, but assigning to the appropriate points, so f.eg. the G1 cell should have value -1,221

So how are you calculating -1221.

Let us have other examples too so that we can check.

Yes, of course. I send the same Excel sheet with more values in column G

I think you sent exactly the same sheet.

Hi,

OK I can see that your -1.221 in G1 is an average of itself, i.e. G1, and is therefore circular. But it's not clear where the requirements of your first post fit in. i,e. the restriction on B=F & A=E. There are no rows where this condition is met.

Perhaps it would help if you'd describe in narrative form what you are wanting to do.

I did look at your latest sheet today and I repeat, I still don't understand

Tell me how you calculate G1 as -1.221. It's referring to itself and therefore being circular makes no sense. In fact if you hit the F2 key to edit it and immediately hit the Enter key you'll find it evaluates to zero.

Manually add some sample results that you expect to see - don't use any formulae, tell us which are the results cells and importantly describe in a narrative how you calculated them.

Hi,

You've still not explained how you are calculating the values in column G. You need to explain which other cells you are adding/averaging/deducting or whatever in order to produce the results of -1.221, 1.666 etc.

Your original post mentioned conditions to do with A=E & B=F but I can see no relationships anywhere which would provide the results you show.

Is it just co-incidence that the average of C1 & C2 is 1.221509.. i.e. similar to G1 but positive rather than the negative you show.

Why not just sort the data so it aligns?

	A	B	C	D	E	F	G
1	Data 11	Data 12	Data 13		Data 21	Data 22	Data 23
2	449791.408	262929.962	0.461		449791.408	262929.962
3	449792.887	262919.977	0.197		449792.887	262919.977
4	449796.407	262934.395	2.779		449796.407	262934.395
5	449796.463	262913.572	0.955		449796.463	262913.572
6	449797.416	262907.148	0.592		449797.416	262907.148
7	449800.086	262900.873	0.032		449800.086	262900.873
8	449803.239	262896.652	0.565		449803.239	262896.652
9	449803.348	262938.122	1.763		449803.348	262938.122	1.763
10	449805.748	262892.256	0.797		449805.748	262892.256
11	449807.679	262886.091	0.248		449807.679	262886.091
12	449809.824	262879.783	0.742		449809.824	262879.783
13	449810.971	262941.332	0.590		449810.971	262941.332
14	449811.690	262875.206	0.807		449811.690	262875.206

Hi,

You understand precisely the data you're working with. Remember we come to this cold. The important new clue for me is that the numbers are to be compared with any number in the relevant column and not with numbers on the row.

The following needs to be an array formula since some of your decimals, although they look to be the same, are not EXACTLY the same in Excel precision arithmetic terms. i.e. the calculation engine sees them varying at a very low decimal value. So enter this formula with Ctrl Shift Enter so that the in built ROUND() function will ignore extreme decimals.
So in G1 copied down

Formula:

Please Login or Register  to view this content.

Try:
=SUMPRODUCT(($A$1:$A$60=E1)*($B$1:$B$60=F1)*$C$1:$C$60)
Or
=LOOKUP(2,1/(($A$1:$A$60=E1)*($B$1:$B$60=F1)),$C$1:$C$60)

As Richard pointed out, some if the values aren't identical.