Hi guys,
I'm looking for a formula to complete a worksheet based on some references in another sheet.
Pls see attached. Capture.JPG
Hi guys,
I'm looking for a formula to complete a worksheet based on some references in another sheet.
Pls see attached. Capture.JPG
Last edited by Vali_ro; 11-09-2018 at 08:12 AM.
Erm ...
Welcome to the forum, by the way!
Your title and visual are both far too vague - what exactly are you trying to do?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi,
Thanks for the warm welcome,btw.
Excel newb here. Is this making more sense?
Capture.JPG
So you want to replicate everything four times?
Indeed , this is the final goal.
OK - please adjust the title of the thread via your opening post (Edit - Go Advanced) to reflect what you are trying to do. Thanks!
please try this,
=INDEX($A$1:$A$18,INT((ROWS(B$1:B1)-1)/4)+1)
gondal,
works like a charm..now I am trying to understand how it's structured
Thanks a bunch!
...another approach of course and not using formulae would be to copy A1:A15 and paste it three times in A16, A31 and A46, then sort column A.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks