Results 1 to 2 of 2
2004-07-28, 12:20 #1
- Join Date
- May 2001
- Philadelphia, Pennsylvania
- Thanked 0 Times in 0 Posts
Modifying Unique extract (Excel 2000)
I am eternally grateful to Mr. Pearson for the formula "Extract Values on One List and Not ANother" on his website. Helping tremendously on a mass reconciliation project. One complication that it can't handle as currently written is when, in list A there are 3 similar amounts but only 2 similar amounts in list B. I wonder if and how one might amend that formula to say something to the effect of "if the sum of all amounts x in column A is not the sum of all amounts x in column B" then ... I could see that as a problem because the cell-by-cell formula would still show the amount in each relevant cell. I thought it might be interesting to propose the question. The current formula as I have it is:=IF(COUNTIF($C$9:$C$1504,H10)=0,H10,"ok"). Thanks for any observations.
2004-07-28, 15:23 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- Thanked 342 Times in 335 Posts
Re: Modifying Unique extract (Excel 2000)
Not sure exactly what you are after. If you want to display numbers that have more in C than in Col H you can use something like:
<pre>=IF(COUNTIF($C$9:$C$1504,H10)>COUNTIF($H$9:$H $1504,H10),H10,"ok"). </pre>
If you autofilled this, you would get a list of only the values that COl C had more than COl H otherwise it would give "ok"
Is this what you want? If not could you elaborate.