1. Pls change Cell W3 From "Pull 1 i.e F Column Data" To "Pull 2 i.e F Column Data"
2. Cell L7 Array Formula , Drag down and across (From L7 To AF8)
HTML Code:
1. Pls change Cell W3 From "Pull 1 i.e F Column Data" To "Pull 2 i.e F Column Data"
2. Cell L7 Array Formula , Drag down and across (From L7 To AF8)
HTML Code:
L3 row is not required to get match.I think the formula is ok but array formula slows down as I have to copied down to 3500 rows.
Last edited by AliGW; 06-21-2021 at 08:50 AM. Reason: PLEASE don't quote unnecessarily!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks