- Joined
- Aug 23, 2012
- Messages
- 4
- Reaction score
- 0
Hi,
I was hoping some one could help me with a formula I need. I have to find which customers (ID and Value) still owe the same amount in Col D
Column A2 to A1491 & Column B2 to B1491 & Column C C2 to C14091 and Column D D2 to D14091
Column A Column B Column C Column D
Customer ID Value Customer ID Value
1234 100 1231 100
1244 50 1234 100
1245 100 1240 50
1244 25
1245 100
Eg show Customer ID 1234 and 1245 still owe the same amount today.
I can show which client ID's are the same using =countif(a$2:a$1491,c2) unsure how to finish.
Thank you very much
I was hoping some one could help me with a formula I need. I have to find which customers (ID and Value) still owe the same amount in Col D
Column A2 to A1491 & Column B2 to B1491 & Column C C2 to C14091 and Column D D2 to D14091
Column A Column B Column C Column D
Customer ID Value Customer ID Value
1234 100 1231 100
1244 50 1234 100
1245 100 1240 50
1244 25
1245 100
Eg show Customer ID 1234 and 1245 still owe the same amount today.
I can show which client ID's are the same using =countif(a$2:a$1491,c2) unsure how to finish.
Thank you very much