Excel Magic Trick 700: Return Every Other Cell (Cell Reference That Skips Columns) INDEX Function

Download Files:
people.highline.edu/mgirvin/Y...
See how to create a formula that will retrieve every other cell in a row as you copy the formula across the columns. INDEX function with a Number Incrementing formula element (uses INT & COLUMNS functions) that generates the numbers 1,1,2,2,3,3.
Download file: people.highline.edu/mgirvin/Ex...

[@excelisfun]

@rubyw0 , cool! I am glad that you like the video!

[@amoorinet..]

I followed more than 20 YT channel
but I didn't find like excelisfun,
excelisfun give solutions for everything

[@excelisfun]

Glad the channel helps you, aamir!!!!

[@M_Fahim_Rajpoot]

Super Duper Trick.... Thanks 😊

[@excelisfun]

You are welcome!

[@rubyw0]

i love you man

[@samantharaggett4204]

Hi, is it possible to add a Vlookup for the value it needs to return into the columns?

[@not2stupidguitar]

how do i do this backwards. i already have a sheet that looks like what you made, but i want to go back to what you started with. how do i do that?

[@usamamohammed9664]

Mr excel, Kindly can you show me how you can do the opposite of that. That is now you copy cell references that have space in between them to another template that dont have space.

[@excelisfun]

I do not know how that. Try post a question here:
mrexcel.com/forum

[@pdpstallion13]

Is there a way to do this so the tables are flipped? So the top table in the video would be the bottom table, and the bottom table in the video would be the top table.
So I want to be able to drag across the new bottom table and retrieve every other column value in the new top table??

[@markanthonyngare9795]

how do you return every other cell while you are using index and match?

[@excelisfun]

markanthony Ngare Here is a video I made;
Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2
ruclips.net/video/3daluFYyEko/видео.html

[@planxlsm]

6:20