Can the result copy the highlighted cell and the color of the text? They are all equal part numbers but one list has parts that are end of life (marked by red font) and last time buy (marked by blue font.)
You saved me a lot of time :) thanks for the clear explanations. For some reason the comma "," wasn't working for me, I've replaced it with a ";" and it works like a charm !
How should i go about if I have a re-acuring list of values i need to match. For example: In list 1 i have values that i need to match to list 2,3 and 4 and on list five i have new values that could be in list 3,4 and 6. Should i just add to the formula the range and say it should look something like this ISNUMBER(MATCH(F2,List2!$F:$F,List3$F:$F,0)) or how should i go about it? Thank you in advance!
You can actually check for empty by adding RANGE"" into the filter, as the values are treated as if they were in an arrayformula
That would have been nicer!
This video was so helpful!! Thank you for sharing!!
:)
This is a thing of beauty!
:)
Can the result copy the highlighted cell and the color of the text? They are all equal part numbers but one list has parts that are end of life (marked by red font) and last time buy (marked by blue font.)
excelent!!
Can you do this for multiple rows?
You saved me a lot of time :) thanks for the clear explanations.
For some reason the comma "," wasn't working for me, I've replaced it with a ";" and it works like a charm !
ruclips.net/video/ljvB2arCsNQ/видео.html
How should i go about if I have a re-acuring list of values i need to match.
For example:
In list 1 i have values that i need to match to list 2,3 and 4 and on list five i have new values that could be in list 3,4 and 6. Should i just add to the formula the range and say it should look something like this ISNUMBER(MATCH(F2,List2!$F:$F,List3$F:$F,0)) or how should i go about it?
Thank you in advance!
can you do that by script editor?
Thank you.. (salute)
👍
Thank you!
This is great, but what if there were multiples of the same stock number in a list? could you store those in an array somehow?
ruclips.net/video/_qEc8CEgUl4/видео.html
It is a pity my computer is not good with the graphics cus at the beginning and at 17min it blurs and I couldn't follow. It's a pity!
It most likely has nothing to do with graphics and caused by internet connection. Just change the video to higher resolution when it blurs.
@@ExcelGoogleSheets Thank you sir, I will.
@@ExcelGoogleSheets I did what you said and it worked, thanks. Thanks for taking the time sir.