COMPARAR 2 HOJAS DE EXCEL Y ESCRIBIR FORMULA PARA QUE SE SELECCIONEN LOS DATOS QUE COINCIDAN

%3CLINGO-SUB%20id%3D%22lingo-sub-2733735%22%20slang%3D%22es-ES%22%3ECOMPARE%202%20EXCEL%20SHEETS%20AND%20WRITE%20FORMULA%20TO%20SELECT%20MATCHING%20DATA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2733735%22%20slang%3D%22es-ES%22%3E%3CP%3EI%20NEED%20TO%20COMPARE%20TWO%20EXCEL%20SHEETS%20FROM%20DIFFERENT%20WORKBOOKS%2C%20AND%20WRITE%20A%20FORMULA%20SO%20THAT%20THE%20SAME%20DATA%20IS%20MARKED%20IN%20BOTH%20FILES.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2733735%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2733766%22%20slang%3D%22es-ES%22%3ERe%3A%20COMPARE%202%20EXCEL%20SHEETS%20AND%20WRITE%20FORMULA%20TO%20SELECT%20MATCHING%20DATA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2733766%22%20slang%3D%22es-ES%22%3ECOMPARE%202%20EXCEL%20SHEETS%20AND%20WRITE%20FORMULA%20TO%20SELECT%20MATCHING%20DATA%20%3CBR%20%2F%3E%20I%20NEED%20TO%20COMPARE%20TWO%20EXCEL%20SHEETS%20FROM%20DIFFERENT%20WORKBOOKS%2C%20AND%20WRITE%20A%20FORMULA%20SO%20THAT%20THE%20SAME%20DATA%20IS%20MARKED%20IN%20BOTH%20FILES.%3C%2FLINGO-BODY%3E
New Contributor

NECESITO COMPARAR DOS HOJAS EXCEL DE LIBROS DIFERENTES, Y ESCRIBIR UNA FÓRMULA PARA QUE LOS DATOS IGUALES SE VAYAN MARCANDO EN AMBOS ARCHIVOS.

1 Reply
COMPARE 2 EXCEL SHEETS AND WRITE FORMULA TO SELECT MATCHING DATA
I NEED TO COMPARE TWO EXCEL SHEETS FROM DIFFERENT WORKBOOKS, AND WRITE A FORMULA SO THAT THE SAME DATA IS MARKED IN BOTH FILES.