I'm attempting to execute a simple calculation when the value of a cell on my report sheet is found in a one-column range on a rawdata sheet. The other sheet includes many duplicates. The formula works on the first instance of a match, but subsequent matches fail.
With the help of CPearson (=IF(COUNTIF(Details!$A$1:A2,Details!A2)=1,Details!A2,""), i've tried building of list of unique values from which to execute my matching criteria...but, alas, no success.
Here's the detail.
=IF(Details!$A$2:$A$304=A:A,(SUM(MiniTables!$L$3:$L$7)/MiniTables!$M$3),"")
Details!$A$2:$A$304 is a range on another sheet with 250+ values, only 10 of which are unique. About 10 cells are blank.
A:A is a full list of real estate properties in a portfolio. I only want to report on them if there is activity as indicated by the "details!" sheet. If there is no match, i leave the cell blank. If there is a match, i do a simple calculation:
Sum a range of cells (L3:L7) and then devide it by a number (M3).
I have no hair left to lose on this one. A little help here?
bb
[/code]
With the help of CPearson (=IF(COUNTIF(Details!$A$1:A2,Details!A2)=1,Details!A2,""), i've tried building of list of unique values from which to execute my matching criteria...but, alas, no success.
Here's the detail.
=IF(Details!$A$2:$A$304=A:A,(SUM(MiniTables!$L$3:$L$7)/MiniTables!$M$3),"")
Details!$A$2:$A$304 is a range on another sheet with 250+ values, only 10 of which are unique. About 10 cells are blank.
A:A is a full list of real estate properties in a portfolio. I only want to report on them if there is activity as indicated by the "details!" sheet. If there is no match, i leave the cell blank. If there is a match, i do a simple calculation:
Sum a range of cells (L3:L7) and then devide it by a number (M3).
I have no hair left to lose on this one. A little help here?
bb
[/code]