Dear All
could anyone help me find how many cells matched the creteia based in adjacest cells as shown in attached spreadsheet and picture?
Thanks
Dear All
could anyone help me find how many cells matched the creteia based in adjacest cells as shown in attached spreadsheet and picture?
Thanks
GUURE
Based on that sample, what would the answers be?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you FDibbins
I want to put formulas in B10:B12 that reflects on desired results in C10:C12
Thanks again
Last edited by AliGW; 12-05-2019 at 02:19 AM. Reason: Please don't quote unnecessarily!
Apologies if I was not clear, I meant, what would the actual answers here be?
OK If I understand you correctly...
equal pay =SUMPRODUCT(--($C$4:$C$8=$D$4:$D$8))
Overpay=SUMPRODUCT(--($C$4:$C$8>$D$4:$D$8))
Underpay=SUMPRODUCT(--($C$4:$C$8<$D$4:$D$8))
The second and third questions are easy:
=SUMPRODUCT(1*($C$4:$C$8<$D$4:$D$8))
=SUMPRODUCT(1*($C$4:$C$8>$D$4:$D$8))
The first is not clear. Do you want the number of people getting the same pay? If so, what happens if, for example, two are getting 40 and two 60 - what would the answer be?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Ali, I think you got those 2 the wrong way round?
overpaid = 1 (Ahmed)
underpaid = 2 (last 2)
Dear All Thank you for your help.
I have got how I wanted.
@Dear AliGW, I meant how many have got the exact amount (not under paid, nor over paid).The first is not clear. Do you want the number of people getting the same pay? If so, what happens if, for example, two are getting 40 and two 60 - what would the answer be?
I really appreciated all your support.
Thanks again
Ahmed
Hi Dear, Just one thing.. can I ignore in balank rows?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks