-
Extract and Copy Data from an Array to a Cell with Criteria
Dear friends, I hope you are well.
prueba.xlsm
What function or combination of functions should you use to be able to extract solely and exclusively those Data contained in the Ranges Índice "A" (MATRIZ2!$L$2:$L$2138), Índice "B" (MATRIZ2!$M$2: $M $2138 ), Índice "C" (MATRIZ2!$N$2:$N$2138) and Índice "D" (MATRIZ2!$O$2:$O$2138) of Sheet 4 (MATRIZ2) that meet the Year Criteria (MATRIZ2 !$ B$2:$B$2138;$H$6) and Month (MATRIZ2!$C$2:$C$2138;D$10) whose results can then be automatically copied to Sheet 10 (INDICES):
INDICE A - 2000 = D$11 Up to O$11
INDICE B - 2000 = D$18 Up to O$18
INDICE C - 2000 = D$25 Up to O$25
INDICE D - 2000 = D$32 Up to O$32
I will be very grateful for any guidance you can give me.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules