CODEWITHSUNDEEP
excel
Arbelac
Arbelac

Reputation: 1904

Getting data from specific multiple columns

Below is all the value that has been given. However, I would like to extract the values from the each row such as C,F,I,L columns and so on. BTW , it may be different columns for each rows like below. not matter how many columns.

and below is the result that I would like to have.

enter image description here

Upvotes: 0

Views: 53

Answers (1)

Scott Craner
Scott Craner

Reputation: 152505

Use this formula:

=IFERROR(INDEX($A6:INDEX(6:6,MATCH("zzz",6:6)),,INT((COLUMN(A1)-1)*3)+3),"")

It will return the value in every third column as it is copied across.

enter image description here

Upvotes: 1

Related Questions