In my file u can see on sheet2 example where i need for given name to exctract all times from sheet1 but it should be in cells C2 D2 E2 F2, now it works in c2 c3 c4 etc..
Thanks in advance
In my file u can see on sheet2 example where i need for given name to exctract all times from sheet1 but it should be in cells C2 D2 E2 F2, now it works in c2 c3 c4 etc..
Thanks in advance
Hi
In C2, again as an array formula and copied throughout the table
You had made A2 absolute at both column and row.Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Thanks a lot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks