highlight values which summed are equal to a predefined data

%3CLINGO-SUB%20id%3D%22lingo-sub-2198977%22%20slang%3D%22en-US%22%3Ehighlight%20values%20which%20summed%20are%20equal%20to%20a%20predefined%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2198977%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20this%20problem%20and%20a%20solution%20would%20help%20me%20a%20lot%20by%20saving%20time.%3C%2FP%3E%3CP%3Epls%20look%20at%20below%20example%3C%2FP%3E%3CP%3Esheet%201%3A%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%22192%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%20height%3D%2219%22%3Ename%3C%2FTD%3E%3CTD%20width%3D%2264%22%3Ereceived%3C%2FTD%3E%3CTD%20width%3D%2264%22%3Eorder%20nr%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3Eana%3C%2FTD%3E%3CTD%3E20%3C%2FTD%3E%3CTD%3Eaaa%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3Eana%3C%2FTD%3E%3CTD%3E12%3C%2FTD%3E%3CTD%3Ebbb%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3Eana%3C%2FTD%3E%3CTD%3E10%3C%2FTD%3E%3CTD%3Eccc%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3Edavid%3C%2FTD%3E%3CTD%3E10%3C%2FTD%3E%3CTD%3Eddd%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3Edavid%3C%2FTD%3E%3CTD%3E11%3C%2FTD%3E%3CTD%3Eeee%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3Edavid%3C%2FTD%3E%3CTD%3E12%3C%2FTD%3E%3CTD%3Efff%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3Edavid%3C%2FTD%3E%3CTD%3E12%3C%2FTD%3E%3CTD%3Eggg%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eshhet%202%3A%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%22128%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%20height%3D%2219%22%3Ename%3C%2FTD%3E%3CTD%20width%3D%2264%22%3Etotal%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3Eana%3C%2FTD%3E%3CTD%3E32%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2219%22%3Edavid%3C%2FTD%3E%3CTD%3E24%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20a%20function%20that%20can%20highlight%20the%20values%20in%20sheet%201%20which%20summed%20are%20equal%20to%20the%20values%20in%20sheet%202.%3C%2FP%3E%3CP%3Ethank%20you%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2198977%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2199066%22%20slang%3D%22de-DE%22%3ESubject%3A%20highlight%20values%20which%20are%20summed%20up%20equal%20to%20a%20predefined%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2199066%22%20slang%3D%22de-DE%22%3EIn%20your%20picture%2C%20for%20example%2C%20you%20cannot%20see%20where%20the%20words%20%22Ana%2C%20David%2C%20etc.%22%20takes%20the%20value.%3CBR%20%2F%3EIt%20is%20not%20clear%20what%20your%20plan%20is.%3CBR%20%2F%3EWith%20your%20permission%2C%20if%20I%20can%20recommend.%20It%20can%20help%20us%20all%20if%20you%20upload%20an%20Excel%20file%20(without%20sensitive%20data)%2C%20no%20picture.%20Even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%20You%20could%20get%20a%20precise%20solution%20much%20faster%20with%20a%20file%20(w%2Fout%20sensitive%20data).%20This%20would%20also%20be%20a%20blessing%20for%20all%20of%20us%2C%20as%20we%20can%20understand%20the%20problem%20much%20better%2C%20a%20win-win%20situation%20for%20everyone.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20understanding%20and%20patience%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Wish%20you%20a%20nice%20day.%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
New Contributor

Hello,

I have this problem and a solution would help me a lot by saving time.

pls look at below example

sheet 1:                                            

namereceivedorder nr
ana20aaa
ana12bbb
ana10ccc
david10ddd
david11eee
david12fff
david12ggg

 

shhet 2:

nametotal
ana32
david24

 

I need a function that can highlight the values in sheet 1 which summed are equal to the values in sheet 2.

thank you 

5 Replies
In your picture, for example, you cannot see where the words "Ana, David, etc." takes the value.
It is not clear what your plan is.
With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. You could get a precise solution much faster with a file (w/out sensitive data). This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.

Thank you for your understanding and patience

Wish you a nice day.

Nikolino
I know I don't know anything (Socrates)

@Nikolino , 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?

For me it would have made a lot of sense to have a file to understand what exactly you want. please also understand that we as humans do not understand everything. As in your case, I unfortunately can't understand how you get 32 when you add 42 to Ana. Anyway I can't help you without a file. Perhaps one of the professionals will contact you here, who certainly know more than an ignorant person like it is, and give you the desired solution.

Wish you a nice day.


Thank you for your understanding and patience

Nikolino
I know I don't know anything (Socrates)

@livius81 

The main problem would appear to be knowing what to highlight; the formatting is the trivial part!

 

image.png

thanks a lot Peter, this is what I need.