Can anyone flip this formula...

[jwillis07]

Hi all,

In one sheet I have two columns of data:

---A---B---
1--A---1
2--B---2
3--C---5
4--D---4
5--E---6
6--F---3
7--G---6

Originally, what I needed in a separate sheet was to create a list of cells from A1:A7, where the cell next to in B1:B7 is greater than or equal to 5.

When copying the formula down it should then read:

---A
1--C (Content of A3)
2--E (Content of A5)
3--G (Content of A7)


This formula did just the job just fine... =IFERROR(INDEX($A$1:$A$7,SMALL(IF($B$1:$B$7>=5,ROW($A$1:$A$7)-ROW($A$1)+1),ROWS(C$1:C1))),"")


Does anybody know how to flip it though so instead of going down rows it would go across columns instead... such as...

---A---B---C
1--C---E---G
2--


Many thanks in advance.

Jason

[Tony Valko]

Just change:

ROWS(C$1:C1)

To:

COLUMNS($C1:C1)

Copy across as needed.