Mar 10 2021 02:15 AM
Hello,
I have this problem and a solution would help me a lot by saving time.
pls look at below example
sheet 1:
name | received | order nr |
ana | 20 | aaa |
ana | 12 | bbb |
ana | 10 | ccc |
david | 10 | ddd |
david | 11 | eee |
david | 12 | fff |
david | 12 | ggg |
shhet 2:
name | total |
ana | 32 |
david | 24 |
I need a function that can highlight the values in sheet 1 which summed are equal to the values in sheet 2.
thank you
Mar 10 2021 03:03 AM
Mar 10 2021 03:53 AM
@NikolinoDE , I really am grateful to your reply and suggestions, but I still think that putting the files up here won't make any difference.
pls see my problem like this
I have a sum of 32 $ ( the number in sheet 2 ) and I need to close to Ana only the orders ( sheet 1 ) which summed are 32
how can I highlight the orders that will close that number in the second sheet, for every entity ana, david,....etc?
Mar 10 2021 04:28 AM
Mar 10 2021 04:48 AM
The main problem would appear to be knowing what to highlight; the formatting is the trivial part!
Mar 10 2021 06:00 AM